How to Solve :
Oracle database error code ORA-12505 – TNS:listener does not currently know of SID given in connect descriptor
Oracle Database Error Code ORA-12505 Description :
TNS:listener does not currently know of SID given in connect descriptor
Error 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.
How to Solve :
- Wait a moment and try to connect a second time. – Check which instances are currently known by the listener by executing: lsnrctl services
– 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.
Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes Etiketler: ora - 12505, 12505, about oracle ORA-12505 error, help ORA-12505 about, ORA-12505 error code, ORA-12505 problem, Oracle 9i 10g 11g, Oracle Database Server Error Messages, Oracle Error Codes, oracle number 12505 error code, oracle ORA-12505 example, TNS:listener does not currently know of SID given in connect descriptor
1 Comment
1 Comment
Recent Entries
- Oracle database error code ORA-29959 – error in the execution of the string routine for one or more of the index partitions
- Oracle database error code ORA-31601 – Function string cannot be called now that fetch has begun.
- Oracle database error code ORA-29958 – fatal error occurred in the execution of ODCIINDEXCREATE routine
- Oracle database error code ORA-31600 – invalid input value string for parameter string in function string
- Oracle database error code ORA-29957 – cannot create a function-based domain index on a string table
- Oracle database error code ORA-31604 – invalid string parameter “string” for object type string in function string
- Oracle database error code ORA-29961 – too many warnings occurred in the execution of ODCIIndex DDL routine
Search Oracle Error Codes and Descriptions:
1 Comment Already
Similar Errors
Please Leave Your Comments Below