11g ASM Single Instance dbca error prcr-1006 crs-0259 prcr-1071

11g ASM Single Instance dbca error prcr-1006 crs-0259 prcr-1071

11g ASM dbca error prcr-1006 crs-0259 prcr-1071
 
When creating a single instance DB Using ASM, it appears when running 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
 
After viewing the DBCA log, the following error is reported:
 
[Oracle @ dga01 orcl] $ tail-30000 trace. log | grep PRCR
 
[Thread-138] [14:15:51. 520 CST]
[HASIDBRegistrationStep.exe cuteImpl: 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 says this is a bug:
 
Bug 11886915: CRS-0259 WHEN REGISTERING THE DATABASE WITH ORACLE RESTART
 
Bug attributes
 
Type B-Defect has been fixed in the product version
Severity 2-Severe Loss of Service product version 11.2.0.2
Status 33-suincluded, Req 'd Info not Avail platform 226-Linux x86-64
Created on the platform 2011-3-18, oracle linux 5
Update Time 2011-10-3 basic Bug N/
Database Version 11.2.0.2 affects platform Generic
Product source Oracle
 
Product Line Oracle Database Products series Oracle Database
Regional Oracle Database product 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 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
Install the database software was created after the last restart of
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
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
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.

-------------------------------------- Split line --------------------------------------

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

Oracle 11g from entry to proficient in PDF + CD source code

Installing Oracle 11g R2 using RHEL6 ASM

Oracle 10g manual creation of the ASM Database

Oracle 10g R2 create ASM instance Step By Step

-------------------------------------- Split line --------------------------------------
 
 
The solution is as follows: Use the grid user to restart the has service,
 
[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.css d' on 'dga01'
CRS-2677: Stop of 'ora.css d' 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
Re-register database with srvctl
 
[Oracle @ dga01 ~] $ Srvctl add database-d orcl-o/u01/app/oracle/product/11.2/db_1
 
 
After the preceding commands are executed, dbca is normal.