11g ASM单实例 dbca报错 prcr-1006 crs-0259 prcr-1071
发表于:2025-11-08 作者:千家信息网编辑
千家信息网最后更新 2025年11月08日,11g ASM dbca报错 prcr-1006 crs-0259 prcr-1071使用ASM方式创建单实例DB时,在运行DBCA时出现PRCR-1006 : Failed to add reso
千家信息网最后更新 2025年11月08日11g ASM单实例 dbca报错 prcr-1006 crs-0259 prcr-1071
11g ASM dbca报错 prcr-1006 crs-0259 prcr-1071使用ASM方式创建单实例DB时,在运行DBCA时出现PRCR-1006 : Failed to add resource ora.orcl.db for orclPRCR-1071 : Failed to register or update resource ora.orcl.dbPRCR-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 orclPRCR-1071 : Failed to register or update resource ora.orcl.dbPRCR-1001 : Resource ora.orcl.db does not existoracle说这是一个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 EditionHdr: 11886915 11.2.0.2 PCW 11.2.0.2 CRS PRODID-5 PORTID-226Abstract: 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 nullPRCR-1071 : Failed to register or update resource ora.elin.dbCRS-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 10337212Bug 10118593Bug 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 hasCRS-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' succeededCRS-2677: Stop of 'ora.LISTENER.lsnr' on 'dga01' succeededCRS-2677: Stop of 'ora.OCR.dg' on 'dga01' succeededCRS-2673: Attempting to stop 'ora.asm' on 'dga01'CRS-2677: Stop of 'ora.asm' on 'dga01' succeededCRS-2673: Attempting to stop 'ora.cssd' on 'dga01'CRS-2677: Stop of 'ora.cssd' on 'dga01' succeededCRS-2673: Attempting to stop 'ora.evmd' on 'dga01'CRS-2677: Stop of 'ora.evmd' on 'dga01' succeededCRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'dga01' has completedCRS-4133: Oracle High Availability Services has been stopped.[grid@dga01 ~]$ crsctl start hasCRS-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正常
产品
版本
平台
时间
实例
严重性
产品线
区域
命令
属性
数据
数据库
方式
方法
日志
状态
用户
类型
这是
时出
数据库的安全要保护哪些东西
数据库安全各自的含义是什么
生产安全数据库录入
数据库的安全性及管理
数据库安全策略包含哪些
海淀数据库安全审计系统
建立农村房屋安全信息数据库
易用的数据库客户端支持安全管理
连接数据库失败ssl安全错误
数据库的锁怎样保障安全
数据库表分区是否过期
两个es数据库之间同步
校园网络安全演讲讨论
数据库性能评测真的很重要么
国家网络安全管理平台官网
贵阳拼接服务器
锦州互助盘软件开发设计
浏览器和服务器如何通信
数据库原理及技术钱雪忠答案
网络安全相关专业课程信息
ansa中的数据库管理
数据库 语法快速
缺网络技术人员怎么办
电站网络安全知识培训
谷歌地球服务器怎么更新
服务器有专门管理网口吗
ftp连接sql 数据库
中国象棋软件的数据库
天津正规软件开发过程检测中心
网络技术答辩项目
西安易信软件开发有限公司
上海服务器机柜哪家优惠
吉林潮流软件开发价格检测中心
济南销售软件开发公司
浅谈办公网络安全 论文
服务器虚拟化优缺点
服务器双机热备连接
plesk服务器管理面板
服务器pe现实屏幕一半黑
连接数据库用什么软件