SAP Netweaver Business Intelligence BI / BW

Symptom

Refer to the general information about the Critical Patch Updates (CPU) in the CPU composite note 850306.
Oracle 10.2.0.4
The following patch molecules are installed with CPUJul2009:
7155248 – DB-10.2.0.4-MOLECULE-001-CPUJUL2008
7155249 – DB-10.2.0.4-MOLECULE-002-CPUJUL2008
7155250 – DB-10.2.0.4-MOLECULE-003-CPUJUL2008
7155251 – DB-10.2.0.4-MOLECULE-004-CPUJUL2008
7155252 – DB-10.2.0.4-MOLECULE-005-CPUJUL2008
7155253 – DB-10.2.0.4-MOLECULE-006-CPUJUL2008
7155254 – DB-10.2.0.4-MOLECULE-007-CPUJUL2008
7197583 – DB-10.2.0.4-MOLECULE-008-CPUJUL2008
7375611 – DB-10.2.0.4-MOLECULE-009-CPUOCT2008
7375613 – DB-10.2.0.4-MOLECULE-0010-CPUOCT2008
7375617 – DB-10.2.0.4-MOLECULE-0011-CPUOCT2008
7609057 – DB-10.2.0.4-MOLECULE-0012-CPUJAN2009
7609058 – DB-10.2.0.4-MOLECULE-0013-CPUJAN2009
8309587 – DB-10.2.0.4-MOLECULE-014-CPUAPR2009
8309592 – DB-10.2.0.4-MOLECULE-015-CPUAPR2009
8309623 – DB-10.2.0.4-MOLECULE-016-CPUAPR2009
8309632 – DB-10.2.0.4-MOLECULE-017-CPUAPR2009
8309642 – DB-10.2.0.4-MOLECULE-018-CPUAPR2009
8309639 – DB-10.2.0.4-MOLECULE-019-CPUAPR2009
8309637 – DB-10.2.0.4-MOLECULE-020-CPUAPR2009
8568395 – DB-10.2.0.4-MOLECULE-021-CPUJUL2009
8568397 – DB-10.2.0.4-MOLECULE-022-CPUJUL2009
8568398 – DB-10.2.0.4-MOLECULE-023-CPUJUL2009
8568402 – DB-10.2.0.4-MOLECULE-024-CPUJUL2009
8568404 – DB-10.2.0.4-MOLECULE-025-CPUJUL2009
8568405 – DB-10.2.0.4-MOLECULE-026-CPUJUL2009
The current CPUJul2009 contains the following “non-security” patches:
6392076 – CREATE OR REPLACE JAVA CLASS USING BLOB” IS NOT SKIPPED ON
LOGICAL STANDBY
6870937 – ORA-600 [729] “UGA SPACE LEAK” ERROR RESULTS IN SESSION OUT

In the Oracle inventory, these patches are listed as normal single patches.
Oracle 9.2.0.8.
The CPUJul2009 conflicts with the previously recommended patch 5530583 (see SAPNet Note 1043381). Patch 5530583 corrects a critical ASSM performance problem, and it is strongly recommended for customers who use the ASSM tablespaces.
If you do not use ASSM tablespaces and have not applied patch 5530583, you can apply CPUJul2009.
Merging these two patches (CPUJul2009 and 5530583) is not possible for technical reasons, and it will not be possible for future CPU patches either.

When you install CPUJul2009, the system reports a conflict with the following patches:
5369855 – HANGING EXECUTION WITH STAR_STRANSFORMATION_ENABLED=TRUE
IN 10.2.0.2
5057695 – SHUTDOWN IMMEDIATE SLOW TO CLOSE DOWN DATABASE WITH
INACTIVE JDBC THIN SESSIONS
Both patches are included in CPUJul2009 and, therefore, you can roll them back when you apply CPUJul2009.

Other terms

CPU, Oracle, security patches, CPUJul2009, n-apply
Reason and Prerequisites

For more information, see Note 850306.
Solution

