DBA Hub

📋Steps in this guide1/1

The listener support no services.

First connect to pluggable database.

oracle configurationintermediate
by OracleDba
13 views
1

Overview

Error: The  listener support no services. Solution : First connect to pluggable database. Listener should be up and running .Check listener status. Now again stop LISTENER once and start again, it will take 60 sec to start.Then check listener status.

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
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

Comments (0)

Please to add comments

No comments yet. Be the first to comment!