Stop the Single ASM Instance in Oracle Database
Posted by Mir Sayeed Hassan on September 18th, 2022
Stop the Single ASM Instance in Oracle Database
– To stop the ASM Instance, First we need to Stop the RDBMS & then we need to stop the ASM Instance
Check the status of database
[oracle@pri-db1 ~]$ srvctl status database -d testdb1 Instance testdb1 is running on node testdb1
Stop the RDBMS Database
[oracle@pri-db1 ~]$ srvctl status database -d testdb1 Instance testdb1 is not running on node testdb1
Check the ASM Instance
[oracle(testdb1)@testdb1 ~]$ . oraenv ORACLE_SID = [testdb1] ? +ASM The Oracle base remains unchanged with value /u01/oraclebase
[oracle(+ASM)@testdb1 ~]$ sqlplus / as sysasm SQL*Plus: Release 11.2.0.4.0 Production on Sun Sep 18 18:03:40 2022 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Automatic Storage Management option SQL> select status from v$instance; STATUS ------------ STARTED
Check status of ASM
[oracle(+ASM)@testdb1 ~]$ srvctl status asm ASM is running on testdb1
Shutdown ASM Instance
[oracle(+ASM)@testdb1 ~]$ sqlplus / as sysasm SQL> shutdown immediate ASM diskgroups dismounted ASM instance shutdown
Verify
[oracle(+ASM)@testdb1 ~]$ srvctl status asm ASM is not running.
[oracle(+ASM)@testdb1 ~]$ asmcmd Connected to an idle instance. ASMCMD> lsdg ASMCMD-8102: no connection to Oracle ASM; command requires Oracle ASM to run
=====Hence tested & Verified in our test env=======