你的位置:首页 > 数据库

[数据库]【故障处理】 DBCA建库报错CRS


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

一.1  BLOG文档结构图

 

wps607F.tmp 

 

一.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>

[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]:/>

[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]:/>

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

[ZFXDESKDB3:root]:/>

[ZFXDESKDB3:root]:/>

[ZFXDESKDB3:root]:/>su - grid

[ZFXDESKDB3:grid]:/home/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可以修改资源的配置

 

 

 

About Me

 

....................................................................................................................................................

本文作者:小麦苗,只专注于数据库的技术,更注重技术的运用

ITPUB BLOG:http://blog.itpub.net/26736162

本文地址:http://blog.itpub.net/26736162/viewspace-2114484/

本文pdf版:http://yunpan.cn/cdEQedhCs2kFz (提取码:ed9b)

QQ:642808185 若加QQ请注明您所正在读的文章标题

于 2016-06-03 10:00~ 2016-06-03 19:00 在中行完成

【版权所有,文章允许转载,但须以链接方式注明源地址,否则追究法律责任】

....................................................................................................................................................