PRVF-4195,KFOD-00300,ORA-15080,ORA-12801 When Running Cluvfy Comp Ocr (post GRID insta

来源：互联网发布：民族音乐现状的数据编辑：程序博客网时间：2024/06/07 03:05

In this Document
  Symptoms
  Cause
  Solution
  References

APPLIES TO:

Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later [Release: 11.2 and later ]
Information in this document applies to any platform.

SYMPTOMS

When attempting to run 'cluvfy comp ocr' (post install of Oracle 11gR2 Clusterware), the following errors are encountered:

PRVF-4195 : Disk group for ocr location "+CAMPRODCRS" not available
PRVF-4162 : Size of the OCR location "+CAMPRODCRS" could not be determined

TRACE FILE

/orasoftgrid/app/oracle/11.2.0/grid/bin/kfod op=GROUPS nohdr=true
KFOD-00300: OCI error [-1] [OCI error] [ORA-12801: error signaled in parallel query server PZ98, instance jwcamprod1.obs.local:+ASM1 (1)
ORA-15080: synchronous I/O operation to a disk failed
ORA-15080: synchronous I/O operation to a disk failed

CAUSE

The cause can be one of the following:

1. Discovery string has /dev/* which picks up /dev/random.
2. Discovery string is picking up other devices that were previously removed from multipath configuration.

SOLUTION

-- This will need a down time.

1. Copy/backup profile.xml

cp $GRID_HOME/gpnp/<node_name>/profiles/peer/profile.xml $GRID_HOME/gpnp/<node_name>/profiles/peer/profile.xml.`date +"%Y%m%d_%H%M"`.orig

2. Change discovery string:

-- connect to asm using sqlplus
-- depending on the associated disk names you can use the following:
SQL> alter system set asm_diskstring='/dev/mapper/*camprod*' scope=spfile;
OR
SQL> alter system set asm_diskstring='/dev/ssd*' scope=spfile;

3. Need to restart the ASM on all nodes or restart CRS on all nodes.

4. Run 'cluvfy comp ocr' again and check

REFERENCES

PRVF-4195 KFOD-00300 ORA-15080 ORA-12801 CLUVFY KFOD OP=GROUPS /DEV/RANDOM