Oracle Connection Error Code 12505
Contents |
here for a quick overview
Listener Refused The Connection With The Following Error Ora-12505 In Oracle Sql Developer
of the site Help Center Detailed answers to ora-12505 tns listener does not currently know of sid any questions you might have Meta Discuss the workings and policies of this
Ora 12505 Error In Sql Developer
site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us ora-12505 oracle 11g Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ORA-12505, TNS:listener ora 12505 solution does not currently know of SID given in connect descriptor up vote 81 down vote favorite 22 I have installed Oracle 11g Express Edition Release 2 in my windows 7 64 bit OS and tried to execute JDBC program, then I got the following error: java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412) at oracle.jdbc.driver.PhysicalConnection.
connect to the appropriate Oracle database, we'll need to expound a bit on how Oracle behaves and, therefore, what is causing this issue in the first place. SIDs vs SERVICE_NAMES It is important
Listener Refused The Connection With The Following Error Ora-12514
to understand the (slight) difference between what Oracle defines as a SID compared to ora 12505 error in oracle 12c a SERVICE_NAME, as we'll use this information to create a proper connection string later on. In Oracle, the system identifier
Ora-12505 Jdbc Thin Client
(or SID) is a local identifier of up to eight characters in length that is used to identify a particular database and differentiate it from other databases on the system. Often the SID http://stackoverflow.com/questions/18192521/ora-12505-tnslistener-does-not-currently-know-of-sid-given-in-connect-descript is the prefix word or DB_UNIQUE_NAME that precedes the DB_DOMAIN. For example, the SID of our bookstore database, as seen in in the full global database name of bookstore.company.com. SERVICE_NAMES, on the other hand, represent the names by which database instances can be connected to. A SERVICE_NAME will typically follow the format of the SID followed by the database domain, like so: DB_UNIQUE_NAME.DB_DOMAIN The TNS Listener When a https://chartio.com/resources/tutorials/how-to-fix-ora-12505-tns-listener-does-not-currently-know-of-sid-given-in-connect-descriptor client is attempting to connect to an Oracle database, rather than connecting to the database directly, there is a broker service that intervenes and handles the connection request for the client. This broker application is known as the listener and it performs the task of listening for incoming client requests. When a request is received, the listener processes and forwards that request onto the appropriate Oracle database server using a service handler, which just acts as the connection between the listener and the database server. TNS Names and Configuration When connecting to an Oracle database, typically your database server will have tnsnames.ora, which is a configuration file that informs the server about NET_SERVICE_NAMES which are valid database connections. By default, this file is located at ORACLE_HOME/network/admin. For example, a NET_SERVICE_NAME descriptor in tnsnames.ora may be formatted like this: myDatabaseNetService = (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp)(HOST = localhost)(PORT = 1521)(QUEUESIZE = 100)) (CONNECT_DATA = (SERVICE_NAME = bookstore.company.com) ) ) This would define a NET_SERVICE_NAME using the SERVICE_NAME we discussed earlier (bookstore.company.com) and connecting to localhost through port 1521. Connection String With a bit more knowledge about how Oracle actually connects to databases, we can now look at how connection
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. https://community.oracle.com/thread/2451625 Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in Oracle Database Express Edition (XE) All PlacesDatabaseDatabase Application DevelopmentOracle Database Express Edition (XE) This discussion is archived 1 2 ora 12505 3 Previous Next 33 Replies Latest reply on Oct 19, 2012 1:39 PM by 967142 ORA-12505, TNS:listener does not currently know of SID given in connect des 967142 Oct 9, 2012 1:35 PM Hello, After installation of Oracle Database Express Edition 11g and Oracle SQL Developer 3.0, I tryed connect listener refused the a database. Informations entered : Nom de connexion : xe_sys Nom utilisateur : sys Mdp : ********* Type de connexion : de base, role sysdba Nom d'hote : POST1.compteUs.local Port : 1521 SID : XE when I tested the connection I have this famous message that appears: Statut : échec -Echec du test : Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor this is listener.ora : SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server) (PROGRAM = extproc) ) (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server) (PROGRAM = extproc) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST = POST1.compteUs.local)(PORT = 1521)) ) ) DEFAULT_SERVICE_LISTENER = (XE) this is sqlnet.ora : SQLNET.AUTHENTICATION_SERVICES = (NTS) this is tnsname.ora : XE = (DESCRI