PRCR-1079 : Failed to start resource ora.mydb.db
CRS-2640: Required resource ‘ora.ARC2_DG.dg’ is missing.
How to remove the ASM resource from CRS start/stop dependency?
Applies to:
Oracle 11gR2 RAC
Scenario:
(2 node RAC with 11gR2 in RHEL 5.3 x86_64)
I was having 2 ASM diskgroup (ARC1_DG & ARC2_DG) assigned for archive logs and standby Dataguard when first RAC .
Due to some reason that management want to merge these 2 diskgroups into one (ARC1_DG).
I confimed that ARC2_DG was not contain any file and diskgroup ARC2_DG dropped successfully.
Recently, I have successfully changed the NIC interface name for public and private NIC in 2 nodes Oracle clusterware 11.1.0.7. The purpose of this change is to change single NIC interface to teaming NIC interfaces in UNIX level for HA purpose.
I would like to share the steps which applies to Oracle Clusterware 10.1 to 11.2 in any UNIX/Linux platform.
Before:
(node1:root) /usr/crs/oracle/product/11.1/crs/bin # ./oifcfg getif
lan2 23.252.18.0 global public
lan4 10.250.48.0 global cluster_interconnect
(node2:root) /usr/crs/oracle/product/11.1/crs/bin # ./oifcfg getif
lan2 23.252.18.0 global public
lan4 10.250.48.0 global cluster_interconnect
(node1:root) /usr/oracle $ srvctl config nodeapps -n node1 -a
VIP exists.: /racvip1/23.252.18.91/255.255.255.0/lan2
(node2:root) /usr/oracle $ srvctl config nodeapps -n node2 -a
VIP exists.: /racvip2/23.252.18.92/255.255.255.0/lan2
Do you face the similar issue on root.sh after Clusterware 11.1.0.6 installation?
If you are facing similar symptoms, then this article might help you 🙂
Applies to:
Clusterware Version 11.1.0.6 in HP-UX 11.31 (ia64)
Symptoms:
(1) root.sh output
/usr/crs/oracle/product/11.1/crs # ./root.sh
WARNING: directory ‘/usr/crs/oracle/product/11.1’ is not owned by root
WARNING: directory ‘/usr/crs/oracle/product’ is not owned by root
WARNING: directory ‘/usr/crs/oracle’ is not owned by root
WARNING: directory ‘/usr/crs’ is not owned by root
WARNING: directory ‘/usr’ is not owned by root
Checking to see if Oracle CRS stack is already configured
Setting the permissions on OCR backup directory
Setting up Network socket directories
Failed to upgrade Oracle Cluster Registry configuration
(2) $CRS_HOME/log/$HOST/client/ocrconfig_15289.log
From the log files
====
2010-05-25 02:29:10.137: [ OCRCONF][1]csetskgfrblock0: SCLS error [1] in spawning process. slos [1234]
2010-05-25 02:29:10.137: [ OCRCONF][1]csetskgfrblock0: slos msgbuf [Error 0]
2010-05-25 02:29:10.137: [ OCRCONF][1]csetskgfrblock0: slos errbuf [0]
2010-05-25 02:29:10.137: [ OCRCONF][1]csetskgfrblock0: slos other info is [no exe permission, file /usr/crs/oracle/product/11.1/crs/bin/clsfmt]
2010-05-25 02:29:10.137: [ OCRCONF][1]Failure in setting block0 [-1]
2010-05-25 02:29:10.137: [ OCRCONF][1]OCR block 0 is not set !
2010-05-25 02:29:10.137: [ OCRCONF][1]Exiting [status=failed]…