Wednesday, June 12, 2013

ORA-15097: cannot SHUTDOWN ASM instance with connected client

In 11g R2 Clusterware configurations the OCR is located in ASM disk, that’s why ASM can’t be shutdown while the cluster is running.  You have to shutdown your cluster in order to shutdown ASM instance.

Oracle support note 984663.1

Here’s a good blog about this:

Example, how to shutdown ASM instance on node ol5-112-rac1:

[oracle@ol5-112-rac1 ~]$ crsctl status resource -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       ol5-112-rac1
               ONLINE  ONLINE       ol5-112-rac2
ora.FRA.dg
               OFFLINE OFFLINE      ol5-112-rac1
               ONLINE  ONLINE       ol5-112-rac2
ora.LISTENER.lsnr
               ONLINE  ONLINE       ol5-112-rac1
               ONLINE  ONLINE       ol5-112-rac2
ora.asm
               ONLINE  ONLINE       ol5-112-rac1
               ONLINE  ONLINE       ol5-112-rac2             Started
ora.eons
               ONLINE  ONLINE       ol5-112-rac1
               ONLINE  ONLINE       ol5-112-rac2
ora.gsd
               OFFLINE OFFLINE      ol5-112-rac1
               OFFLINE OFFLINE      ol5-112-rac2
ora.net1.network
               ONLINE  ONLINE       ol5-112-rac1
               ONLINE  ONLINE       ol5-112-rac2
ora.ons
               ONLINE  ONLINE       ol5-112-rac1
               ONLINE  ONLINE       ol5-112-rac2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       ol5-112-rac1
ora.oc4j
      1        OFFLINE OFFLINE
ora.ol5-112-rac1.vip
      1        ONLINE  ONLINE       ol5-112-rac1
ora.ol5-112-rac2.vip
      1        ONLINE  ONLINE       ol5-112-rac2
ora.rac.db
      1        ONLINE  ONLINE       ol5-112-rac2             Open
      2        ONLINE  ONLINE       ol5-112-rac1
ora.rac.reports.svc
      1        ONLINE  ONLINE       ol5-112-rac1
ora.scan1.vip
      1        ONLINE  ONLINE       ol5-112-rac1
[oracle@ol5-112-rac1 ~]$

Shutdown RAC1 instance first:

[oracle@ol5-112-rac1 ~]$ srvctl stop instance –d RAC –I RAC1 –o immediate

Then proceed to shutdown cluster (root required):

[oracle@ol5-112-rac1 ~]$ su -
[root@ol5-112-rac1 bin]#
[root@ol5-112-rac1 bin]# ./crsctl stop cluster
CRS-2673: Attempting to stop 'ora.crsd' on 'ol5-112-rac1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'ol5-112-rac1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'ol5-112-rac1'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'ol5-112-rac1'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'ol5-112-rac1' succeeded
CRS-2673: Attempting to stop 'ora.ol5-112-rac1.vip' on 'ol5-112-rac1'
CRS-2677: Stop of 'ora.ol5-112-rac1.vip' on 'ol5-112-rac1' succeeded
CRS-2672: Attempting to start 'ora.ol5-112-rac1.vip' on 'ol5-112-rac2'
CRS-2676: Start of 'ora.ol5-112-rac1.vip' on 'ol5-112-rac2' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'ol5-112-rac1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'ol5-112-rac1'
CRS-2677: Stop of 'ora.asm' on 'ol5-112-rac1' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'ol5-112-rac1'
CRS-2673: Attempting to stop 'ora.eons' on 'ol5-112-rac1'
CRS-2677: Stop of 'ora.ons' on 'ol5-112-rac1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'ol5-112-rac1'
CRS-2677: Stop of 'ora.net1.network' on 'ol5-112-rac1' succeeded
CRS-2677: Stop of 'ora.eons' on 'ol5-112-rac1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'ol5-112-rac1' has completed
CRS-2677: Stop of 'ora.crsd' on 'ol5-112-rac1' succeeded
CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'ol5-112-rac1'
CRS-2673: Attempting to stop 'ora.ctssd' on 'ol5-112-rac1'
CRS-2673: Attempting to stop 'ora.evmd' on 'ol5-112-rac1'
CRS-2673: Attempting to stop 'ora.asm' on 'ol5-112-rac1'
CRS-2677: Stop of 'ora.cssdmonitor' on 'ol5-112-rac1' succeeded
CRS-2677: Stop of 'ora.evmd' on 'ol5-112-rac1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'ol5-112-rac1' succeeded
CRS-2677: Stop of 'ora.asm' on 'ol5-112-rac1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'ol5-112-rac1'
CRS-2677: Stop of 'ora.cssd' on 'ol5-112-rac1' succeeded
CRS-2673: Attempting to stop 'ora.diskmon' on 'ol5-112-rac1'
CRS-2677: Stop of 'ora.diskmon' on 'ol5-112-rac1' succeeded
[root@ol5-112-rac1 bin]# ps -ef|grep pmon
root      7072  5722  0 14:45 pts/2    00:00:00 grep pmon
[root@ol5-112-rac1 bin]# ps -ef|grep +ASM1
root      7074  5722  0 14:46 pts/2    00:00:00 grep +ASM1
[root@ol5-112-rac1 bin]#

At this point ASM & Cluster Ready Services managed resources are down.

In order to start them again just need to issue:

[root@ol5-112-rac1 bin]# ./crsctl start cluster
[root@ol5-112-rac1 bin]# exit
[oracle@ol5-112-rac1 ~]$ srvctl start instance –d RAC –I RAC1


Thanks,
Alfredo

No comments:

Post a Comment