Are the listeners running?
If no information appears, either there are no listeners running or there are no listeners running from the Oracle home directory
LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 13-MAY-2011 12:34:11 Copyright (c) 1991, 2007, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac02-vip)(PORT=1522)(IP=FIRST))) STATUS of the LISTENER ------------------------ Alias LISTENER_RAC02 Version TNSLSNR for Linux: Version 10.2.0.4.0 - Production Start Date 04-MAY-2011 23:35:29 Uptime 8 days 12 hr. 58 min. 41 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /oracle/app/oracle/product/10.2.0/db_1/network/admin/listener.ora Listener Log File /oracle/app/oracle/product/10.2.0/db_1/network/log/listener_rac02.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.30.131)(PORT=1522))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.10.30.130)(PORT=1522))) Services Summary... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully
| Listener Name | LISTENER_RAC02 |
|---|---|
| Listener Log File | /oracle/app/oracle/product/10.2.0/db_1/network/log/listener_rac02.log |
| TNS Errors (in last 1024 KiB) | 7169 |
| TNS Errors (in last 1000 lines) | 435 |
TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client TNS-12502: TNS:listener received no CONNECT_DATA from client
LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 13-MAY-2011 12:34:12
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac02-vip)(PORT=1522)(IP=FIRST)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
The command completed successfully