Monday, October 14, 2013

PROT-30: The Oracle Cluster Registry location to be added is not usable


##########################
## Error
##########################

PROT-30: The Oracle Cluster Registry location to be added is not usable

### Full Error

+ASM1 @ hostd01:/u01/app/oracle/exp
> sudo ocrconfig -add /u01/app/oracle/exp
PROT-30: The Oracle Cluster Registry location to be added is not usable
PROC-8: Cannot perform cluster registry operation because one of the parameters is invalid. Operating System error [Resource temporarily unavailable] [11]

##########################
#  Error Occurred
##########################

Error occured while trying to add another(mirror) location to OCR Files. Our OCR is presently in ASM diskgroup.

##########################
## Command Executed
##########################

In Terminal, by setting ASM instance,

sudo ocrconfig -add /u01/app/oracle/exp

(or)

sudo ocrconfig -add /u01/app/oracle/product/11.2/ocr.dat

##########################
## Issue Description.
##########################

### 11.2.0.3.0

#########################################
# 1) Check the CRS logs for errors recorded while running this command.
#########################################

+ASM1 @ hostd01:/u01/app/oracle/exp
> sudo ocrconfig -add /u01/app/oracle/exp
PROT-30: The Oracle Cluster Registry location to be added is not usable
PROC-8: Cannot perform cluster registry operation because one of the parameters is invalid. Operating System error [Resource temporarily unavailable] [11]

Errors Recorded in crsd.log :

+ASM1 @ hostd01:/u01/app/11.2/grid1/log/hostd01/crsd
> tail -f crsd.log
2013-10-14 01:21:23.162: [   CRSPE][1187469632] {2:40710:2864} Expression Filter : ((NAME == ora.scan1.vip) AND (LAST_SERVER == hostd02))
2013-10-14 01:21:41.455: [  OCROSD][947927360]utdvch:-1: New location /u01/app/oracle/exp configured is not valid storage type. Return code [37].
2013-10-14 01:21:41.455: [  OCRRAW][947927360]propriodvch: Error  [8] returned device check for [/u01/app/oracle/exp]
2013-10-14 01:21:41.455: [  OCRRAW][947927360]dev_replace: master could not verify the new disk (8)
[  OCRSRV][947927360]proas_replace_disk: Failed in changing configurations in the Master 8

If we can see from the above crsd.log, its mentioned as STORAGE TYPE is not a valid one.

When tried the below command by creating a dummy file(ocr.dat) with touch command. Received the below errors,

sudo ocrconfig -add /u01/app/oracle/exp/ocr.dat

Errors Recorded in crsd.log :

+ASM1 @ hostd01:/u01/app/11.2/grid1/log/hostd01/crsd
> tail -f crsd.log
2013-10-14 01:15:23.108: [   CRSPE][1187469632] {2:40710:2858} Expression Filter : ((NAME == ora.scan1.vip) AND (LAST_SERVER == hostd02))
2013-10-14 01:16:04.995: [  OCROSD][945826112]utstoragetypecommon: Oracle Cluster Registry does not support the storage type configured.
OCR can be configured on: ASM, OCFS, OCFS2, NFS, Block Device, Character Device, VxFS
2013-10-14 01:16:04.995: [  OCROSD][945826112]utdvch:-1: New location /u01/app/oracle/exp/ocr.dat configured is not valid storage type. Return code [37].
2013-10-14 01:16:04.995: [  OCRRAW][945826112]propriodvch: Error  [8] returned device check for [/u01/app/oracle/exp/ocr.dat]
2013-10-14 01:16:04.995: [  OCRRAW][945826112]dev_replace: master could not verify the new disk (8)
[  OCRSRV][945826112]proas_replace_disk: Failed in changing configurations in the Master 8

If we look in the error log details, it shows as,

OCR can be configured on: ASM, OCFS, OCFS2, NFS, Block Device, Character Device, VxFS

Checking the File system type,

df -T /u01/app/oracle/exp


+ASM1 @ hostd01:/u01
> df -T /u01/app/oracle/exp
Filesystem    Type   1K-blocks      Used Available Use% Mounted on
/dev/mapper/vg00-oracle--exp
              ext3     5160576   4205536    692896  86% /u01/app/oracle/exp

##########################
## Solution
##########################

As the file system type is ext3, i have add the alternate location for OCR to ASM diskgroup.


+ASM1 @ hostd01:/u01/app/oracle/backup
> sudo ocrconfig -add +test_DATA
+ASM1 @ hostd01:/u01/app/oracle/backup

+ASM1 @ hostd01:/u01/app/oracle/backup
> ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          3
         Total space (kbytes)     :     262120
         Used space (kbytes)      :       3444
         Available space (kbytes) :     258676
         ID                       : 1882253608
         Device/File Name         :  +OCR_VOTE
                                    Device/File integrity check succeeded
         Device/File Name         : +test_DATA
                                    Device/File integrity check succeeded

                                    Device/File not configured

                                    Device/File not configured

                                    Device/File not configured

         Cluster registry integrity check succeeded

         Logical corruption check bypassed due to non-privileged user


No comments: