Oracle Cluster Registry location to Bes Added is not Accessible

Applies To:

Oracle server-enterprise edition-version 11.2.0.1 and later
Information in this document applies to any platform.

GOAL

This is the to list OCR storage requirement and to provide the location of the diagnostic information if PROT-30 is reported.

FIX

OCR Storage Requirement:

A. If located on shared file system:

A1. At least 280 MB of free space are required for each OCR volume as per the following documentation:

Oracle Grid I Nfrastructure Installation Guide
11g Release 2 (11.2)

Verify System Requirements

A2. Shared file systems must is mounted on all nodes before you can place OCR on them.

B. If located on ASM:

B1. The space requirement is slightly different depend on DiskGroup redundance level, refer to the following documentation for Details:

Oracle Grid Infrastructure Installation Guide
11g Release 2 (11.2)

Verify System Requirements

For External redundancy:the space requirement for the OCR IS:300MB
For Normal redundancy:the space requirement for the OCR IS:600MB
For-high redundancy:the space requirement for the OCR IS:900MB


B2. The DiskGroup intended for OCR must is mounted on all nodes

B3. Compatible.asm setting for DiskGroup must is at least 11.2

B4. Oracle binary in <GRID_HOME> must has permission of "6751" or "-rwsr-s--x" on all nodes.

Diagnostic Information:

If Ocrconfig still reports the error after requirement are met, please refer-following for traces:

A. $GRID _home/log/$HOST/crsd/crsd.log; Example

2010-01-25 11:11:12.374: [Ocrasm][1291008320]proprasmo:error in Open/create file in DG [DG1]
[Ocrasm] [1291008320] Slos:slos:cat=8, Opn=kgfocr2p01, dep=15056, Loc=kgfokge
Ora-17502:ksfdcre:4 Failed to create file +dg1.255.1
Ora-15221:asm operation requires compatible.asm of 11.1.0.0.0 or higher
Ora-06512:at Line 4

B. $GRID _home/log/$HOST/client/ocrconfig_pid. Log; Example

Oracle Database 11g clusterware Release 11.2.0.1.0-production Copyright 1996, Oracle. All rights reserved.
2010-01-25 11:11:11.088: [Ocrconf][2151603648]ocrconfig starts ...
2010-01-25 11:11:12.571: [OCRCLI][2151603648]PROAC_REPLACE_DEV:[+DG1]: Failed. Retval [8]
2010-01-25 11:11:12.571: [ocrapi][2151603648]procr_replace_dev:failed to replace device (8)
2010-01-25 11:11:12.571: [ocrconf][2151603648]the new OCR device [+DG1] cannot be opened
2010-01-25 11:11:12.571: [ocrconf][2151603648]exiting [status=failed] ...

C. $ORACLE _base/diag/asm/+asm/+asmn/trace/alert_+asmn. Log, Example:

Mon Jan 25 11:11:12 2010
Errors in FILE/OPT/ORACLE/ADMIN/DIAG/ASM/+ASM/+ASM1/TRACE/+ASM1_ORA_22997.TRC:
Ora-17502:ksfdcre:4 Failed to create file +dg1.255.1
Ora-15221:asm operation requires compatible.asm of 11.1.0.0.0 or higher

Ora-15041:diskgroup "DG1" Space exhausted

D. To verify ASM diskgroup free space and compatible setting, as Grid User:

Export Oracle_sid=+asm N
Export Oracle_home=home_of_grid_installation
$ORACLE _home/bin/sqlplus/as Sysasm
Sql> Set Linesize 100
Sql> Select inst_id, Name, state, type, FREE_MB, substr (compatibility,1,10) compatibility from Gv$asm_diskgroup where n Ame= ' DG3 ' ORDER by name,inst_id;

inst_id NAME State TYPE FREE_MB Compatibil
---------  ------------------------------ ----------- ------ ---------- ----------
1 DG3 mounted EXTERN 1134 11.2.0.0.0
2 DG3 mounted EXTERN 1134 11.2.0.0.0

Miscellaneous

1. If you is trying to delete a non-exist OCR device, due to unpublished bug 8739774, Ocrconfig fails with PROT-30, the E Rror can be ignored; The bug has a been fixed in 11.2.0.2 with new error PROT-34

2. To set Compatible.asm to 11.2, log into ASM and execute:

ALTER diskgroup DG1 SET ATTRIBUTE ' compatible.asm ' = ' 11.2 ';

Oracle Cluster Registry location to Bes Added is not Accessible