- ANKUSH THAVALI
- 21 Jun, 2021
- 0 Comments
- 2 Mins Read
How to Start and Stop ASM Instance for Standalone Database
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 pmonNow 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