当前位置:  数据库>oracle

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

    来源: 互联网  发布时间:2017-06-06

    本文导语: 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日志后,发...

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.

--------------------------------------分割线 --------------------------------------

在CentOS 6.4下安装Oracle 11gR2(x64)

Oracle 11gR2 在VMWare虚拟机中安装步骤

Debian 下 安装 Oracle 11g XE R2

Oracle 11g从入门到精通 PDF+光盘源代码

RHEL6 ASM方式安装Oracle 11g R2

Oracle 10g 手工创建ASM数据库

Oracle 10g R2创建ASM实例Step By Step

--------------------------------------分割线 --------------------------------------
 
 
解决方法如下,先利用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正常


    
 
 
 
本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术,将尽最大努力为读者提供更好的信息聚合和浏览方式。
本站(WWW.)站内文章除注明原创外,均为转载、整理或搜集自网络。欢迎任何形式的转载,转载请注明出处。












  • 相关文章推荐
  • oracle 11g最新版官方下载地址
  • Oracle内存数据库11g和高速缓存11g上市
  • Oracle 10g和Oracle 11g网格技术介绍
  • Linux版本的Oracle 11g将首先被发布
  • 关于Linux下oracle是10g?还是11g?
  • Oracle 11g 相关工具netca,dbca乱码之解决
  • Oracle 11g解锁scott
  • fedora10安装oracle11g提示物理内存不足怎么办?
  • 有人在fedora 10下安装 oracle database 11g,没有呀?提供个安装步骤
  • Tomcat Extensions for JDeveloper 11g
  • Oracle 11g R2 数据库将在9月发布
  • 在ubuntu10.04上安装oracle11g失败
  • 关于Oracle 11g 闪回的一个小问题
  • Oracle EBS R12 支持 Oracle Database 11g
  • Oracle11g备份和恢复功能的提高
  • Redhat 6 安装 oracle 11g2的问题
  • centos5.4安装oracle11g的问题
  • Oracle 11G密码180天过期后的修改方法
  • 11g Oracle导出表不导出数据默认为空表的解决方法
  • Oracle针对Eclipse 11g发布开发包
  • Oracle 11g 数据库 Alert日志的新发展


  • 站内导航:


    特别声明:169IT网站部分信息来自互联网,如果侵犯您的权利,请及时告知,本站将立即删除!

    ©2012-2021,