CRS-5019

APPLIES TO

Operating System - Oracle Linux Server 7.9
Oracle Database - Enterprise Edition - Version 11.2.0.4.0
Oracle Grid Infrastructure - Version 11.2.0.4.0

SYMPTOMS

"/u01/app/11.2.0/grid/log/oracle11grac03/alertoracle11grac03.log"
2024-02-10 09:17:05.240:
[/u01/app/11.2.0/grid/bin/oraagent.bin(27008)]CRS-5019:All OCR locations are on ASM disk groups [OCR], and none of these disk groups are mounted. Details are at "(:CLSN00100:)" in "/u01/app/11.2.0/grid/log/oracle11grac03/agent/ohasd/oraagent_grid/oraagent_grid.log".
2024-02-10 09:17:35.246:
[/u01/app/11.2.0/grid/bin/oraagent.bin(27008)]CRS-5019:All OCR locations are on ASM disk groups [OCR], and none of these disk groups are mounted. Details are at "(:CLSN00100:)" in "/u01/app/11.2.0/grid/log/oracle11grac03/agent/ohasd/oraagent_grid/oraagent_grid.log".

CAUSE

The OCR disk group fails to be mounted.

SOLUTION

Check whether the OCR has a backup.

~]# /u01/app/11.2.0/grid/bin/ocrconfig -showbackup
PROT-26: Oracle Cluster Registry backup locations were retrieved from a local copy

oracle11grac03 2024/02/09 22:41:29 /u01/app/11.2.0/grid/cdata/newrac-cluster/backup00.ocr

oracle11grac03 2024/02/09 18:41:29 /u01/app/11.2.0/grid/cdata/newrac-cluster/backup01.ocr

oracle11grac03 2024/02/09 14:41:28 /u01/app/11.2.0/grid/cdata/newrac-cluster/backup02.ocr

oracle11grac03 2024/02/09 02:41:25 /u01/app/11.2.0/grid/cdata/newrac-cluster/day.ocr

oracle11grac03 2024/02/09 02:41:25 /u01/app/11.2.0/grid/cdata/newrac-cluster/week.ocr
PROT-25: Manual backups for the Oracle Cluster Registry are not available

Clear the disk header of a member disk in the OCR disk group.

~]# oracleasm deletedisk OCR01
~]# oracleasm deletedisk OCR02
~]# dd if=/dev/zero of=/dev/sdb1 bs=4096 count=1
~]# dd if=/dev/zero of=/dev/sdc1 bs=4096 count=1
~]# oracleasm createdisk OCR01 /dev/sdb1
~]# oracleasm createdisk OCR02 /dev/sdc1

~]# /u01/app/oracle/product/11.2.0/db_1/bin/kfed read /dev/sdb1 aun=0 blkn=0 | more
kfbh.endian: 0 ; 0x000: 0x00
kfbh.hard: 0 ; 0x001: 0x00
kfbh.type: 0 ; 0x002: KFBTYP_INVALID
kfbh.datfmt: 0 ; 0x003: 0x00
kfbh.block.blk: 0 ; 0x004: blk=0
kfbh.block.obj: 0 ; 0x008: file=0
kfbh.check: 810697598 ; 0x00c: 0x3052437e
kfbh.fcn.base: 0 ; 0x010: 0x00000000
kfbh.fcn.wrap: 0 ; 0x014: 0x00000000
kfbh.spare1: 0 ; 0x018: 0x00000000
kfbh.spare2: 0 ; 0x01c: 0x00000000
7F433B1FD400 00000000 00000000 00000000 3052437E [............~CR0]
7F433B1FD410 00000000 00000000 00000000 00000000 [................]
7F433B1FD420 4C43524F 4B534944 3052434F 00000031 [ORCLDISKOCR01...]
7F433B1FD430 00000000 00000000 00000000 00000000 [................]
Repeat 252 times
KFED-00322: file not found; arguments: [kfbtTraverseBlock] [Invalid OSM block type] [] [0]

Start Oracle Clusterware in exclusive mode without starting CRSD.

