ASM Startup


SQL> startup restrict
ASM instance started
Total System Global Area 283930624 bytes
Fixed Size 2212656 bytes
Variable Size 256552144 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
SQL> SELECT NAME, STATE FROM V$ASM_DISKGROUP;
NAME STATE
—————————— ———–
FRA RESTRICTED

 

I am trying to start:
SQL> startup
ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file ‘+FRA/asmoracle/spfileasmoracle.ora’
ORA-17503: ksfdopn:2 Failed to open file +FRA/asmoracle/spfileasmoracle.ora
ORA-15056: additional error message
ORA-17503: ksfdopn:DGOpenFile05 Failed to open file +FRA/asmoracle/spfileasmoracle.ora
ORA-17503: ksfdopn:2 Failed to open file +FRA/asmoracle/spfileasmoracle.ora
ORA-15236: diskgroup FRA mounted in restricted mode
ORA-06512: at line 4
SQL>
Solution: In my option:
SQL> shutdown immediate
ASM diskgroups dismounted
ASM instance shutdown
SQL> startup
ASM instance started
Total System Global Area 283930624 bytes
Fixed Size 2212656 bytes
Variable Size 256552144 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
SQL> SELECT NAME, STATE FROM V$ASM_DISKGROUP;
NAME STATE
—————————— ———–
FRA MOUNTED

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: