Home » Developer & Programmer » JDeveloper, Java & XML » Re: ORA-12505 TNS:listener does not currently know of SID given in connect descriptor (Oracle, 11g, Windows 7)
Re: ORA-12505 TNS:listener does not currently know of SID given in connect descriptor [message #583405] Tue, 30 April 2013 08:38 Go to next message
ishimdar
Messages: 2
Registered: April 2013
Location: Delhi
Junior Member
Exception in thread "main" 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
The Connection descriptor used by the client was:
localhost:1521:orcl

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at Jdbc.main(Jdbc.java:18)
Re: ORA-12505 TNS:listener does not currently know of SID given in connect descriptor [message #583412 is a reply to message #583405] Tue, 30 April 2013 09:40 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
RA-12505: TNS:listener does not currently know of SID given in connect descriptor
*Cause:  The listener received a request to establish a connection to a
database or other service. The connect descriptor received by the listener
specified a SID for an instance (usually a database instance) that either
has not yet dynamically registered with the listener or has not been
statically configured for the listener. This may be a temporary condition
such as after the listener has started, but before the database instance
has registered with the listener.
*Action:
 - Wait a moment and try to connect a second time.
 - Check which instances are currently known by the listener by executing:
   lsnrctl services <listener name>
 - Check that the SID parameter in the connect descriptor specifies
   an instance known by the listener.
 - Check for an event in the listener.log file.

Regards
Michel
Previous Topic: Writing XML to Oracle directory
Next Topic: Dynamically build xml SQL statement
Goto Forum:
  


Current Time: Thu Mar 28 10:37:21 CDT 2024