合 DBCA建库报错CRS-2566 PRCR-1071 PRCR-1006

【故障处理】 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%

简单查询处理了一下，这里记录一下过程。

故障分析及解决过程

故障环境介绍

故障发生现象及报错信息

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"

>

>

ZFXDESKDB3:oracle:/oracle>more /oracle/app/oracle/cfgtoollogs/dbca/LHRDG/LHRDG.log

Copying database files

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>oerr crs 2566

2566, 1, "User '%s' does not have sufficient permissions to operate on resource '%s', which is part of the dependency specification."

// *Cause: User does not have permissions to operate on the resource as it will prevent the current resource from starting or staying online in future.

// *Action: The user performing the operation must have access

// privileges to operate on the entire resource dependency tree. The

// user must either be given those privileges by modifying the dependent

// resources' access rights or another user having permissions should

// perform this operation.

《《《《---------------------简单点还是没有权限，且和 resource 'ora.LISTENER_LHRDG.lsnr'有关，这个资源是我创建dg的时候单独开的监听，且看看该资源的配置情况

ZFXDESKDB3:grid:/home/grid>srvctl config listener -l LISTENER_LHRDG -a

Name: LISTENER_LHRDG

Network: 1, Owner: root《《《《----------很明显的错误，owner是root，

Home: \<CRS home>

/oracle/app/11.2.0/grid on node(s) zfxdeskdb3,zfxdeskdb4

End points: TCP:1523

《《《《-----下边删除该资源重新添加

ZFXDESKDB3:grid:/home/grid>srvctl remove listener -l LISTENER_LHRDG

PRCR-1025 : Resource ora.LISTENER_LHRDG.lsnr is still running

后续精彩内容已被站长无情隐藏，请输入验证码解锁本文！

验证码：

获取验证码： 请先关注本站微信公众号，然后回复“验证码”，获取验证码。在微信里搜索“AiDBA”或者“dbaup6”或者微信扫描右侧二维码都可以关注本站微信公众号。