Mir Sayeed Hassan – Oracle Blog

Oracle DBA – Tips & Techniques | Learn with real-time examples

  • Translate

  • It’s Me




  • My Certificates

  • Links

    My Acclaim Certification : Credly Profile
    My Oracle ACE Pro Profile

  • Achievements

    Awarded Top 100 Oracle Blogs from Worldwide - #RANK 39
  • VISITORS COUNT

  • Verified International Academic Qualification from World Education Service (WES)

    Verified International Academic Qualification from World Education Service (WES)

  • Jobs

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=======