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

最新推荐文章于 2022-12-28 16:31:07 发布

「已注销」

最新推荐文章于 2022-12-28 16:31:07 发布

阅读量817

点赞数

分类专栏： Oracle故障排除

本文链接：https://blog.csdn.net/u010098331/article/details/50766942

版权

Oracle故障排除专栏收录该内容

74 篇文章 2 订阅

订阅专栏

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