How to Start and Stop ASM Instance for Standalone Database

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarKiran Dalvi
  • 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 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