ORA-12505: TNS:listener does not currently know of SID given in connect descriptor.

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor.
  • User AvatarKiran Dalvi
  • 15 Feb, 2024
  • 0 Comments
  • 37 Secs Read

ORA-12505: TNS:listener does not currently know of SID given in connect descriptor.

ERROR

ORA-12505: TNS:listener does not currently know of SID given in connect descriptor.

ORA-12505: TNS:listener does not currently know of SID given in connect descriptor.

Solution
First connect to pluggable database.
check listener status .It should be up and running.

$ lsnrctl status listener
SQL> show parameter local;
NAME                  TYPE      VALUE
--------------------- --------- --------------- 
local_listener        string    LISTENER_PRIM
parallel_force_local   boolean   FALSE


SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node1.learnomate.org)(PORT=1521)))' scope=both;

SQL> alter system register;

SQL> show parameter local;

NAME                  TYPE             VALUE
------------------------------------ ----------- ------------------------------
local_listener        string        (DESCRIPTION=(ADDRESS=(PROTOCO
                                    L=tcp)(HOST=node1.learnomate.o
                                    rg)(PORT=1521)))
parallel_force_local  boolean        FALSE

Now again stop LISTENER once and start again, it will take 60 sec to start.Then check listener status.