Sunday, April 03, 2011

How to Change 11gR2 ASM parameter in Non-RAC environment


Steps :
1.      shutdown listener 
2.      shutdown databases
3.      change ASM parameter
4.      shutdown ASM as sysasm
5.      mount ASM
6.      check changed parameter
7.      startup databases as sysasm
8.      check connectivity


Change ASM parameter

sqlplus / as sysasm
  > show parameter proc
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
processes                            integer     100

> alter system set processes=800 scope=spfile;
System altered.

>  show parameter proc
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
processes                            integer     100

Shutdown ASM

> shutdown immediate
ASM diskgroups volume disabled
ASM diskgroups dismounted
ASM instance shutdown

Mount ASM

> startup mount
ASM instance started

Total System Global Area  283930624 bytes
Fixed Size                  2225792 bytes
Variable Size             256539008 bytes
ASM Cache                  25165824 bytes
ASM diskgroups mounted
ASM diskgroups volume enabled

Check changed parameter

>  show parameter proc
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
processes                            integer     800
> exit

 
Hope this helps! Rupam