My Oracle Support Banner

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 8.1.7.4.0 to 10.1.0.3.0 [Release 8.1.7 to 10.1]
Oracle Database - Enterprise Edition - Version 12.2.0.1 to 12.2.0.1 [Release 12.2]
Information in this document applies to any platform.

Symptoms

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

Changes

One of the following:

Cause

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
Symptoms
Changes
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.