Solution : https://service.sap.com/sap/support/notes/540021 (SAP Service marketplace login required)
Summary :
This SAP Note addresses corrections and additions to the guide for upgrading to Oracle Version 9.2.0 on UNIX systems, detailed in document version 1.10 as of December 18, 2002. It provides essential updates for the upgrade process from Oracle 8i to 9i Rel.2, highlighting the importance of using the latest Oracle Universal Installer and patch sets. The upgrade procedure encompasses pre-upgrade requirements, step-by-step during-upgrade actions, and post-upgrade checks to ensure the database system's optimal functioning. Key contents include required operating system specifics, installation of critical patches, and database dictionary consistency verifications for a successful system upgrade.
Key words :
<ora_home>/ocommon/nls_723/admin/data <ora_home>/ocommon/nls_733/admin/data <ora_home>/ocommon/nls_805/admin/data <ora_home>/ocommon/nls_806/admin/data, <old_ora_home>/ocommon/nls_723/admin/data <old_ora_home>/ocommon/nls_733/admin/data <old_ora_home>/ocommon/nls_805/admin/data <old_ora_home>/ocommon/nls_806/admin/datato, oracle home directory /oracle/<dbsid>/817_32or /oracle/<dbsid>/817_64is termed <old_ora_home>, alter tablespace system add datafile size 150m autoextend, oracle 64-bit ---> oracle <patch set version> ---> <hardware platform> ---> patch set, linux ld_library_path hp-ux shlib_path ii additions, /oracle/<dbsid>/920_32or /oracle/<dbsid>/920_64 <nls_lang>, operating system requirements platform-specific requirements, database patches ---> oracle ---> oracle 32-bit, nls_timestamp_tz_format = dd-mon-rr hh
Related Notes :
| 768537 | ora-00600 [koxsihread1] during after upgrade to Oracle 9 |
| 706132 | Composite SAP Note: Problems with Oracle 9i |
| 662219 | Add. info. on upgrading to SAP Web AS 6.40 ORACLE |
| 643409 | Using the EXT kernel in the upgrade |
| 637683 | Add info about upgrade to SAP R/3 Enterprise Core 4.70 Ext 2 |
| 603852 | Additional information about upgrading to SAP SCM 4.0 |
| 601965 | Inventory Corruption by OPatch |
| 599110 | Data corruption using JDBC and NCLOBs |
| 599092 | NullPointerException in PreparedStatement.clearParameters() |
| 594513 | Oracle 9.2.0: Result not sorted in spite of ORDER BY |
| 592657 | ORA-12701/ORA-12705/ORA-12709 |
| 587896 | Add. info on upgrade to SAP R/3 Enterprise Core 4.70 SR1 |
| 582427 | Error due to inconsistent Oracle DDIC |
| 581049 | Oracle generates a large number of useless trace files |
| 580318 | Database crash: ORA-600[1100] and ORA-600[kcbget_37] |
| 579540 | ORA-00381, unable to start the Oracle 9.x database |
| 573784 | Work procs. terminate when started on HP/UX & Oracle 9.2.0 |
| 567301 | Upgrade from 8.1.7 to 9.2 fails with ORA-3114 and ORA-7445 |
| 539970 | Problems when upgrading to Oracle 9.2.X |
| 539922 | Installing the ORACLE client software 9.2.X for UNIX |
| 539921 | Current patch set for Oracle 9.2.0 |
| 521230 | FAQ: Client software 9i or lower on UNIX |
| 513536 | Add. information on upgrade to SAP R/3 Enterprise Core 4.70 |
| 406140 | Installation of ORACLE Client Software 8.1.X for UNIX |
| 395521 | runInstaller problems and solutions |
| 356370 | Kernel parameters for HP Tru64 UNIX 5.x |
| 355779 | SAP work process hangs |
| 355776 | Oracle9i: Patch set installation |
| 355774 | Incorrect results from the database server |
| 355773 | Oracle Technology Network (OTN) |
| 350251 | Creating a New or 2nd Oracle SID with runInstaller |
| 306408 | Oracle 9.2.0: Using OPatch to install patches |
| 180605 | Oracle database parameter settings for BW |
| 180430 | Installing the ORACLE client software for UNIX |
| 124361 | Oracle parameterization (R/3 >= 4.x, Oracle 8.x/9.x) |
| 12741 | Current versions of BR*Tools and SAPDBA |