The listener support no services.

• Kiran Dalvi
• 06 Feb, 2024
• 0 Comments
• 35 Secs Read

The listener support no services.

Error:
 The  listener support no services.

Solution:

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.