July 28 2010

CRS-2640: Required resource ‘ora.ARC2_DG.dg’ is missing.

Tagged Under : , , ,

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.

June 13 2010

Changing Interconnect/Public Interface, IP or Subnet in Oracle Clusterware

Tagged Under : , , , , , , , ,

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

June 13 2010

Failed to upgrade Oracle Cluster Registry configuration – fail on root.sh clusterware

Tagged Under : , , , , , , , , ,

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]…