oracle asm无法关闭,ASM无法关闭 - Oracle专题深入讨论 - ITPUB论坛－中国专业的IT技术社区...

原帖由 Yong Huang 于 2011-5-18 02:14 发表

According to

ORA-15097 Cannot Shutdown ASM if OCR is Located in ASM (Doc ID 984663.1)

Solution

To shutdown ASM, CRS need to be shutdown: crsctl stop crs

ATTENTION: Never kill the ASM instance!

crs_stat -t

Name           Type           Target    State     Host

------------------------------------------------------------

ora....DATA.dg ora....up.type ONLINE    ONLINE    nd3

ora....ER.lsnr ora....er.type ONLINE    ONLINE    nd3

ora....N1.lsnr ora....er.type ONLINE    ONLINE    nd4

ora....N2.lsnr ora....er.type ONLINE    ONLINE    nd3

ora....N3.lsnr ora....er.type ONLINE    ONLINE    nd3

ora....VOTE.dg ora....up.type ONLINE    ONLINE    nd3

ora.asm        ora.asm.type   ONLINE    ONLINE    nd3

ora.eons       ora.eons.type  ONLINE    ONLINE    nd3

ora.gsd        ora.gsd.type   OFFLINE   OFFLINE

ora....SM1.asm application    ONLINE    ONLINE    nd3

ora....D3.lsnr application    ONLINE    ONLINE    nd3

ora.nd3.gsd    application    OFFLINE   OFFLINE

ora.nd3.ons    application    ONLINE    ONLINE    nd3

ora.nd3.vip    ora....t1.type ONLINE    ONLINE    nd3

ora....SM2.asm application    ONLINE    ONLINE    nd4

ora....D4.lsnr application    ONLINE    ONLINE    nd4

ora.nd4.gsd    application    OFFLINE   OFFLINE

ora.nd4.ons    application    ONLINE    ONLINE    nd4

ora.nd4.vip    ora....t1.type ONLINE    ONLINE    nd4

ora....network ora....rk.type ONLINE    ONLINE    nd3

ora.oc4j       ora.oc4j.type  OFFLINE   OFFLINE

ora.ons        ora.ons.type   ONLINE    ONLINE    nd3

ora....ry.acfs ora....fs.type ONLINE    ONLINE    nd3

ora.scan1.vip  ora....ip.type ONLINE    ONLINE    nd4

ora.scan2.vip  ora....ip.type ONLINE    ONLINE    nd3

ora.scan3.vip  ora....ip.type ONLINE    ONLINE    nd3

ora....drac.db ora....se.type ONLINE    ONLINE    nd3

ora.third.db   ora....se.type OFFLINE   OFFLINE

[grid@nd3 ~]$ crs_stop -all

CRS-2500: Cannot stop resource 'ora.gsd' as it is not running

CRS-2500: Cannot stop resource 'ora.oc4j' as it is not running

CRS-2500: Cannot stop resource 'ora.third.db' as it is not running

Attempting to stop `ora.eons` on member `nd3`

Attempting to stop `ora.eons` on member `nd4`

Attempting to stop `ora.LISTENER.lsnr` on member `nd3`

Attempting to stop `ora.ASM_DATA.dg` on member `nd3`

Attempting to stop `ora.OCR_VOTE.dg` on member `nd3`

Attempting to stop `ora.registry.acfs` on member `nd3`

Attempting to stop `ora.secondrac.db` on member `nd3`

Attempting to stop `ora.ons` on member `nd3`

Attempting to stop `ora.LISTENER.lsnr` on member `nd4`

CRS-2789: Cannot stop resource 'ora.gsd' as it is not running on server 'nd4'

Attempting to stop `ora.ASM_DATA.dg` on member `nd4`

Attempting to stop `ora.OCR_VOTE.dg` on member `nd4`

Attempting to stop `ora.registry.acfs` on member `nd4`

Attempting to stop `ora.secondrac.db` on member `nd4`

Attempting to stop `ora.ons` on member `nd4`

CRS-2789: Cannot stop resource 'ora.gsd' as it is not running on server 'nd3'

Stop of `ora.ons` on member `nd3` succeeded.

Stop of `ora.LISTENER.lsnr` on member `nd3` succeeded.

Attempting to stop `ora.nd3.vip` on member `nd3`

Attempting to stop `ora.LISTENER_SCAN2.lsnr` on member `nd3`

Attempting to stop `ora.LISTENER_SCAN3.lsnr` on member `nd3`

Stop of `ora.nd3.vip` on member `nd3` succeeded.

Stop of `ora.LISTENER.lsnr` on member `nd4` succeeded.

Stop of `ora.ons` on member `nd4` succeeded.

Attempting to stop `ora.nd4.vip` on member `nd4`

Attempting to stop `ora.LISTENER_SCAN1.lsnr` on member `nd4`

Stop of `ora.nd4.vip` on member `nd4` succeeded.

