SOLVED

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

Asked by OracleDba••12 views•oracle
1
2
3
4
5
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.
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
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.
OracleDba•

Post Your Solution