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

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

****************I am authoring a Book on Oracle Database Cloud Services.......More details to follow.***************

Title : Oracle Database Cloud Revealed
Publisher : Apress
Release Date : Jan-2019

**********************************************************************************


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]


My Cloud Certifications:

AWS Certified Solutions Architect Associate

Oracle Cloud Infrastructure 2018 Certified Architect Associate.

Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate.

Oracle Database Cloud Administrator Certified Professional.

Oracle Database Cloud Service Operations Certified Associate.

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: