This discussion is archived
0 Replies Latest reply: Aug 16, 2007 10:03 AM by 593327 RSS

Only one of two instances accessible in Oracle cluster

593327 Newbie
Currently Being Moderated
Hi,

I have an Oracle cluster consisting of two nodes each running an Oracle database and several services defined against these two instances.

When I run lsnrctl stat, (see output below), each service has only one instance available. Both the instances are running.

I was wondering if the ASM instance being blocked had something to do with this, and found this thread:

Re: Why does listener show +ASM1 as BLOCKED

We do not have any ASM entry defined in tnsnames.ora (both db_1 and asm_1), but we have entries defined for all our other services.

Is ASM being blocked relevent to my problem? And should we have an entry for ASM defined in tnsnames.ora?

If not, what action can I take? (Have tried rebooting the node that's running the unavailable instance, but that did not work).

Many thanks for any help with this; here is the lsnrctl stat output; all services (Sn.thingy.com) should have both instances INSTDB1 and INSTDB2 available.

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=mfdb1pub.thingy.com)(PORT=1521)))
Services Summary...
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 "S1.thingy.com" has 1 instance(s).
Instance "INSTDB2", status READY, has 2 handler(s) for this service...
Service "S2.thingy.com" has 1 instance(s).
Instance "INSTDB2", status READY, has 2 handler(s) for this service...
Service "INSTDB.thingy.com" has 2 instance(s).
Instance "INSTDB1", status READY, has 3 handler(s) for this service...
Instance "INSTDB2", status READY, has 2 handler(s) for this service...
Service "INSTDB_XPT.thingy.com" has 2 instance(s).
Instance "INSTDB1", status READY, has 3 handler(s) for this service...
Instance "INSTDB2", status READY, has 2 handler(s) for this service...
Service "S3.thingy.com" has 1 instance(s).
Instance "INSTDB2", status READY, has 2 handler(s) for this service...
The command completed successfully