June 16 2010

EXPDP / IMPDP corrupts the data for a LONG column

Tagged Under : , , , , ,

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

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