Home » Server Options » RAC & Failsafe » Issue while shutting down ASM instance in 11gR2 (ORACLE 11gR2 OEL5.3 on Vmware)
Issue while shutting down ASM instance in 11gR2 [message #537171] Tue, 27 December 2011 02:17 Go to next message
himabija
Messages: 33
Registered: December 2011
Location: San Francisco
Member
Hi Experts,

I have just upgraded my 2node RAC database from 10.2.0.4 to 11.2.0.1 and I'm new to 11g RAC.After up gradation whenever I'm trying to shutdown ASM instance I'm getting error.
[root@RAC1 bin]# ./srvctl stop database -d RAC -o immediate
[root@RAC1 bin]# ./crsctl status resource -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       rac1
               ONLINE  ONLINE       rac2
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac1
               ONLINE  ONLINE       rac2
ora.asm
               ONLINE  ONLINE       rac1                     Started
               ONLINE  ONLINE       rac2                     Started
ora.eons
               ONLINE  ONLINE       rac1
               ONLINE  ONLINE       rac2
ora.gsd
               ONLINE  ONLINE       rac1
               ONLINE  ONLINE       rac2
ora.net1.network
               ONLINE  ONLINE       rac1
               ONLINE  ONLINE       rac2
ora.ons
               ONLINE  ONLINE       rac1
               ONLINE  ONLINE       rac2
ora.registry.acfs
               ONLINE  ONLINE       rac1
               ONLINE  ONLINE       rac2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac1
ora.oc4j
      1        ONLINE  ONLINE       rac1
ora.rac.db
      1        OFFLINE OFFLINE                               Instance Shutdown
      2        OFFLINE OFFLINE                               Instance Shutdown
ora.rac1.vip
      1        ONLINE  ONLINE       rac1
ora.rac2.vip
      1        ONLINE  ONLINE       rac2
ora.scan1.vip
      1        ONLINE  ONLINE       rac1

[root@RAC1 bin]#./srvctl stop asm -n RAC1
PRCR-1014 : Failed to stop resource ora.asm
PRCR-1065 : Failed to stop resource ora.asm
CRS-2529: Unable to act on 'ora.asm' because that would require stopping or 
relocating 'ora.DATA.dg', but the force option was not specified


I was just googling for above error and found that this error may occur if my ocr and voting disk were residing on ASM then it will not allow me to stop the asm and I should use (Check below links)

crsctl stop crs

www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=43116
forums.oracle.com/forums/thread.jspa?hreadID=1068456


But I have verified my ocr file and voting disk are not residing on ASM.
[root@RAC1 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          3
         Total space (kbytes)     :    8381156
         Used space (kbytes)      :       6060
         Available space (kbytes) :    8375096
         ID                       : 1141966925
         Device/File Name         : /dev/raw/raw1
                                    Device/File integrity check succeeded

                                    Device/File not configured

                                    Device/File not configured

                                    Device/File not configured

                                    Device/File not configured

         Cluster registry integrity check succeeded

         Logical corruption check succeeded


[root@RAC1 bin]# ./crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   03db5164ffb96f85ff95896b184eb362 (/dev/raw/raw2) []
Located 1 voting disk(s).


Just wanted to know is this the normal behavior of oracle 11g or am I missing something? If this is normal behavior the what is the option avilable to stop asm instance without using force option?

Please let me know if you need any additional information.

[Updated on: Tue, 27 December 2011 02:20]

Report message to a moderator

Re: Issue while shutting down ASM instance in 11gR2 [message #537854 is a reply to message #537171] Mon, 02 January 2012 00:14 Go to previous messageGo to next message
pankaj25sharmagmailcom
Messages: 8
Registered: April 2011
Junior Member
Hi,

Just want to tell you about some concepts for ASM in oracle 11gR2(If you already don't know)

In Oracle 11.1 and earlier, If your database resides on ASM then DBAs used to create a dependency between local ASM and database instance. So that the ASM instance was started together with the RDBMS instance when this was required.

From 11g R2 onwards, ASM disk groups are now registered as resources within Grid Infrastructure and the dependency has been redefined, means the dependency is already set in resource definition. This dependency is created with one or more ASM disk groups.

For ex.
-------
[oracle@london1 ~]$ crsctl status resource ora.prod.db -p
NAME=ora.prod.db
TYPE=ora.database.type
ACL=owner:oracle:rwx,pgrp:oinstall:rwx,other::r--
[...]
SPFILE=+DATA/prod/spfileprod.ora
START_DEPENDENCIES=hard(ora.DATA.dg) [...] pullup(ora.DATA.dg)
STOP_DEPENDENCIES=hard(intermediate:ora.asm,shutdown:ora.DATA.dg)


You can see that a start dependency has been created for the disk group DATA, which will also be started if needed as part of the database start. Similarly, a stop dependency exists for the same disk group. The hard dependency at "ora.asm" shows that the database must be shutdown before stopping the ASM.

Note that not only database, but other resources may also have dependency on the ASM, like ACFS. So if you use "force" option to execute the stop command on ASM, still some components won't stop, due to too many dependencies on other resources.

So, to stop ASM in 11gR2, "crsctl stop crs" or "crsctl stop cluster" is the only option to stop the ASM, since it first stop all the dependent resources the stop the ASM.

So, I think in your case, there must be some resources which depends on ASM, like your database files would be on ASM.



[Updated on: Mon, 02 January 2012 00:40]

Report message to a moderator

Re: Issue while shutting down ASM instance in 11gR2 [message #537918 is a reply to message #537854] Tue, 03 January 2012 00:13 Go to previous message
himabija
Messages: 33
Registered: December 2011
Location: San Francisco
Member
Thanks a Lot Pankaj. Your explanation really helps me a lot. I have checked the dependencies of all the resource one by one Smile and able to stop asm successfully.

[root@RAC1 bin]# ./srvctl stop database -d RAC -o immediate
[root@RAC1 bin]# ./crsctl stop resource ora.DATA.dg
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac1'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac2'
CRS-2677: Stop of 'ora.DATA.dg' on 'rac2' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'rac1' succeeded
[root@RAC1 bin]#  ./crsctl stop resource ora.registry.acfs
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'rac1'
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'rac2'
CRS-2677: Stop of 'ora.registry.acfs' on 'rac2' succeeded
CRS-2677: Stop of 'ora.registry.acfs' on 'rac1' succeeded
[root@RAC1 bin]#  ./srvctl stop asm -n rac1
[root@RAC1 bin]#  ./srvctl stop asm -n rac2
[root@RAC1 bin]# ./crsctl status resource -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               OFFLINE OFFLINE      rac1
               OFFLINE OFFLINE      rac2
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac1
               ONLINE  ONLINE       rac2
ora.asm
               OFFLINE OFFLINE      rac1                     Instance Shutdown
               OFFLINE OFFLINE      rac2                     Instance Shutdown
ora.eons
               ONLINE  ONLINE       rac1
               ONLINE  ONLINE       rac2
ora.gsd
               ONLINE  ONLINE       rac1
               ONLINE  ONLINE       rac2
ora.net1.network
               ONLINE  ONLINE       rac1
               ONLINE  ONLINE       rac2
ora.ons
               ONLINE  ONLINE       rac1
               ONLINE  ONLINE       rac2
ora.registry.acfs
               OFFLINE OFFLINE      rac1
               OFFLINE OFFLINE      rac2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac1
ora.oc4j
      1        ONLINE  ONLINE       rac1
ora.rac.db
      1        OFFLINE OFFLINE                               Instance Shutdown
      2        OFFLINE OFFLINE                               Instance Shutdown
ora.rac1.vip
      1        ONLINE  ONLINE       rac1
ora.rac2.vip
      1        ONLINE  ONLINE       rac2
ora.scan1.vip
      1        ONLINE  ONLINE       rac1


Also realized that above step might not help other to stop ASM because they might have separate dependencies (For example: If there is another disk group called DATA1, then its required to stop the resources related to that resource as well.)
Previous Topic: dynamic remastering in 11g r2
Next Topic: RAC - tns entries
Goto Forum:
  


Current Time: Sat Nov 23 05:02:19 CST 2024