Pages

Wednesday, February 23, 2022

The Listener Supports no services #ora-12541 #ora-12505 #listener

 The Listener Supports No Services #ORA-12541#ORA-12505


lsnrctl status

the output of the last two statements would be like 

The listener supports no services

The command completed successfully


Solution 

lsnrctl services < name of the listener >

connect SQLPLUS 

SQL> show parameter local_listener


NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

local_listener                       string


SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST= IP-ADDRESS OR HOSTNAME)(PORT=1521)))' scope=both;

SQL> alter system register;

System altered.

SQL> exit

[oracle@OEL_VM_11 ~]$ lsnrctl services < name of the listener >

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 
Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.15)(PORT=1521 )))
Services Summary...
Service "ggf" has 1 instance(s).
  Instance "ggf", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
Service "ggfXDB" has 1 instance(s).
  Instance "ggf", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER <machine: OEL_VM_11, pid: 12790>
         (ADDRESS=(PROTOCOL=tcp)(HOST=OEL_VM_11)(PORT=15699))
The command completed successfully



  -----------------------------------------------------------------------------------------------------

No comments:

Post a Comment