SOLVED

The listener support no services.

Asked by OracleDba••12 views•oracle
1
2
3
4
5
The listener support no services.

Error:

The  listener support no services.
#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
First connect to pluggable database.

Listener should be up and running .Check listener status.

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