- 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.
Now db has been down next switch to grid user and bring down the ASM instance with sysasm privilege.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 | [oracle@oracle ~]$ ps -ef|grep pmongrid 3135 1 0 20:03 ? 00:00:00 asm_pmon_+ASMoracle 3254 1 0 20:04 ? 00:00:00 ora_pmon_orcloracle 3696 3203 0 20:10 pts/0 00:00:00 grep --color=auto pmon[oracle@oracle ~]$ sqlplusSQL*Plus: Release 12.1.0.2.0 Production on Thu Feb 9 20:10:36 2017Copyright (c) 1982, 2014, Oracle. All rights reserved.Enter user-name: / as sysdbaConnected to:Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit ProductionWith the Partitioning, Automatic Storage Management, OLAP, Advanced Analyticsand Real Application Testing optionsSQL> 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 ProductionWith the Partitioning, Automatic Storage Management, OLAP, Advanced Analyticsand Real Application Testing options[oracle@oracle ~]$ ps -ef|grep pmongrid 3135 1 0 20:03 ? 00:00:00 asm_pmon_+ASMoracle 3714 3203 0 20:11 pts/0 00:00:00 grep --color=auto pmon |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 | [oracle@oracle ~]$ su - gridPassword:Last login: Thu June 21 20:02:32 PST 2017 on pts/0[grid@oracle ~]$ sqlplusSQL*Plus: Release 12.1.0.2.0 Production on Thu June 21 20:13:24 2017Copyright (c) 12182, 2014, Oracle. All rights reserved.Enter user-name: / as sysasmConnected to:Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit ProductionWith the Automatic Storage Management optionSQL> shut immediate;ASM diskgroups dismountedASM instance shutdownSQL> exit;Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit ProductionWith the Automatic Storage Management option |