Solution : https://service.sap.com/sap/support/notes/1431793 (SAP Service marketplace login required)
Summary :
This SAP note details the process and resources for upgrading Oracle databases to version 11.2.0.X using the Database Upgrade Assistant (DBUA), incorporating additional scripts from the Oracle patch 9584028. It includes step-by-step upgrade instructions, spanning software installation to post-upgrade activities on both Unix/Linux and Windows platforms. Further guidance is provided through relevant SAP guides available on the SAP Support Portal. Special attention is given to executing SAP Bundle Patch (SBP) instructions post-upgrade to ensure system stability and performance. Recent updates include removal of specific patch files from the support portal listing and improvements to pre-upgrade scripts.
Key words :
power shell window run pre-upgrade scripts cd $oracle_home/sap/ora_upgrade/pre_upgrade cd %oracle_home%\sap\ora_upgrade\pre_upgrade run dbua wrapper script cd $oracle_home/sap/ora_upgrade/post_upgrade open, cd %oracle_home%\sap\ora_upgrade\post_upgrade run post-upgrade scripts cd $oracle_home/sap/ora_upgrade/post_upgrade cd %oracle_home%\sap\ora_upgrade\post_upgrade running sap-specific pre-upgrade scripts, contents overviewprerequisitesinstalling sap-specific upgrade scriptsusing sap-specific upgrade scriptsrunning sap-specific pre-upgrade scriptsperforming database upgrade, set environment variable displayos> setenv display <display> set environment variable oracle_home_src, os> cd $oracle_home_tgt/sap/ora_upgrade/post_upgrade checking upgrade options, upgrade scenario fromoracle databasesource release tooracle databasetarget release major release upgrade 10, os> cd <oracle_home>/sap/ora_upgrade/pre_upgrade check, os> cd <oracle_home>/sap/ora_upgrade/post_upgradeos> /bin/sh check_dbua_logs, unset obsolete environment variablesos> unsetenv oracle_home_srcos> unsetenv oracle_home_tgt starting, yos> setenv oracle_home_src /oracle/<dbsid>/112_64 set environment variable oracle_home_tgt
Related Notes :
| 839182 | Installing patches using OPatch |
| 1524205 | Oracle 11.2.0: Database Software Installation |
| 1622837 | Secure connection of AS ABAP to Oracle via SSFS |
| 1431798 | Oracle 11.2.0: Database Parameter Settings |
| 1431797 | Oracle 11.2.0: Troubleshooting the Database Upgrade |
| 1669684 | SAP on Solaris 11 |
| 1431800 | Oracle 11.2.0: Central Technical Note |
| 974781 | Oracle internal maintenance jobs |