Database Does Not Automatically Register With Listener (No Services) TNS-12505
(Doc ID 374624.1)
Last updated on MARCH 08, 2021
Applies to:Oracle Net Services - Version 184.108.40.206.0 to 10.1.0.3.0 [Release 8.1.7 to 10.1]
Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [Release 12.2]
Information in this document applies to any platform.
Database and Listener started, but no services are registered. You may see entries like this in listener.log:
30-NOV-2006 16:44:53 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))(SID=<instance_name>)) * (ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.xx)(PORT=xxxx)) * establish * <instance_name> * 12505
TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
One of the following:
- Restarted the listener while the database was running, and no static entries in SID_LIST_listener.
- Created startup scripts or changed services startup sequence.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document