Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Thursday, January 6, 2011

11gR2 modify resource to autostart after creating pfile

then modify the resource attributes to start automatically.
For ASM in 11gR2-11.2.0.2:
I created pfile from spfile and started the instance with pfile:

SQL> startup pfile='PATH/init+ASM1.ora';
ASM instance started

Total System Global Area 2120624 bytes
Fixed Size 2212656 bytes
Variable Size 27289364 bytes
ASM Cache 3214564 bytes
*ORA-15110: no diskgroups mounted*

checked the diskgroups:
check the resource is online or offline by:
crsctl status resource -t

Then add the resources that are offline to auto start by:

>crsctl modify resource "ora.DATA_01.dg" -attr "AUTO_START=1"

slpnprdb09cdp(+ASM) /export/home/oracle
>crsctl modify resource "ora.FRA_01.dg" -attr "AUTO_START=1"


SQL> startup
ASM instance started

Total System Global Area 392626176 bytes
Fixed Size 2148392 bytes
Variable Size 365311960 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted

No comments: