【故障處理】 DBCA建庫報錯CRS-2566 PRCR-1071 PRCR-1006
各位技術愛好者,看完本文後,你可以掌握如下的技能,也可以學到一些其它你所不知道的知識,~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皆可,您的批評指正是我寫作的最大動力。
本來想熟悉一下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>
[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 來修改。
① rac添加LISTENER資源的時候需要使用grid用戶
② srvctl config查看資源的具體配置情況
③ srvctl modify可以修改資源的配置
....................................................................................................................................................
本文作者:小麥苗,只專注於數據庫的技術,更注重技術的運用
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 在中行完成
【版權所有,文章允許轉載,但須以鏈接方式注明源地址,否則追究法律責任】
....................................................................................................................................................