合 DBCA建库报错CRS-2566 PRCR-1071 PRCR-1006
Tags: OracledbcaCRS-2566PRCR-1006PRCR-1071
【故障处理】 DBCA建库报错CRS-2566 PRCR-1071 PRCR-1006
前言部分
导读和注意事项
各位技术爱好者,看完本文后,你可以掌握如下的技能,也可以学到一些其它你所不知道的知识,~O(∩_∩)O~:
① dbca静默建库
② 将监听加入CRS中
本文简介
本来想熟悉一下DG的搭建过程,没想到第一步dbca创建测试库的时候就报错了,
PRCR-1006 : Failed to add resource ora.lhrdg.db for lhrdg
PRCR-1071 : Failed to register or update resource ora.lhrdg.db
CRS-2566: User 'oracle' does not have sufficient permissions to operate on resource 'ora.LISTENER_LHRDG.lsnr', which is part of the dependency specification.
DBCA_PROGRESS : 100%
简单查询处理了一下,这里记录一下过程。
故障分析及解决过程
故障环境介绍
项目 | source db |
---|---|
db 类型 | RAC |
db version | 11.2.0.3 |
db 存储 | ASM |
OS版本及kernel版本 | AIX 64位 5.3.0.0 |
故障发生现象及报错信息
PRCR-1006 : Failed to add resource ora.lhrdg.db for lhrdg
PRCR-1071 : Failed to register or update resource ora.lhrdg.db
CRS-2566: User 'oracle' does not have sufficient permissions to operate on resource 'ora.LISTENER_LHRDG.lsnr', which is part of the dependency specification.
DBCA_PROGRESS : 100%
ZFXDESKDB3:oracle:/oracle>dbca -silent -createDatabase -templateName General_Purpose.dbc \
> -gdbname LHRDG -sid LHRDGZK \
> -sysPassword lhr -systemPassword lhr \
> -datafileDestination 'DATA/' -redoLogFileSize 50 -recoveryAreaDestination '/arch' \
> -storageType ASM -asmsnmpPassword lhr -diskGroupName 'DATA' -responseFile NO_VALUE \
> -characterset ZHS16GBK -nationalCharacterSet AL16UTF16 -sampleSchema true -automaticMemoryManagement true \
> -totalMemory 1024 -nodeinfo ZFXDESKDB3,ZFXDESKDB4
Copying database files
100% complete
Look at the log file "/oracle/app/oracle/cfgtoollogs/dbca/LHRDG/LHRDG.log" for further details.
ZFXDESKDB3:oracle:/oracle>more /oracle/app/oracle/cfgtoollogs/dbca/LHRDG/LHRDG.log"
>