ASM With Connected Clients

You cannot shutdown ASM instance when the OCR is stored on a diskgroup with error ORA-15097.

+ASM1 > srvctl stop diskgroup -g GI_VOTE

Although the srvctl reports the ASM OCR/vote diskgroup is stopped, but it still accessible and in quiesced state. 

SQL> select name, state from v$asm_diskgroup;

NAME                           STATE
------------------------------ -----------
GI_VOTE                        QUIESCING

Or completely shutdown ASM, you need to stop Grid Infrastructure, you can use "crsctl stop crs" / each node or "crsctl stop crs all" to shutdown ASM from all nodes.

In Oracle 11.2, the dependency between local ASM and database instance has been redefined

crsctl status resource ora.DATAoc.db -p

START_DEPENDENCIES=hard(ora.DATA_PD101.dg,ora.DATA_PF101.dg) pullup(ora.DATA_PD101.dg,ora.DATA_PF101.dg)
STOP_DEPENDENCIES=hard(intermediate:ora.asm,shutdown:ora.DATA_PD101.dg,shutdown:ora.DATA_PF101.dg)

You should use srvctl start diskgroup -g diskgroup since ASM is now resouce within the Grid infrastructure

srvctl start diskgroup -g GI_VOTE -n lltcind01

1 comment:

  1. Hi

    This was my exam question last week and still not sure about the answer.
    Any help is much appreciated.

    You are creating a resource definition called webapp for a web-based application that runs application called webvip
    Both webapp and webvip are normally active on a single node, but may failover if required to another cluster node in your eight node cluster.
    A second VIP application resource called appsvip exists, used by a second application resource called secapp.
    Webvip and webapp must start in correct sequence.
    Which two start dependincies would you use for the WEbapp application resource definition

    a-)hard(SECAPP)
    b-)pullup (SECAPP)
    c-)pullup(WEBVIP)
    d-)hard (WEBVIP)
    e-)dispersion (WEBVIP)
    f-)weak (WEBVIP)

    ReplyDelete