Shulou(Shulou.com)06/01 Report--

11g ASM dbca error prcr-1006 crs-0259 prcr-1071 when using ASM to create a single instance DB, 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 appears when running DBCA after viewing the DBCA log Found the following error [oracle@dga01 orcl] $tail-30000 trace.log | grep PRCR [oracle@dga01 orcl] [2013-03-19 14 1415 trace.log 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 says this is a bug as follows: Bug 11886915: CRS-0259 WHEN REGISTERING THE DATABASE WITH ORACLE RESTART Bug attribute type B-Defect fixed severity 2-Severe Loss of Service product version 11.2.0.2 status 33-Suspended in product version Req'd Info not Avail platform 226-Linux x86-64 creation time 2011-3-18 platform version ORACLE LINUX 5 update time 2011-10-3 basic Bug Nash A database version 11.2.0.2 impact platform Generic product source Oracle product line Oracle Database Products series Oracle Database area Oracle Database Product 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 * * 03x18 PROBLEM:-Oracle Restart Environment 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. The solution is as follows: first restart the has service using the grid user [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 re-registers database with srvctl [oracle@dga01 ~] $srvctl add database-d orcl-o / u01/app/oracle/product/11.2/db_1 after the execution of the above command, dbca is normal

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.