Tuesday, March 22, 2011

Startup and shutdown of Oracle ASM

 # cat /etc/group
asmadmin:!:6000:oracle

$ echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0/grid
$ echo $ORACLE_SID
+ASM


Starting an ASM instance(as user oracle):
$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 21 22:42:18 2011

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

SQL> startup;
ORA-01031: insufficient privileges
SQL> connect sys as sysasm
Enter password:
Connected to an idle instance.
SQL> startup;
ASM instance started

Total System Global Area  283930624 bytes
Fixed Size                  2206088 bytes
Variable Size             256558712 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted
SQL>

isvp18> ps -ef | grep -i asm
  oracle  7274562        1   0 22:44:17      -  0:00 asm_rbal_+ASM
  oracle  8126534        1   0 22:44:17      -  0:00 asm_mmnl_+ASM
  oracle  8913064        1   0 22:44:17      -  0:00 asm_smon_+ASM
  oracle  8978618        1   0 22:44:17      -  0:00 asm_ckpt_+ASM
  oracle  9765052        1   0 22:44:16      -  0:00 asm_diag_+ASM
    root  9830508 13172966   0 22:49:51  pts/2  0:00 grep -i -i asm
  oracle 10027226        1   0 22:44:16      -  0:00 asm_gen0_+ASM
  oracle 10289252        1   0 22:44:17      -  0:00 asm_mmon_+ASM
  oracle 10748040 16253002   0 22:43:47      -  0:00 oracle+ASM (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
  oracle 10813538        1   0 22:44:17      -  0:00 asm_mman_+ASM
  oracle 10879092        1   0 22:44:16      -  0:00 asm_pmon_+ASM
  oracle 11010134        1   0 22:44:17      -  0:00 asm_dbw0_+ASM
  oracle 11075668        1   0 22:44:17      -  0:00 asm_dia0_+ASM
  oracle 13304010 16253002   0 22:44:24      -  0:00 oracle+ASM (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
  oracle 13828280        1   0 22:44:16      -  0:00 asm_psp0_+ASM
  oracle 14483708        1   0 22:44:17      -  0:00 asm_gmon_+ASM
  oracle 14549092        1   0 22:44:16      -  0:00 asm_vktm_+ASM
  oracle 24444936        1   0 22:44:17      -  0:00 asm_lgwr_+ASM
isvp18>



Shutdown of ASM instance(as user oracle):

$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Mon Mar 21 22:37:34 2011

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

SQL> connect sys as sysasm
Enter password:
Connected.
SQL> shutdown;
ASM diskgroups dismounted
ASM instance shutdown
SQL>


No comments: