Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

listener status

User374733Mar 21 2012 — edited Mar 21 2012
When checking listener status without mentioning the name of the listener, it is saying that listener is not running:

oradb @ ts1db1/orahome/oradb/db/tech_st/11.2.0 >lsnrctl status

LSNRCTL for HPUX: Version 11.2.0.3.0 - Production on 21-MAR-2012 14:50:27

Copyright (c) 1991, 2011, Oracle. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
HPUX Error: 239: Connection refused

BUT when giving listener name it is giving proper output:

oradb @ ts1db1/orahome/oradb/db/tech_st/11.2.0 >lsnrctl status TEST

LSNRCTL for HPUX: Version 11.2.0.3.0 - Production on 21-MAR-2012 14:50:33

Copyright (c) 1991, 2011, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ts1db1.bukhatir.ae)(PORT=1524)))
STATUS of the LISTENER
------------------------
Alias TEST
Version TNSLSNR for HPUX: Version 11.2.0.3.0 - Production
Start Date 20-MAR-2012 10:41:35
Uptime 1 days 4 hr. 8 min. 58 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /orahome/oradb/db/tech_st/11.2.0/network/admin/TEST_ts1db1/listener.ora
Listener Log File /orahome/oradb/db/tech_st/11.2.0/admin/TEST_ts1db1/diag/tnslsnr/ts1db1/test/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ts1db1.bukhatir.ae)(PORT=1524)))
Services Summary...
Service "TEST" has 2 instance(s).
Instance "TEST", status UNKNOWN, has 1 handler(s) for this service...
Instance "TEST", status READY, has 1 handler(s) for this service...
The command completed successfully

oradb @ ts1db1/orahome/oradb/db/tech_st/11.2.0 >echo $ORACLE_SID
TEST

What could be the reason for "lsnrctl status" command not showing proper output?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 18 2012
Added on Mar 21 2012
11 comments
1,149 views