千家信息网

11g ASM单实例 dbca报错 prcr-1006 crs-0259 prcr-1071

发表于:2025-01-20 作者:千家信息网编辑
千家信息网最后更新 2025年01月20日,11g ASM dbca报错 prcr-1006 crs-0259 prcr-1071使用ASM方式创建单实例DB时,在运行DBCA时出现PRCR-1006 : Failed to add reso
千家信息网最后更新 2025年01月20日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安全错误 数据库的锁怎样保障安全 文化旅游数据库建设 网络安全反恐手抄报 树形目录数据库保存 服务器开机需要输入硬盘密码 杭州洲际互联网科技有限公司 臻享网络技术有限公司 北京项目软件开发哪家可靠 滴滴的软件开发岗怎么样 网络安全进课堂主题班会 软件开发项目当建造师合适吗 如何关闭短信服务器 计算机网络技术专业语言 数据库x锁是几级 我的世界服务器掉线图 上海添龙互联网科技有限公司 荣昌区媒体网络技术服务特点 河北鼎点网络技术公司怎么样 广州积金互联网科技有限公司 虹口区综合软件开发服务介绍 服务器安全性要求 国标 新方向网络技术有限公司 软件开发市场风险评估 单机打卡机怎么清除数据库 苹果的软件开发有哪些 小学 网络安全活动方案 家具城进销存管理系统数据库 我的世界综合服务器手游 断言是软件开发中一种常见的 数据库设置约束男或女 杨浦区个性化软件开发诚信服务
0