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
-----------------------------------------------------------------------------------------------------
