Solution : https://service.sap.com/sap/support/notes/819655 (SAP Service marketplace login required)
Summary :
This SAP Note addresses errors and guidelines for upgrading Oracle within SAP systems, highlighting prerequisites, solutions, and cautions required before the upgrade process. Specific issues like tablespace creation and charset configurations alongside systematic preparation steps, including the execution of SQL statements and setting optimizer modes, are detailed. For successful Oracle migration and upgrade, pertinent SAP Notes must be revisited for essential patches and configurations. This document is crucial for avoiding common pitfalls and ensuring data integrity during the upgrade process.
Key words :
note 820062------------------< updated d019926 01/sep/06 >------------------------------------------< updated d022030 08/feb/06 >------------------------------------------< updated d041703 12/dec/05 >------------------------------------------< updated d019926 24/oct/05 >----------------------------------------------- <d041703 12/sep/05 >-------------------------oracle versionfor general information, ---------------------< changed d041703 04/oct/07 >----------------------------------------< changed d041703 05/aug/05 >----------------------------------------< changed d022030 16/jul/04 >----------------------------------------< changed d030326 jan/10/03 >-------------------------------------------< c1399108, --------------------<changed d038006 sep/04/03 >------------------------------------------- < i800932 feb/24/03 >-----------------------importing scriptsto avoid long runtimes, ---------------------------------------------------------------------- viii/ chronological summary date topic short description ----------------------------------------------------------------------jul/28/09, --------------------<changed d022030 28/feb/06 >-------------------------------------------< d022030 04/nov/05 >----------------------sap system requirements, --------------------- <changed d041703 22/feb/10 >------------------------------------------- <d041703 11/oct/06 >-------------------------, / important general information ------------------------< d028299 28/jul/09 >---------------------- check sap note 1107700, ----------------------- <d041703 16/feb/07 >-------------------------upgrade preparation - sql statementbefore starting, --------------------< changed d025323 jun/28/02 >-----------------------------------------< d022030 jul/21/00 >-----------------------, upgrade phases failing / returning wrong results
Related Notes :
| 1293744 | Central Note: Upgrade Systems on SAP NetWeaver 7.0 EHP1 SR1 |
| 1293387 | Add. Info. on Upgrading to SAP SRM Server 7.0 SR1 ABAP |
| 1292071 | Add. info. on upgrading to SAP SCM 7.0 SR1 ABAP |
| 1292070 | Add. info. on upgrading to SAP CRM 7.0 SR1 ABAP |
| 1292069 | Add. info. on upgrading to SAP ERP 6.0 EHP4 SR1 ABAP |
| 1276895 | Add. info. about Upgrading to SAP Solution Manager 7.0 EHP1 |
| 1156970 | Add. info. on upgrading to SAP SCM 7.0 ABAP |
| 1156969 | Add. info. on upgrading to SAP CRM 7.0 ABAP |
| 1156968 | Add. info. on upgrading to EHP 4 for SAP ERP 6.0 ABAP |
| 1156844 | Add. Info. on Upgrading to SAP SRM Server 7.0 |
| 1146578 | Central Note: Upgrade to Systems on SAP NetWeaver 7.0 EHP1 |
| 1108510 | Add. Info.: Upgrade to SAP SRM Server 5.5 SR3 ABAP |
| 1107700 | 10.2.0.2: Execution of SQL statements in wrong schema |
| 1099841 | Add. info.: Upgrade to SAP NW 7.0 Support Rel. 3 ABAP |
| 1071404 | Add. info.: Upgrade to SAP CRM 2007 ABAP |
| 1039395 | Add. info.: Upgrade to SAP CRM 5.2 ABAP |
| 1010762 | Add. info. on upgrading to SAP SCM 5.1 ABAP |
| 975861 | Add. Info.: Upgrade to SAP SRM Server 6.0 ABAP |
| 961513 | Add. Info.: Upgrade to SAP SRM Server 5.5 SR2 ABAP |
| 961512 | Add. info. on upgrading to SAP SCM 5.0 SR2 ABAP |
| 961511 | Add. info.: Upgrade to SAP CRM 5.0 SR2 ABAP |
| 961410 | Add. info. on upgrading to SAP ECC 6.0 SR2 ABAP |
| 960783 | Add. info.: Upgrade to SAP NW 7.0 Support Rel. 2 ABAP |
| 947991 | Add. info.: Upgrade to SAP CRM 5.1 ABAP |
| 925240 | Add. Info. on upgrading to SAP SCM 5.0 SR1 ABAP |
| 913971 | Add. info. on upgrading to SAP ERP Central Component 6.0 SR1 |
| 913849 | Add. info.: Upgrade to SAP CRM 5.0 ABAP SR1 |
| 905029 | Add. info.: Upgrade to SAP NW 2004s Support Rel. 1 ABAP |
| 871096 | Oracle 10.2.0: Patches/patch collections for Oracle 10.2.0.2 |
| 836517 | Oracle database 10g: Preparation for SAP upgrade |
| 830578 | Oracle database 10g: Unix environment variable |
| 830576 | Parameter recommendations for Oracle 10g |
| 828432 | Enabling Microsoft Cluster Support in SAP MMC |
| 826488 | Enhancements to upgrade on SAP CRM 5.0 ABAP |
| 826092 | Add. info. on upgrading to SAP ERP Central Component 6.0 |
| 820062 | Oracle Database 10g: Patch sets/patches for 10.1.0 |
| 818322 | Add. info.: Upgrade to SAP NW 2004s ABAP |
| 720886 | Oracle Database 10g: Integration into the SAP environment |
| 669902 | Setting the national character set to UTF8 |