Listener Problem (Service have 2 instance)
Hello Friends,
I have created database using DBCA. I am working on 11.1.0.6.
Here I am little bit confuse when I am checking the listener status it shows me the two instance under ORCL service, 1st in uppercase and 2nd in lowercase.
LSNRCTL> STATUS
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=alif14.alif.com)(PORT=15
21)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.1.0.6.0 - Produ
ction
Start Date 27-JUN-2009 12:11:17
Uptime 0 days 0 hr. 25 min. 18 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\app\product\11.1.0\db_1\network\admin\listener.ora
Listener Log File d:\app\diag\tnslsnr\alif14\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=alif14.alif.com)(PORT=1521)))
Services Summary...
*Service "ORCL" has 2 instance(s).
Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
Instance "orcl", status READY, has 1 handler(s) for this service...*
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orcl_XPT" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "STAN" has 1 instance(s).
Instance "STAN", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>
What is it mean.. ?
I have check the registry in which Oracle SID in lowercase
Regards,
Chandan Tanwani