Found the error : The listener supports no services
That's mean the listener can't listener to the service
Command used:
SQL> sqlplus / as sysdba
SQL> show parameter service_names
SQL> alter system register;
SQL> stop;
and then you can check the listener status that all right again,
I copied my case and place here for an reference.
[oracle@localhost ~]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 16-OCT-2013 01:21:09Copyright (c) 1991, 2010, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1521)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for Linux: Version 11.2.0.2.0 - ProductionStart Date 16-OCT-2013 01:20:30Uptime 0 days 0 hr. 0 min. 38 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFF Listener Parameter File
/home/oracle/app/oracle/product/11.2.0/dbhome_2/network/admin/listener.oraListener Log File /home/oracle/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xmlListening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=80))(PROTOCOL_STACK=(PRESENTATION=HTTP)(SESSION=RAW))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=21))(PROTOCOL_STACK=(PRESENTATION=FTP)(SESSION=RAW)))The listener supports no servicesThe command completed successfully
[oracle@localhost ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.2.0 Production on Wed Oct 16 01:22:40 2013Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show parameter service_names
NAME TYPE VALUE------------------------------------ ----------- ------------------------------service_names string
orclSQL> alter system register;
System altered.
SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@localhost ~]$ lsnrctl statusLSNRCTL for Linux: Version 11.2.0.2.0 - Production on 16-OCT-2013 01:23:29Copyright (c) 1991, 2010, Oracle. All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=0.0.0.0)(PORT=1521)))STATUS of the LISTENER------------------------Alias LISTENERVersion TNSLSNR for Linux: Version 11.2.0.2.0 - ProductionStart Date 16-OCT-2013 01:20:30Uptime 0 days 0 hr. 2 min. 59 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Parameter File
/home/oracle/app/oracle/product/11.2.0/dbhome_2/network/admin/listener.oraListener Log File /home/oracle/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xmlListening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=80))(PROTOCOL_STACK=(PRESENTATION=HTTP)(SESSION=RAW))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=0.0.0.0)(PORT=21))(PROTOCOL_STACK=(PRESENTATION=FTP)(SESSION=RAW)))
Services Summary...
Service "orcl" has 1 instance(s). Instance "orcl", status READY, has 2 handler(s) for this service...
Service "orclXDB" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service...The command completed successfully
Reference :
No comments :
Post a Comment