Few months back, we were doing OS migration for database servers.
From: HP-UX 11.11 (PA RISC), Oracle 10gR2 (10.2.0.4) RAC
To: HP-UX 11.23 (ia64), Oracle 10gR2 (10.2.0.4) RAC with PSU2
The data migration approach was EXPDB and IMPDP with data pump and we encounter following bug (described in metalink notes).
Bug 5598333: EXPDP/IMPDP corrupts the data for a LONG column
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]…