SAP Netweaver Business Intelligence BI / BW

Symptom

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
This note is released as a Hot News.
You must check the note regularly for updates. Otherwise, you will not be aware of important changes regarding prerequisites, consequences and solutions in the latest release. If this note is updated, no new Hot News is issued.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
When table redefinitions are done via DBMS_REDEFINITION package on one node and queries / activity is ongoing on the remote nodes, then the redefined queries will show different results on all nodes.
This issues occurs only in a RAC environment in Oracle 10.2.0.2 or 10.2.0.4 with more then 1 node.

Other terms

Wrong values, DBMS_REDEFINITION, Online reoganization, RAC
Reason and Prerequisites

When the table redefinition occur on e.g. node1, then the cursors of node2 are not totally invalidated. Hence they still use the old objects.
This is caused by the Oracle bug 7573151, which is fixed in Oracle Release 10.2.0.5.

Solution

Install the relevant patch for your platform.
You can find this on SAP Service Marketplace in the software center under: http://service.sap.com/swcenter-3pmain in the following directories:
Oracle 10.2.0.4
AIX5L (64-bit)
/Oracle/Oracle 10.2.0.4/Database RDBMS/AIX5L (64-bit)/
p7573151_10204_AIX5L.zip
HP-UX PA-RISC (64-bit)
/Oracle/Oracle 10.2.0.4/Database RDBMS/HP-UX PA-RISC (64-bit)/
p7573151_10204_HPUX-64.zip
HP-UX Itanium (64-bit)
/Oracle/Oracle 10.2.0.4/Database RDBMS/HP-UX Itanium (64-bit)/
p7573151_10204_HPUX-IA64.zip
HP Tru64 (64-bit)
/Oracle/Oracle 10.2.0.4/Database RDBMS/HP Tru64 (64-bit)/
p7573151_10204_Tru64.zip
Linux x86 (32-bit)
/Oracle/Oracle 10.2.0.4/Database RDBMS/Linux x86 (32-bit)/
p7573151_10204_Linux-x86.zip
Linux Itanium (64-bit)
/Oracle/Oracle 10.2.0.4/Database RDBMS/Linux Itanium (64-bit)7
p7573151_10204_Linux-IA64.zip
Linux x86-64 (64-bit)
/Oracle/Oracle 10.2.0.4/Database RDBMS/Linux x86-64 (64-bit)/
p7573151_10204_Linux-x86-64.zip
Linux on Power (64-bit)
/Oracle/Oracle 10.2.0.4/Database RDBMS/Linux on Power (64-bit)/
p7573151_10204_IBMPower.zip
Solaris SPARC (64-bit)
/Oracle/Oracle 10.2.0.4/Database RDBMS/Solaris SPARC (64-bit)/
p7573151_10204_Solaris-64.zip
Solaris x86-64 (64-bit)
/Oracle/Oracle 10.2.0.4/Database RDBMS/Solaris x86-64 (64-bit)/
p7573151_10204_Solaris86-64.zip
MS Windows (32-bit)
MS Windows Itanium (64-bit)
MS Windows x86-64 (64-bit)
Patch 7573151 is contained in Windows patch collection 14 for Oracle 10.2.0.4 and above.
For information about availability, see Note 1137346.

Please note:The patches for bug 7573151 are released on the SAP Service Marketplace since 12-January-2009!

Oracle 10.2.0.2
AIX 5L 64-Bit
/Oracle/Oracle 64-Bit/Oracle 10.2.0. 64-Bit/Oracle 10.2.0.2/
AIX_5L_64/p7573151_10202_AIX64-5L.zip
Linux x86-64
/Oracle/Oracle 64-Bit/Oracle 10.2.0. 64-Bit/Oracle 10.2.0.2/
Linux_x86_64/p7573151_10202_Linux-x86-64.zip
HP-UX PA-RISC 64-Bit
/Oracle/Oracle 64-Bit/Oracle 10.2.0. 64-Bit/Oracle 10.2.0.2/
HP-UX_64/p7573151_10202_HP64.zip
HP UX Itanium 64-Bit
/Oracle/Oracle 64-Bit/Oracle 10.2.0. 64-Bit/Oracle 10.2.0.2/
HP_IA_64/p7573151_10202_HPUX-IA64.zip
SUN Solaris 64-Bit
/Oracle/Oracle 64-Bit/Oracle 10.2.0. 64-Bit/Oracle 10.2.0.2/
Solaris_SPARC_64/p7573151_10202_SOLARIS64.zip