~]# /u01/app/11.2.0/grid/bin/crsctl stop crs -f
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'oracle11grac03'
CRS-2673: Attempting to stop 'ora.crf' on 'oracle11grac03'
CRS-2673: Attempting to stop 'ora.ctssd' on 'oracle11grac03'
CRS-2673: Attempting to stop 'ora.evmd' on 'oracle11grac03'
CRS-2673: Attempting to stop 'ora.asm' on 'oracle11grac03'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'oracle11grac03'
CRS-2677: Stop of 'ora.crf' on 'oracle11grac03' succeeded
CRS-2677: Stop of 'ora.evmd' on 'oracle11grac03' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'oracle11grac03' succeeded
CRS-2677: Stop of 'ora.asm' on 'oracle11grac03' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'oracle11grac03'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'oracle11grac03' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'oracle11grac03' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'oracle11grac03'
CRS-2677: Stop of 'ora.cssd' on 'oracle11grac03' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'oracle11grac03'
CRS-2677: Stop of 'ora.gipcd' on 'oracle11grac03' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'oracle11grac03'
CRS-2677: Stop of 'ora.gpnpd' on 'oracle11grac03' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'oracle11grac03' has completed
CRS-4133: Oracle High Availability Services has been stopped.

~]# /u01/app/11.2.0/grid/bin/crsctl start crs -excl -nocrs
CRS-4123: Oracle High Availability Services has been started.
CRS-2672: Attempting to start 'ora.mdnsd' on 'oracle11grac03'
CRS-2676: Start of 'ora.mdnsd' on 'oracle11grac03' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'oracle11grac03'
CRS-2676: Start of 'ora.gpnpd' on 'oracle11grac03' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'oracle11grac03'
CRS-2672: Attempting to start 'ora.gipcd' on 'oracle11grac03'
CRS-2676: Start of 'ora.cssdmonitor' on 'oracle11grac03' succeeded
CRS-2676: Start of 'ora.gipcd' on 'oracle11grac03' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'oracle11grac03'
CRS-2672: Attempting to start 'ora.diskmon' on 'oracle11grac03'
CRS-2676: Start of 'ora.diskmon' on 'oracle11grac03' succeeded
CRS-2676: Start of 'ora.cssd' on 'oracle11grac03' succeeded
CRS-2679: Attempting to clean 'ora.cluster_interconnect.haip' on 'oracle11grac03'
CRS-2672: Attempting to start 'ora.ctssd' on 'oracle11grac03'
CRS-2681: Clean of 'ora.cluster_interconnect.haip' on 'oracle11grac03' succeeded
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'oracle11grac03'
CRS-2676: Start of 'ora.ctssd' on 'oracle11grac03' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'oracle11grac03' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'oracle11grac03'
CRS-2676: Start of 'ora.asm' on 'oracle11grac03' succeeded

~]# /u01/app/11.2.0/grid/bin/crsctl stat res -t -init
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.asm
1 ONLINE INTERMEDIATE oracle11grac03 OCR not started
ora.cluster_interconnect.haip
1 ONLINE ONLINE oracle11grac03
ora.crf
1 OFFLINE OFFLINE
ora.crsd
1 OFFLINE OFFLINE
ora.cssd
1 ONLINE ONLINE oracle11grac03
ora.cssdmonitor
1 ONLINE ONLINE oracle11grac03
ora.ctssd
1 ONLINE ONLINE oracle11grac03 ACTIVE:0
ora.diskmon
1 OFFLINE OFFLINE
ora.evmd
1 OFFLINE OFFLINE
ora.gipcd
1 ONLINE ONLINE oracle11grac03
ora.gpnpd
1 ONLINE ONLINE oracle11grac03
ora.mdnsd
1 ONLINE ONLINE oracle11grac03

Create the new OCR disk group, restore the OCR configuration and voting file.

~]$ sqlplus / as sysasm

SQL> CREATE DISKGROUP OCR EXTERNAL REDUNDANCY DISK
'ORCL:OCR01','ORCL:OCR02'
ATTRIBUTE 'COMPATIBLE.ASM' = '11.2';

~]# /u01/app/11.2.0/grid/bin/ocrconfig -restore /u01/app/11.2.0/grid/cdata/newrac-cluster/backup00.ocr

~]# /u01/app/11.2.0/grid/bin/crsctl replace votedisk +OCR
Successful addition of voting disk 957c110f0b724fd2bf93639927c84572.
Successfully replaced voting disk group with +OCR.
CRS-4266: Voting file(s) successfully replaced

~]# /u01/app/11.2.0/grid/bin/crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 957c110f0b724fd2bf93639927c84572 (ORCL:OCR01) [OCR]

Create spfile to OCR disk group.

