How do you fix ORA 12505 TNS listener does not currently know of SID given in connect descriptor?

Your first action to resolve this issue should be to wait a few seconds, then try to re-connect to the database again. If this attempt is unsuccessful, try checking to see which instances are known by the listener. To do this, execute: lsnrctl services . You can also check the status of the listener.

Table of Contents

How do I fix ORA 12505 error in SQL Developer?

Show activity on this post.

Open Net Manager.
Select your Listener.
In the upper right ComboBox, select Database Services.
Clic Add Database.
Fill the 3 fields: Global Database Name (i.e. ORCL.NET.
File > Save Network Configuration.
Restart the OracleOraDb11g_home1TNSListener service.

How do I install Oracle listener service in Windows?

To start Oracle Net Listener, do the following:

Start the listener with the Listener Control utility.
Start the database, as follows:
Confirm that database service registration with the listener has completed using the Listener Control utility using the following command: LSNRCTL> SERVICES [listener_name]

How do I restart my listener?

Start the Oracle listener service.

Windows operating systems: Use the Services menu to start the Oracle TNS listener named OracleOraDb12_home1TNSListener . If the Oracle listener service is idle, start the listener.
UNIX and Linux operating systems: Enter these commands: # su – oracle # ./lsnrctl start.

Where is the Oracle listener located?

The Oracle Listener is normally located on the Oracle Database Server. Each Oracle Database running on the server will register Service Names with the Oracle Listener. The local_listener is on the database server, the localhost port 1521. Default is TNSNAMES. TNSNAMES reads the description from the tnsnames.ora file.

How does the Oracle listener register service names?

Each Oracle Database running on the server will register Service Names with the Oracle Listener. The local_listener is on the database server, the localhost port 1521. Default is TNSNAMES. TNSNAMES reads the description from the tnsnames.ora file.

Where is the local_listener on the server?

The local_listener is on the database server, the localhost port 1521. Default is TNSNAMES. TNSNAMES reads the description from the tnsnames.ora file.