Manually Start Oracle11g ASM Instance

-bash-4.1$ . oraenv
ORACLE_SID = [rorcl2] ? +ASM2
The Oracle base remains unchanged with value /u01/app/oracle11g
-bash-4.1$
-bash-4.1$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on Fri Jul 17 17:24:01 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> show parameter spfile
NAME TYPE VALUE
———————————— ———– ——————————
spfile string +OCRVOTE/ecnode-cluster/asmpar
ameterfile/registry.253.884790
979
SQL>
SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options
-bash-4.1$ cd $ORACLE_HOME
-bash-4.1$ pwd
/u01/app/11.2.0/grid
-bash-4.1$ cd dbs
-bash-4.1$ ls
ab_+ASM2.dat hc_+ASM2.dat init.ora orapw+ASM
-bash-4.1$
-bash-4.1$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on Fri Jul 17 17:24:30 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> create pfile from spfile;

File created.

SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options
-bash-4.1$ ls
ab_+ASM2.dat hc_+ASM2.dat init+ASM2.ora init.ora orapw+ASM

-bash-4.1$ cat init+ASM2.ora
+ASM1.asm_diskgroups='DATA'#Manual Mount
+ASM2.asm_diskgroups='DATA'#Manual Mount
*.asm_power_limit=1
*.diagnostic_dest='/u01/app/oracle11g'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='EXCLUSIVE'

-bash-4.1$
-bash-4.1$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on Fri Jul 17 17:25:00 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> shutdown immediate
ORA-15097: cannot SHUTDOWN ASM instance with connected client (process 116951)
SQL> shut abort
ASM instance shutdown
SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options

-bash-4.1$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on Fri Jul 17 17:25:14 2015
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
Connected to an idle instance.

SQL> STARTUP PFILE='$ORACLE_HOME/dbs/init+ASM2.ora';
ASM instance started

Total System Global Area  413372416 bytes
Fixed Size                  2228904 bytes
Variable Size             385977688 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted
SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string
SQL> quit

-bash-4.1$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on Fri Jul 17 17:27:24 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> shut abort
ASM instance shutdown
SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options
-bash-4.1$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on Fri Jul 17 17:27:33 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.

SQL> STARTUP
ASM instance started

Total System Global Area 413372416 bytes
Fixed Size 2228904 bytes
Variable Size 385977688 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
SQL> show parameter spfile

NAME TYPE VALUE
———————————— ———– ——————————
spfile string +OCRVOTE/ecnode-cluster/asmpar
ameterfile/registry.253.884790
979
SQL> quit

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s