16.3.8 ORA-12505

Indicates that the listener cannot identify the system identifier (SID) specified in the connect descriptor.

Message

ORA-12505: Cannot connect to database. 
SID string is not registered with the listener at string.
(CONNECTION_ID=string)

For example:

ORA-12505: Cannot connect to database. 
SID sales_sid is not registered with the listener at host 10.9.7.5 port 1522. 
(CONNECTION_ID=1ABcDEabCd1aB+AbCdE1aB==)

Cause

A listener process initially handles all connections to Oracle Database. The connection request received by the listener specified SID for an instance (usually a database instance) that either has not yet been dynamically registered with the listener or has not been statically configured in the listener's listener.ora configuration file. This error may be a temporary condition that occurs after the listener has started but before the database instance registers with the listener.

Action

1. Check for mistakes in the specified connection string.

2. Ensure that the SID parameter in the connection string or that the tnsnames.ora file connect descriptor specifies an instance known by the listener.

3. Wait a moment, and then try to connect again. The database instance registration may not be complete yet.

4. Use the CONNECTION_ID value to track this connection attempt in trace files for further diagnosis.

5. Check which instances are currently known by the listener by performing one of these tasks:

   • Ask your database administrator.

   • Review the connection string in the cloud service console.

   • If you have access to the machine where the listener is running, then run one of the following:

     • lsnrctl services

     • If a listener is named in the listener.ora file, then run:

       lsnrctl services listener_name

     • If an Oracle Connection Manager (Oracle CMAN) proxy listener is named in the cman.ora file, then run:

       cmctl show services -c cman_name