Solution : https://service.sap.com/sap/support/notes/539921 (SAP Service marketplace login required)
Summary :
This SAP Note addresses issues in Oracle Release 9.2.0, recommending patch sets 9.2.0.7 and 9.2.0.8 for resolution. Available through SAP Service Marketplace or on CD, these patches address initial problems indicated by required settings alterations. It is critical to revert certain parameter changes post-patch to align with standard configurations as outlined in Note 124361. Special attention should be given to the _OPTIM_PEEK_USER_BINDs parameter to avoid performance issues. Installation prerequisites include the latest unzip utilities for file extraction and adherence to specific installation guidelines to mitigate potential errors during the patch installation process.
Key words :
<cd1>/unix <cd1>/unix/<os> <cd1>/unix/<os>/920x_<os>_release, cpio <cd1>/unix/<os>/readme, html <cd1>/unix/<os>/patchnote, file 920x_<os920x_<os>_release, /\/bin\/id/\/usr\/bin\/id/ - save, 51020247 hp-ux 51020248 solaris 64-bit 51020249 hp tru64, binnt_i386 32-bit /oracle/oracle 32-bit/oracle 9, binlinux x86-64 /oracle/oracle 64-bit/oracle 9, ziplinux ia64 /oracle/oracle 64-bit/oracle 9, <cd1>/unix/<os>/stage
Related Notes :
| 1140644 | CPU patches January 2008 (Oracle Critical Update Program) |
| 1107601 | CPU Patches October 2007 (Oracle Critical Update Program) |
| 1076362 | CPU patches July 2007 (Oracle Critical Update Program) |
| 1054131 | Invalid DB objects after upgrade from 9.2.0.8 to 10.2.0.2 |
| 1050193 | CPU Patches April 2007 (Oracle Critical Update Program) |
| 992261 | Optimizer merge fix for Oracle 9.2.0.8 |
| 986578 | Oracle support in Itanium 2 systems (Montecito & following) |
| 980555 | ORA 600 [kdtdelrow-2] during insert with deadlock |
| 949339 | CPU patches April 2006 (Oracle Critical Update program) |
| 933947 | SAP ECC 5.0 Support Release Upgrade on RedFlag Linux |
| 933778 | SAP ERP 2004 SR1 Installation on RedFlag Linux |
| 930818 | ORA-3106 after installing 9.2.0.7 + Patch 3, 5, or 6 (WIN32) |
| 920781 | CPU Patches January 2006 (Oracle Critical Update Program) |
| 919185 | DBA_SEGMENTS.EXTENTS incorrect segm. in LMTS after TRUNCATE |
| 896209 | XI: Time selection changes in RWB changes after each request |
| 886783 | Installing Oracle 9207 Client Software on UNIX |
| 884657 | Known issues specific to the 9.2.0.7 Patch Set |
| 871455 | Poor performance when accessing DBA and V$ views |
| 828483 | ORA-00600: [KCOAPL_BLKCHK] |
| 816145 | Installation 4.6C SR2 on Linux x86_64 with Oracle |
| 799693 | ORA-600[4097] / [4000] after brspace dbcreate |
| 797629 | FAQ: Oracle histograms |
| 797084 | SUSE LINUX Enterprise Server 9: Installation notes |
| 785397 | Win32: 9.2.0.5 Support Package 4; post-installation steps |
| 771077 | Win32: Oracle 9.2.0.5 Patch 3 Post installation steps |
| 761745 | Oracle 9: ORA-01031 and ORA-06512 with DBMS_STATS |
| 760302 | Composite SAP note Oracle 9.2.0.3 and incorrect data |
| 760257 | Composite SAP note Oracle 9.2.0.5 and incorrect data |
| 741649 | ORA-600[KSLAWE:!PWQ] after installing Oracle 9.2.0.5 |
| 741423 | 'invalid mode' while executing root.sh for PSR9.2.0.X |
| 726572 | Queries Fail With ORA-1555 Although Undo_Retention Prameter |
| 722273 | Red Hat Enterprise Linux 3.x, 4.x: Installation and Upgrade |
| 721332 | 9204: MJC in temporary table causes ORA-1652 (PARALLEL hint) |
| 721331 | 9204: MERGE JOIN CARTESIAN IN TEMP TABLE- STAR and FACT Hint |
| 719928 | Opatch problems after installation of Oracle 9.2.0.x |
| 699521 | Oracle 9: Incorrect results with EXEC SQL |
| 662219 | Add. info. on upgrading to SAP Web AS 6.40 ORACLE |
| 656704 | Duplicate data records during AND EQUAL index access |
| 649353 | Oracle Security Alert #57 |
| 632336 | Long runtimes when compiling statistics on Oracle 9.2.0.x |
| 618868 | FAQ: Oracle performance |
| 582427 | Error due to inconsistent Oracle DDIC |
| 578683 | Installation of Newest Patch Set for Oracle 9.2.0 |
| 540021 | Add. information on migrating/updating to Oracle 9.2.0: UNIX |
| 355776 | Oracle9i: Patch set installation |