Blog

In this blog, We will see how to stop ASM instance.

Steps

 First we need to start ASM instance then RDBMS instance
 For shutting down First Shut RDBMS and then ASM instance.

First we need to bring down the databases.

[oracle@oracle ~]$ ps -ef|grep pmon
grid 3135 1 0 20:03 ? 00:00:00 asm_pmon_+ASM
oracle 3254 1 0 20:04 ? 00:00:00 ora_pmon_orcl
oracle 3696 3203 0 20:10 pts/0 00:00:00 grep --color=auto pmon
[oracle@oracle ~]$ sqlplus

SQL*Plus: Release 12.1.0.2.0 Production on Thu Feb 9 20:10:36 2017

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

Enter user-name: / as sysdba

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options

SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit;
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options
[oracle@oracle ~]$ ps -ef|grep pmon
grid 3135 1 0 20:03 ? 00:00:00 asm_pmon_+ASM
oracle 3714 3203 0 20:11 pts/0 00:00:00 grep --color=auto pmon

Now db has been down next switch to grid user and bring down the ASM instance with sysasm privilege.

 
[oracle@oracle ~]$ su - grid
Password:
Last login: Thu June 21 20:02:32 PST 2017 on pts/0
[grid@oracle ~]$ sqlplus

SQL*Plus: Release 12.1.0.2.0 Production on Thu June 21 20:13:24 2017

Copyright (c) 12182, 2014, Oracle. All rights reserved.

Enter user-name: / as sysasm

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Automatic Storage Management option

SQL> shut immediate;
ASM diskgroups dismounted
ASM instance shutdown
SQL> exit;
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Automatic Storage Management option

Follow me

Contact us for Training/ Job Support

Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.