Experience: is what you get soon after you need it.
GIAC Cloud Penetration Tester (GCPN)
GIAC Cloud Security Automation (GCSA)
GIAC Security Essentials (GSEC)
Certified Kubernetes Administrator (CKA)
Cloud Certified Security Professional (ISC2)
CyberSecurity Certified Professional (ISC2)
AWS Certified Solutions Architect Associate
Azure Certified Architect Expert
Azure Certified Architect
Azure Certified Administrator
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
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:
Post a Comment