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 add Ora files to SQL Developer?
ora file manually.
- 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;
How do I fix TNS listener does not currently know of service requested in connect descriptor?
Check that the SERVICE_NAME parameter in the connect descriptor of the net service name used specifies a service known by the listener. If an easy connect naming connect identifier was used, check that the service name specified is a service known by the listener. Check for an event in the listener. log file.
What is connection type in SQL Developer?
A database connection is a SQL Developer object that specifies the necessary information for connecting to a specific database as a specific user of that database. You must have at least one database connection (existing, created, or imported) to use SQL Developer.
Why is there an ora-12505 listener…error?
There are many possible causes for the ” ORA-12505: TNS:listener ” error, such as: Scenario #1 – Incorrect configuration of Oracle database server. Specifically, the LISTENER on the Oracle database server was not configured correctly.
Why is my computer not connecting to Oracle 12c?
I’m trying to connect remotely to Oracle 12c database with SQL Developer. In order to connect remotely from another computer, on the computer running Oracle I opened a port in the Windows 7 Firewall. That part worked, but now the listener isn’t letting me in due to this error ORA-12505.
How to troubleshoot Oracle database server connection failed?
Specifically, the LISTENER on the Oracle database server was not configured correctly. For more details, see separate IBM Technote #1447103. Logon to the Oracle database server and launch a command prompt. Type the following command:
Why is my Ora file not connecting to the database?
The way you are connecting to the database (connection type “basic”) isn’t using your tnsnames.ora file at all. It is using a basic JDBC connect string – which is fine. That said, the error indicates that the database “xe” hasn’t registered with the listener, meaning that the database itself probably isn’t running at all.