Troubleshooting
Problem
Windows: Oracle 10g: During startup, MCF 8.0 throws ORA12505.
Symptom
While starting MCF 8.0, system throws ORA12505 (TNS: listener does not currently know of SID given in connect descriptor) error.
This is in a Windows environment from both the App Server and Oracle database. Even from external database client (like SQLPlus), one cannot connect to the database.
Error Message
ERRORDTL 000000000000 GLOBAL_SCOPE [1268653449486]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: <IP>:<PORT>:<SERVICE NAME>
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:439)
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(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was: <IP>:<PORT>:<SERVICE NAME>
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:439)
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(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
Resolving The Problem
The cause for this error is:
"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 is 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."
"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 is 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."
Try the following steps:
1. From Control Panel -> Administrative Tools -> Services, check the status of the needed service (identify the service name from the error stack) and its listener. Start the service and the listener if not in “Started” status.
2. If it is already in started status, try the command
lsnrctl services
lsnrctl services
If the needed DB service is listed in the output, compare the string with tnsnames.ora and make sure both match. If not, change the tnsnames.ora accordingly and retry.
If the needed DB service is not listed, then try restarting the service and the listener from services (refer to point 1 above).
[{"Product":{"code":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Historical Number
NFX8557
Product Synonym
[<p><b>]Severity[</b><p>];Critical
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21552163