您好,登錄后才能下訂單哦!
11g ASM dbca報錯 prcr-1006 crs-0259 prcr-1071 使用ASM方式創(chuàng)建單實例DB時,在運行DBCA時出現(xiàn) PRCR-1006 : Failed to add resource ora.orcl.db for orcl PRCR-1071 : Failed to register or update resource ora.orcl.db PRCR-1001 : Resource ora.orcl.db does not exist 查看DBCA日志后,發(fā)現(xiàn)以下報錯 [oracle@dga01 orcl]$ tail -30000 trace.log | grep PRCR [Thread-138] [ 2013-03-19 14:15:51.520 CST ] [HASIDBRegistrationStep.executeImpl:253] Exception while registering with HAS PRCR-1006 : Failed to add resource ora.orcl.db for orcl PRCR-1071 : Failed to register or update resource ora.orcl.db PRCR-1001 : Resource ora.orcl.db does not exist oracle說這是一個bug 如下 Bug 11886915 : CRS-0259 WHEN REGISTERING THE DATABASE WITH ORACLE RESTART Bug 屬性 類型 B - Defect 已在產品版本中修復 嚴重性 2 - Severe Loss of Service 產品版本 11.2.0.2 狀態(tài) 33 - Suspended, Req'd Info not Avail 平臺 226 - Linux x86-64 創(chuàng)建時間 2011-3-18 平臺版本 ORACLE LINUX 5 更新時間 2011-10-3 基本 Bug N/A 數(shù)據庫版本 11.2.0.2 影響平臺 Generic 產品源 Oracle 產品線 Oracle Database Products 系列 Oracle Database 區(qū)域 Oracle Database 產品 5 - Oracle Database - Enterprise Edition Hdr: 11886915 11.2.0.2 PCW 11.2.0.2 CRS PRODID-5 PORTID-226 Abstract: CRS-0259 WHEN REGISTERING THE DATABASE WITH ORACLE RESTART *** 03/18/11 07:51 am *** PROBLEM: -------- Oracle Restart Environment, using separate Database Oracle Homes, each owned by a different OS user. A database cannot be registered with Oracle Restart when the OS user used to install the database software was created after the last restart of the Oracle Restart Environment. There must be at least 1 database from a different Oracle Home/OS owner already registered with the Oracle Restart. The database can be registered only after OHASD is restarted. DIAGNOSTIC ANALYSIS: -------------------- srvctl error: PRCR-1006 : Failed to add resource ora.elin.db for null PRCR-1071 : Failed to register or update resource ora.elin.db CRS-0259: Owner of the resource does not belong to the group. WORKAROUND: ----------- after restarting the grid infrastructure the second db can be added. However, this causes downtime for the already existing databases, which is not acceptable by the customer RELATED BUGS: ------------- Bug 10337212 Bug 10118593 Bug 11063852 REPRODUCIBILITY: ---------------- Can be reproduced as follows on CT env: - install grid infrastructure for single node (oracle restart) 11.2.0.2 using a separate OS user (grid) on linux 64 bit. - install the oracle enterprise db software using a separate OS user (oracle1), create a new db in this Oracle Home and register this db with oracle restart (happens automatically when using dbca). - Install the oracle enterprise db software using a new OS user (os user did not exists since the last grid infrastructure restart) and create a new db in this Oracle Home. At this point dbca will complain that the db can not be registered with Oracle restart and further installation (db console) will fail. Manual registration attempts using srvctl will also fail. - Restart the ohas (crsctl stop has / crsctl start has). This will also restart all db already registered with Oracle restart - Manual register the second created database using "srvctl add database" will now work. - When now creating a third Oracle Home using a new OS user, the db registration will again fail. 解決方法如下,先利用grid用戶重啟has服務, [grid@dga01 ~]$ crsctl stop has CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'dga01' CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'dga01' CRS-2673: Attempting to stop 'ora.DATA.dg' on 'dga01' CRS-2673: Attempting to stop 'ora.OCR.dg' on 'dga01' CRS-2677: Stop of 'ora.DATA.dg' on 'dga01' succeeded CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'dga01' succeeded CRS-2677: Stop of 'ora.OCR.dg' on 'dga01' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'dga01' CRS-2677: Stop of 'ora.asm' on 'dga01' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'dga01' CRS-2677: Stop of 'ora.cssd' on 'dga01' succeeded CRS-2673: Attempting to stop 'ora.evmd' on 'dga01' CRS-2677: Stop of 'ora.evmd' on 'dga01' succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'dga01' has completed CRS-4133: Oracle High Availability Services has been stopped. [grid@dga01 ~]$ crsctl start has CRS-4123: Oracle High Availability Services has been started. [root@dga01 ~]# su - oracle 用 srvctl 重新注冊 database [oracle@dga01 ~]$ srvctl add database -d orcl -o /u01/app/oracle/product/11.2/db_1 執(zhí)行以上命令完成后 dbca正常
免責聲明:本站發(fā)布的內容(圖片、視頻和文字)以原創(chuàng)、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯(lián)系站長郵箱:is@yisu.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。