~]$ cat > /tmp/asm_spfile.ora << EOF
+ASM2.asm_diskgroups='DATA','RECO'#Manual Mount
+ASM1.asm_diskgroups='DATA','RECO'#Manual Mount
*.asm_power_limit=1
*.diagnostic_dest='/u01/app/grid'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='EXCLUSIVE'
EOF

SQL> create spfile='+OCR' from pfile='/tmp/asm_spfile.ora';

Restart Oracle Clusterware.

~]# /u01/app/11.2.0/grid/bin/crsctl stop crs -f
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'oracle11grac03'
CRS-2673: Attempting to stop 'ora.ctssd' on 'oracle11grac03'
CRS-2673: Attempting to stop 'ora.asm' on 'oracle11grac03'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'oracle11grac03'
CRS-2677: Stop of 'ora.mdnsd' on 'oracle11grac03' succeeded
CRS-2677: Stop of 'ora.asm' on 'oracle11grac03' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'oracle11grac03'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'oracle11grac03' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'oracle11grac03' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'oracle11grac03'
CRS-2677: Stop of 'ora.cssd' on 'oracle11grac03' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'oracle11grac03'
CRS-2677: Stop of 'ora.gipcd' on 'oracle11grac03' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'oracle11grac03'
CRS-2677: Stop of 'ora.gpnpd' on 'oracle11grac03' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'oracle11grac03' has completed
CRS-4133: Oracle High Availability Services has been stopped.

~]# /u01/app/11.2.0/grid/bin/crsctl start crs
CRS-4123: Oracle High Availability Services has been started.

~]# /u01/app/11.2.0/grid/bin/crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE oracle11grac03
ora.LISTENER.lsnr
ONLINE ONLINE oracle11grac03
ora.OCR.dg
ONLINE ONLINE oracle11grac03
ora.RECO.dg
ONLINE ONLINE oracle11grac03
ora.asm
ONLINE ONLINE oracle11grac03 Started
ora.gsd
OFFLINE OFFLINE oracle11grac03
ora.net1.network
ONLINE ONLINE oracle11grac03
ora.ons
ONLINE ONLINE oracle11grac03
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE oracle11grac03
ora.cvu
1 ONLINE ONLINE oracle11grac03
ora.oc4j
1 ONLINE ONLINE oracle11grac03
ora.oracle11grac03.vip
1 ONLINE ONLINE oracle11grac03
ora.oracle11grac04.vip
1 ONLINE INTERMEDIATE oracle11grac03 FAILED OVER
ora.scan1.vip
1 ONLINE ONLINE oracle11grac03

~]# /u01/app/11.2.0/grid/bin/ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2600
Available space (kbytes) : 259520
ID : 1588806050
Device/File Name : +OCR
Device/File integrity check succeeded

Device/File not configured

Device/File not configured

Device/File not configured

Device/File not configured

Cluster registry integrity check succeeded

Logical corruption check succeeded

Restart Oracle Clusterware on another node.

~]# /u01/app/11.2.0/grid/bin/crsctl start crs
CRS-4123: Oracle High Availability Services has been started.

~]# /u01/app/11.2.0/grid/bin/crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE oracle11grac03
ONLINE ONLINE oracle11grac04
ora.LISTENER.lsnr
ONLINE ONLINE oracle11grac03
ONLINE ONLINE oracle11grac04
ora.OCR.dg
ONLINE ONLINE oracle11grac03
ONLINE ONLINE oracle11grac04
ora.RECO.dg
ONLINE ONLINE oracle11grac03
ONLINE ONLINE oracle11grac04
ora.asm
ONLINE ONLINE oracle11grac03 Started
ONLINE ONLINE oracle11grac04 Started
ora.gsd
OFFLINE OFFLINE oracle11grac03
OFFLINE OFFLINE oracle11grac04
ora.net1.network
ONLINE ONLINE oracle11grac03
ONLINE ONLINE oracle11grac04
ora.ons
ONLINE ONLINE oracle11grac03
ONLINE ONLINE oracle11grac04
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE oracle11grac03
ora.cvu
1 ONLINE ONLINE oracle11grac03
ora.oc4j
1 ONLINE ONLINE oracle11grac03
ora.oracle11grac03.vip
1 ONLINE ONLINE oracle11grac03
ora.oracle11grac04.vip
1 ONLINE ONLINE oracle11grac04
ora.scan1.vip
1 ONLINE ONLINE oracle11grac03