Interpret result of "lsnrctl status"
LSNRCTL> stat
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MUMSOLGACDEV01)(PORT=152
1)))
TNS-01169: The listener has not recognized the password
LSNRCTL> stat
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MUMSOLGACDEV01)(PORT=152
1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 9.2.0.8.0 - Produc
tion
Start Date 11-SEP-2008 19:20:34
Uptime 0 days 0 hr. 0 min. 6 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File C:\oracle\ora92\network\admin\listener.ora
Listener Log File C:\oracle\ora92\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=MUMSOLGACDEV01.ad.crisil.com)(PORT=1
521)))
Services Summary...
Service "gacdev" has 2 instance(s).
Instance "GACDEV", status READY, has 1 handler(s) for this service...
Instance "gacdev", status UNKNOWN, has 1 handler(s) for this service...
Service "gactest" has 2 instance(s).
Instance "gactest", status UNKNOWN, has 1 handler(s) for this service...
Instance "gactest", status READY, has 1 handler(s) for this service...
Service "projectXDB" has 1 instance(s).
Instance "gactest", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>
Entry in Listener.ora:
**********************************************************
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = MUMSOLGACDEV01)(PORT = 1521))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(ORACLE_HOME = c:\oracle\ora92)
(SID_NAME = gacdev)
)
(SID_DESC =
(ORACLE_HOME = c:\oracle\ora92)
(SID_NAME = gactest)
)
)
***********************************************************************
I want to know the meaning of 3 lines:
1. Service "gacdev" has 2 instance(s)
2. Instance "GACDEV", status READY, has 1 handler(s) for this service...
3. Instance "gacdev", status UNKNOWN, has 1 handler(s) for this service...
Our server MUMSOLGACDEV01 contains two databases GACDEV and GACTEST.