How do you resolve ORA 12505 TNS listener does not currently know SID given in connect descriptor?
To resolve this problem, use the listener. ora parameter USE_SID_AS_SERVICE_listener_name. This parameter will tell the listener to use the SID in the connect descriptor as a service name and allow you to connect the client to this particular database.
How do I fix ORA-12514 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.
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!
What is the difference between Sid and service name in Oracle?
Oracle SID is the unique name that uniquely identifies your instance/database, whereas the Service name is the TNS alias that you give when you remotely connect to your database, and this Service name is recorded in tnsnames.
What does Oracle-ora-12505, TNS : listener does not currently know?
ORA-12505 means that the listener knows about that database, but the listener hasn’t received a notification from the database that the database is up. (If you were trying to connect to the wrong database, using the wrong SID, you would get an ORA-12154 error “TNS: could not resolve the connect identifier specified”.)
How to test database connection in ora-12505?
“ORA-12505: TNS:listener does not currently know of SID given in connect descriptor” when testing database connection I.T. administrator launches “Controller Configuration” and creates new database connection to Oracle database schema. Administrator clicks ‘Test Connection’ but receives an error message.
Why does Toad fail to connect to my database?
Couple of days back, I execute shutdown on my DB but it took very long time so I shutdown my m/c. After restarting my machine, I get this exception when I try to connect to my database using TOAD. I referred below mentioned threads, but issue is still not resolved: Contents of my tnsnames.ora: Output of ‘lsnrctl services’:
How does a TNS listener connect to a database?
When connecting to an Oracle database using JDBC, you don’t connect to the database directly. Instead, you connect to a TNS listener, which then connects you to the database.