Remember once the inexplicable Oracle RAC Boot failed

Environment: Oracle 11g R2

Nodes: C1, C2

Shared Devices: San+asm

Phenomenon:

C2 boot is completely normal, C1 boot appears:

Ora-01078:failure in processing system parameters

Ora-01565:error in identifying file ' +asm/orcl/spfileorcl.ora '

Ora-17503:ksfdopn:2 Failed to open file +asm/orcl/spfileorcl.ora

Ora-15056:additional error message

Ora-17503:ksfdopn:dgopenfile05 Failed to open file +asm/orcl/spfileorcl.ora

Ora-17503:ksfdopn:2 Failed to open file +asm/orcl/spfileorcl.ora

Ora-15001:diskgroup "ASM" does not exist or was not mounted

Ora-06512:at Line 4

A child is a permission-related issue.

Use this

Create spfile= ' +asm/orcl/sss.ora ' from pfile= '/u01/app/oracle/product/11.2.0/db_1/dbs/init.ora ';

Create spfile= ' +asm/orcl/sss.ora ' from pfile= '/u01/app/oracle/product/11.2.0/db_1/dbs/init.ora '

*

ERROR at line 1:

Ora-17502:ksfdcre:4 Failed to create file +asm/orcl/sss.ora

Ora-15077:could not locate ASM instance serving a required DiskGroup

Error warning +ASM not recognized.

Try 1:

View Permissions

ASM disk permissions are on C1, C2

BRW-RW----1 grid asmadmin 8, Mar 09:34 V1

BRW-RW----1 grid asmadmin 8, Mar 09:34 V2

BRW-RW----1 grid asmadmin 8, 09:34 V3

BRW-RW----1 Grid asmadmin 8, April 09:34 V4

Because the Oracle user is also in the Asmadmin group, so C2 can read and write C1 can read and write, this part does not see the problem.

Try 2:

Using grid users to view in Asmcmd

On the C2 node, you can see

ASM path and Grid path, that is, two ASM disk groups, the information is correct.

On the C1 node, you can see

Grid path, but the ASM path is not visible. The information is incomplete.

Try 3:

Start ASMCA with a grid user

In both C1 and C2, ASM and grid two disk groups are mounted states, and the instance is up state. Still don't see any problem.

Try 4:

On C1, use ASMCA for unmount ASM Disk Group, and then Mount ASM Disk Group.

Restart the C1 instance again:

Successful, the +ASM disk can be identified.

Remember once the inexplicable Oracle RAC Boot failed