【故障处理】 DBCA建库报错CRS-2566

一.1 BLOG文档结构图

一.2 前言部分

一.2.1 导读和注意事项

各位技术爱好者，看完本文后，你可以掌握如下的技能，也可以学到一些其它你所不知道的知识，~O(∩_∩)O~：

① dbca静默建库

② 将监听加入CRS中

Tips：

① 若文章代码格式有错乱，推荐使用搜狗、QQ或360浏览器，也可以下载pdf格式的文档来查看，pdf文档下载地址：http://yunpan.cn/cdEQedhCs2kFz （提取码：ed9b）

② 本篇BLOG中命令的输出部分需要特别关注的地方我都用灰色背景和粉红色字体来表示，比如下边的例子中，thread 1的最大归档日志号为33，thread 2的最大归档日志号为43是需要特别关注的地方；而命令一般使用黄色背景和红色字体标注；对代码或代码输出部分的注释一般采用蓝色字体表示。

List of Archived Logs in backup set 11

Thrd Seq Low SCN Low Time Next SCN Next Time

---- ------- ---------- ------------------- ---------- ---------

1 32 1621589 2015-05-29 11:09:52 1625242 2015-05-29 11:15:48

1 33 1625242 2015-05-29 11:15:48 1625293 2015-05-29 11:15:58

2 42 1613951 2015-05-29 10:41:18 1625245 2015-05-29 11:15:49

2 43 1625245 2015-05-29 11:15:49 1625253 2015-05-29 11:15:53

[ZFXXDB1:root]:/>lsvg -o

T_XDESK_APP1_vg

rootvg

[ZFXXDB1:root]:/>

00:27:22 SQL> alter tablespace idxtbs read write;

====》2097152*512/1024/1024/1024=1G

本文如有错误或不完善的地方请大家多多指正，ITPUB留言或QQ皆可，您的批评指正是我写作的最大动力。

一.2.2 本文简介

本来想熟悉一下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%

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

一.3 故障分析及解决过程

一.3.1 故障环境介绍

项目	source db
db 类型	RAC
db version	11.2.0.3
db 存储	ASM
OS版本及kernel版本	AIX 64位 5.3.0.0

一.3.2 故障发生现象及报错信息

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>

[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

[ZFXDESKDB3:grid]:/home/grid>crsctl stop resource ora.LISTENER_LHRDG.lsnr

CRS-0245: User doesn't have enough privilege to perform the operation

CRS-4000: Command Stop failed, or completed with errors.

[ZFXDESKDB3:grid]:/home/grid>exit

[ZFXDESKDB3:root]:/>

[ZFXDESKDB3:root]:/>crsctl stop resource ora.LISTENER_LHRDG.lsnr

CRS-2673: Attempting to stop 'ora.LISTENER_LHRDG.lsnr' on 'zfxdeskdb4'

CRS-2673: Attempting to stop 'ora.LISTENER_LHRDG.lsnr' on 'zfxdeskdb3'

CRS-2677: Stop of 'ora.LISTENER_LHRDG.lsnr' on 'zfxdeskdb4' succeeded

CRS-2677: Stop of 'ora.LISTENER_LHRDG.lsnr' on 'zfxdeskdb3' succeeded

[ZFXDESKDB3:root]:/>

[ZFXDESKDB3:root]:/>srvctl remove listener -l LISTENER_LHRDG

[ZFXDESKDB3:root]:/>

[ZFXDESKDB3:root]:/>su - grid

[ZFXDESKDB3:grid]:/home/grid>

[ZFXDESKDB3:grid]:/home/grid>srvctl add listener -l LISTENER_LHRDG -p 1523 -o $ORACLE_HOME

[ZFXDESKDB3:grid]:/home/grid>

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

Name: LISTENER_LHRDG

Network: 1, Owner: grid

Home: <CRS home>

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

End points: TCP:1523

《《《《-----修改完成后可以正常dbca库了

[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

Cleaning up failed steps

4% complete

Copying database files

5% complete

6% complete

7% complete

33% complete

Creating and starting Oracle instance

35% complete

39% complete

43% complete

47% complete

48% complete

50% complete

52% complete

Creating cluster database views

54% complete

71% complete

Completing Database Creation

74% complete

77% complete

85% complete

94% complete

100% complete

Look at the log file "/oracle/app/oracle/cfgtoollogs/dbca/LHRDG/LHRDG0.log" for further details.

处理完了想起来还有一个modify可以直接修改的，比如这里修改user我们可以用命令 srvctl modify listener -l LISTENER_LHRDG -u grid 来修改。

一.4 故障处理总结

① rac添加LISTENER资源的时候需要使用grid用户

② srvctl config查看资源的具体配置情况

③ srvctl modify可以修改资源的配置

一.1 BLOG文档结构图

一.2 前言部分

一.2.1 导读和注意事项

一.2.2 本文简介

一.3 故障分析及解决过程

一.3.1 故障环境介绍

一.3.2 故障发生现象及报错信息

一.4 故障处理总结

更多相关文章

随机推荐