- 11g ASM dbca报错 prcr-1006 crs-0259 prcr-1071
- 使用ASM方式创建单实例DB时,在运行DBCA时出现
- 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日志后,发现以下报错
- [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
- 状态 33 - Suspended, Req'd Info not Avail 平台 226 - Linux x86-64
- 创建时间 2011-3-18 平台版本 ORACLE LINUX 5
- 更新时间 2011-10-3 基本 Bug N/A
- 数据库版本 11.2.0.2 影响平台 Generic
- 产品源 Oracle
- 产品线 Oracle Database Products 系列 Oracle Database
- 区域 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
- 执行以上命令完成后 dbca正常
ASM bug 11886915
最新推荐文章于 2022-07-25 14:32:22 发布