I just ran a status command on a Listener, and this was the output.
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
Service "+ASM_XPT" has 1 instance(s).
Instance "+ASM1", status BLOCKED, has 1 handler(s) for this service...
Service "RACDB" has 2 instance(s).
Instance "RACDB1", status READY, has 3 handler(s) for this service...
Instance "RACDB2", status READY, has 3 handler(s) for this service...
Service "RACDBXDB" has 2 instance(s).
Instance "RACDB1", status READY, has 1 handler(s) for this service...
Instance "RACDB2", status READY, has 1 handler(s) for this service...
Service "RACDB_XPT" has 2 instance(s).
Instance "RACDB1", status READY, has 3 handler(s) for this service...
Instance "RACDB2", status READY, has 3 handler(s) for this service...
What does BLOCKED mean? I can connect to the DB just fine.
These entries refer to ASM instance, not to the database instances. Obviously we use dynamic listener registration (no static SID entries in listener.ora). Unlike a database instance an ASM instance cannot be OPENED, it is in MOUNT status and because it cannot accept connections, the instance has status BLOCKED (while the regular and open database instances have status READY).
In conclusion, Oracle 10g now we have 2 instances, one is database instance like old one, (8i , 9i) and the new one is +ASM instance.... ASM stands for automatic storage management.......... so this might be the reason..........but i am not so sure about this........
Saturday, February 24, 2007
Subscribe to:
Post Comments (Atom)

No comments:
Post a Comment