Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Thursday, September 15, 2011

ORA-15097: cannot SHUTDOWN ASM instance with connected RDBMS instance

ORA-15097: cannot SHUTDOWN ASM instance with connected RDBMS instance


SQL> shutdown immediate;
ORA-15097: cannot SHUTDOWN ASM instance with connected RDBMS instance
SQL>
SQL> exit


You are trying to shutdown the ASM instance without shutting down the database. Please shutdown the database/s that are connected to this ASM instance and then try again.

or

[oracle@collabn1 ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 21 15:17:03 2015

Copyright (c) 1982, 2009, Oracle.  All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> shut immediate;
ORA-15097: cannot SHUTDOWN ASM instance with connected client (process 21897)


There is no other database running except ASM.

[oracle@collabn1 ~]$ ps -aef| grep smon
oracle    7870 16403  0 15:20 pts/2    00:00:00 grep smon
oracle   21805     1  0 14:57 ?        00:00:00 asm_smon_+ASM1
root     21862     1  0 14:57 ?        00:00:07 /u01/app/oracle/product/12.1.0/grid/bin/osysmond.bin


In 11gR2,  OCR is located in ASM and you cannot shut down the asm with connected clients like OCR.

Try
crsctl stop crs if single node
or

Try crsctl stop cluster -n <node name >  if RAC.

[root@collabn1 ~]# crsctl stop cluster -n collabn1
CRS-2673: Attempting to stop 'ora.crsd' on 'collabn1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'collabn1'
CRS-2673: Attempting to stop 'ora.oc4j' on 'collabn1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'collabn1'
CRS-2673: Attempting to stop 'ora.MGMTLSNR' on 'collabn1'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN3.lsnr' on 'collabn1'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'collabn1'
CRS-2673: Attempting to stop 'ora.cvu' on 'collabn1'
CRS-2677: Stop of 'ora.cvu' on 'collabn1' succeeded
CRS-2672: Attempting to start 'ora.cvu' on 'collabn2'
CRS-2676: Start of 'ora.cvu' on 'collabn2' succeeded
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'collabn1' succeeded
CRS-2673: Attempting to stop 'ora.collabn1.vip' on 'collabn1'
CRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on 'collabn1' succeeded
CRS-2673: Attempting to stop 'ora.scan2.vip' on 'collabn1'
CRS-2677: Stop of 'ora.LISTENER_SCAN3.lsnr' on 'collabn1' succeeded
CRS-2673: Attempting to stop 'ora.scan3.vip' on 'collabn1'
CRS-2677: Stop of 'ora.MGMTLSNR' on 'collabn1' succeeded
CRS-2672: Attempting to start 'ora.MGMTLSNR' on 'collabn2'
CRS-2677: Stop of 'ora.collabn1.vip' on 'collabn1' succeeded
CRS-2672: Attempting to start 'ora.collabn1.vip' on 'collabn2'
CRS-2677: Stop of 'ora.scan2.vip' on 'collabn1' succeeded
CRS-2672: Attempting to start 'ora.scan2.vip' on 'collabn2'
CRS-2677: Stop of 'ora.scan3.vip' on 'collabn1' succeeded
CRS-2672: Attempting to start 'ora.scan3.vip' on 'collabn2'
CRS-2676: Start of 'ora.collabn1.vip' on 'collabn2' succeeded
CRS-2677: Stop of 'ora.oc4j' on 'collabn1' succeeded
CRS-2672: Attempting to start 'ora.oc4j' on 'collabn2'
CRS-2676: Start of 'ora.MGMTLSNR' on 'collabn2' succeeded
CRS-2676: Start of 'ora.scan2.vip' on 'collabn2' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN2.lsnr' on 'collabn2'
CRS-2676: Start of 'ora.scan3.vip' on 'collabn2' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN3.lsnr' on 'collabn2'
CRS-2676: Start of 'ora.LISTENER_SCAN2.lsnr' on 'collabn2' succeeded
CRS-2676: Start of 'ora.LISTENER_SCAN3.lsnr' on 'collabn2' succeeded
CRS-2676: Start of 'ora.oc4j' on 'collabn2' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'collabn1'
CRS-2677: Stop of 'ora.asm' on 'collabn1' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'collabn1'
CRS-2677: Stop of 'ora.ons' on 'collabn1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'collabn1'
CRS-2677: Stop of 'ora.net1.network' on 'collabn1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'collabn1' has completed
CRS-2677: Stop of 'ora.crsd' on 'collabn1' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'collabn1'
CRS-2673: Attempting to stop 'ora.evmd' on 'collabn1'
CRS-2673: Attempting to stop 'ora.storage' on 'collabn1'
CRS-2677: Stop of 'ora.storage' on 'collabn1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'collabn1'
CRS-2677: Stop of 'ora.ctssd' on 'collabn1' succeeded
CRS-2677: Stop of 'ora.evmd' on 'collabn1' succeeded
CRS-2677: Stop of 'ora.asm' on 'collabn1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'collabn1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'collabn1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'collabn1'
CRS-2677: Stop of 'ora.cssd' on 'collabn1' succeeded


No comments: