Issue while shutting down ASM instance in 11gR2 [message #537171] |
Tue, 27 December 2011 02:17 |
|
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 |
|
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
|
|
|
|