Stop of `ora.LISTENER_SCAN3.lsnr` on member `nd3` succeeded.

Attempting to stop `ora.scan3.vip` on member `nd3`

Stop of `ora.scan3.vip` on member `nd3` succeeded.

Stop of `ora.LISTENER_SCAN2.lsnr` on member `nd3` succeeded.

Attempting to stop `ora.scan2.vip` on member `nd3`

Stop of `ora.scan2.vip` on member `nd3` succeeded.

Attempting to stop `ora.net1.network` on member `nd3`

Stop of `ora.net1.network` on member `nd3` succeeded.

Stop of `ora.registry.acfs` on member `nd4` succeeded.

Stop of `ora.LISTENER_SCAN1.lsnr` on member `nd4` succeeded.

Attempting to stop `ora.scan1.vip` on member `nd4`

Stop of `ora.scan1.vip` on member `nd4` succeeded.

Attempting to stop `ora.net1.network` on member `nd4`

Stop of `ora.net1.network` on member `nd4` succeeded.

Stop of `ora.registry.acfs` on member `nd3` succeeded.

Stop of `ora.eons` on member `nd4` succeeded.

Stop of `ora.eons` on member `nd3` succeeded.

Stop of `ora.OCR_VOTE.dg` on member `nd4` succeeded.

Stop of `ora.ASM_DATA.dg` on member `nd4` succeeded.

Stop of `ora.OCR_VOTE.dg` on member `nd3` succeeded.

Stop of `ora.secondrac.db` on member `nd4` succeeded.

Attempting to stop `ora.asm` on member `nd4`

CRS-2673: Attempting to stop 'ora.asm' on 'nd4'

ORA-15097: cannot SHUTDOWN ASM instance with connected client

CRS-2675: Stop of 'ora.asm' on 'nd4' failed

Stop of `ora.secondrac.db` on member `nd3` succeeded.

CRS-0216: Could not stop resource 'ora.asm nd3 1'.

CRS-0216: Could not stop resource 'ora.asm nd4 1'.

CRS-0216: Could not stop resource 'ora.gsd'.

CRS-0216: Could not stop resource 'ora.gsd nd3 1'.

CRS-0216: Could not stop resource 'ora.gsd nd4 1'.

CRS-0216: Could not stop resource 'ora.oc4j'.

crs_stat -t

Name           Type           Target    State     Host

------------------------------------------------------------

ora....DATA.dg ora....up.type OFFLINE   ONLINE    nd4

ora....ER.lsnr ora....er.type OFFLINE   OFFLINE

ora....N1.lsnr ora....er.type OFFLINE   OFFLINE

ora....N2.lsnr ora....er.type OFFLINE   OFFLINE

ora....N3.lsnr ora....er.type OFFLINE   OFFLINE

ora....VOTE.dg ora....up.type OFFLINE   OFFLINE

ora.asm        ora.asm.type   OFFLINE   ONLINE    nd4

ora.eons       ora.eons.type  OFFLINE   OFFLINE

ora.gsd        ora.gsd.type   OFFLINE   OFFLINE

ora....SM1.asm application    OFFLINE   ONLINE    nd3

ora....D3.lsnr application    OFFLINE   OFFLINE

ora.nd3.gsd    application    OFFLINE   OFFLINE

ora.nd3.ons    application    OFFLINE   OFFLINE

ora.nd3.vip    ora....t1.type OFFLINE   OFFLINE

ora....SM2.asm application    OFFLINE   ONLINE    nd4

ora....D4.lsnr application    OFFLINE   OFFLINE

ora.nd4.gsd    application    OFFLINE   OFFLINE

ora.nd4.ons    application    OFFLINE   OFFLINE

ora.nd4.vip    ora....t1.type OFFLINE   OFFLINE

ora....network ora....rk.type OFFLINE   OFFLINE

ora.oc4j       ora.oc4j.type  OFFLINE   OFFLINE

ora.ons        ora.ons.type   OFFLINE   OFFLINE

ora....ry.acfs ora....fs.type OFFLINE   OFFLINE

ora.scan1.vip  ora....ip.type OFFLINE   OFFLINE

ora.scan2.vip  ora....ip.type OFFLINE   OFFLINE

ora.scan3.vip  ora....ip.type OFFLINE   OFFLINE

ora....drac.db ora....se.type OFFLINE   OFFLINE

[grid@nd3 ~]$ ps -ef | grep smon

grid     14845     1  0 May17 ?        00:00:00 asm_smon_+ASM1

grid     15278 14838  0 08:28 pts/2    00:00:00 grep smon

[grid@nd3 ~]$ export ORACLE_SID=+ASM1

[grid@nd3 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Wed May 18 08:28:19 2011

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> conn /as sysasm

Connected.

SQL> shutdown immediate

ORA-15097: cannot SHUTDOWN ASM instance with connected client