How do I fix ORA-12505 error in SQL Developer?
And I solved it by using SERVICE NAME (an alias) instead of SID:
- Open file tnsnames.ora from your ORACLE_HOME folder. In case you don’t know its location, do the following steps.
- In tnsnames.ora file, look for the line which contains the SERVICE_NAME.
- Select Service name and type above name, TEST success and you’ve done!
How do I find an alias in SQL Developer?
In SQLDeveloper browse Tools –> Preferences , as shown in below image. In the Preferences options expand Database –> select Advanced –> under “Tnsnames Directory” –> Browse the directory where tnsnames.
How do I check SQL Developer listener status?
To view information about the listener at the command line:
- Open a command window.
- Follow the steps listed in “Configuring the Operating System Environment Variables .”
- Enter the following command: lsnrctl status.
Where is Tnsnames Ora file located?
By default, the tnsnames. ora file is located in the ORACLE_HOME/network/admin directory.
How do I set an alias in SQL Developer?
- Start SQL Developer and go to Tools > Preferences;
- In the Preferences option, expand the Database component, click on Advanced, and under the “Tnsnames Directory”, browse to the folder where your tnsnames.ora file is located;
- Restart SQL Developer;
- Now in SQL Developer select Connections and click New Connection;
How do I check my DB listener status?
Do the following:
- Log on to the host where the Oracle database resides.
- Change to the following directory: Solaris: Oracle_HOME/bin. Windows: Oracle_HOME\bin.
- To start the listener service, type the following command: Solaris: lsnrctl START. Windows: LSNRCTL.
- Repeat step 3 to verify that the TNS listener is running.
How do I check my listener Ora file?
ora file is located in the ORACLE_HOME/network/admin directory. The listener. ora file can also be stored the following locations: The directory specified by the TNS_ADMIN environment variable or registry value.