The patches are available on SAP Service Marketplace in the Software Center (http://service.sap.com/swcenter-3pmain) in the following directories:
Oracle 10.2.0.4(patch 8534387)
AIX5L (64-bit)
/Oracle/Oracle 10.2.0.4/Database RDBMS/AIX5L (64-bit)/
CPUJul2009_p8534387_10204_AIX5L.zip
HP-UX PA-RISC (64-bit)
/Oracle/Oracle 10.2.0.4/Database RDBMS/HP-UX PA-RISC (64-bit)/
CPUJul2009_p8534387_10204_HPUX-64.zip
HP-UX Itanium (64-bit)
/Oracle/Oracle 10.2.0.4/Database RDBMS/HP-UX Itanium (64-bit)/
CPUJul2009_p8534387_10204_HPUX-IA64.zip
Linux x86 (32-bit)
/Oracle/Oracle 10.2.0.4/Database RDBMS/Linux x86 (32-bit)/
CPUJul2009_p8534387_10204_Linux-x86.zip
Linux Itanium (64-bit)
/Oracle/Oracle 10.2.0.4/Database RDBMS/Linux Itanium (64-bit)/
CPUJul2009_p8534387_10204_Linux-IA64.zip
Linux x86-64 (64-bit)
/Oracle/Oracle 10.2.0.4/Database RDBMS/Linux x86-64 (64-bit)/
CPUJul2009_p8534387_10204_Linux-x86-64.zip
Linux on Power (64-bit)
/Oracle/Oracle 10.2.0.4/Database RDBMS/Linux on Power (64-bit)/
CPUJul2009_p8534387_10204_IBMPower.zip
Solaris SPARC (64-bit)
/Oracle/Oracle 10.2.0.4/Database RDBMS/Solaris SPARC (64-bit)/
CPUJul2009_p8534387_10204_Solaris-64.zip
Solaris x86-64 (64-bit)
/Oracle/Oracle 10.2.0.4/Database RDBMS/Solaris x86-64 (64-bit)/
CPUJul2009_p8534387_10204_Solaris86-64.zip
MS Windows (32-bit)
MS Windows Itanium (64-bit)
MS Windows x86-64 (64-bit)
CPUJul2009 is contained in Windows patch collection 22 for Oracle 10.2.0.4.
For availability, see Note 1137346.

Take account of the following changes to the installation of CPU patches due to n-apply mode. Detailed information and the documentation is available in the README, which is contained in the CPU patch:
1. OPatch command:
opatch napply -skip_subset -skip_duplicate

2. Loading the modified *.sql files:
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql cpu apply
SQL> QUIT
Check the log files that were created by catbundle.sql. These log files are available in the following directory:
$ORACLE_HOME/cfgtoollogs/catbundle/
catbundle_CPU__APPLY_.log
catbundle_CPU__GENERATE_.log

Oracle 9.2.0.8(patch 8534403)
AIX 5L with Oracle 64 bit
/Oracle/Oracle 64-bit/Oracle 9.2.0. 64-bit/Oracle 9.2.0.8. 64-bit/
AIX_5L_64/CPUJul2009_92080_AIX64-5L.zip
HP-UX PA-RISC 64-bit
/Oracle/Oracle 64-bit/Oracle 9.2.0. 64-bit/Oracle 9.2.0.8 64-bit/
HP_UX_64/CPUJul2009_92080_HP64.zip
HP UX Itanium 64-bit
/Oracle/Oracle 64-bit/Oracle 9.2.0. 64-bit/Oracle 9.2.0.8 64-bit/
HP_IA_64/CPUJul2009_92080_HPUX-IA64.zip
HP TRU64
/Oracle/Oracle 64-bit/Oracle 9.2.0. 64-bit/Oracle 9.2.0.8 64-bit/
HP_TRU64/CPUJul2009_92080_TRU64.zip
LINUX 32-bit
/Oracle/Oracle 32-bit/Oracle 9.2.0. 32-bit/Oracle 9.2.0.8. 32-bit/
Linux/CPUJul2009_92080_LINUX.zip
LINUX x86-64
/Oracle/Oracle 64-bit/Oracle 9.2.0. 64-bit/Oracle 9.2.0.8. 64-bit/
Linux_x86_64/CPUJul2009_92080_Linux-x86-64.zip
LINUX Itanium 64-bit
/Oracle/Oracle 64-bit/Oracle 9.2.0. 64-bit/Oracle 9.2.0.8. 64-bit/
Linux_IA_64/CPUJul2009_92080_Linux-IA64.zip
SUN Solaris 64-bit
/Oracle/Oracle 64-bit/Oracle 9.2.0. 64-bit/Oracle 9.2.0.8 64-bit/
SOLARIS_64/CPUJul2009_92080_SOLARIS64.zip
Windows 32-bit/Windows 64-bit (Windows 2003)
CPUJul2009 is available as of patch 26 for Oracle 9.2.0.8.
For availability, see Note 539921.