Skip to Content

Oracle Upgrade from to


I am following below link to upgrade Oracle from 10205 to 11202.


I have downloaded below DVD

51040507 = ORACLE RDBMS LINUX x86_64 1 of 6

and extracted the ORX11264 and paste it in /oracle/stage/112_64. The Oracle 11g successfully installed in /oracle/IDS/11202 but the folder (sap/ora_upgrade/pre_upgrade/) is not created/missing under /oracle/IDS/11202. these scrips(pre_upgrade_status.sql, are also not showing under 11202 folder

these upgrade scripts (utlu112i.sql, utlu112i_sap.sql) is also mentioned in SAP NOTE 1431793 - Oracle 11.2.0: Upgrade Scripts

from where I can get these scripts for Linux SLES and which are the next steps?

Please guide me?


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 11, 2012 at 07:59 AM

    Please read carefully SAP Note 1431793.


    3. Installing Upgrade Scripts

    The upgrade scripts are delivered as SAP-specific generic Oracle database patch (patch 9584028).

    • For Unix/Linux platforms:
      The current version of the upgrade scripts is automatically installed if the current SAP Bundle Patch is installed. No further installation is required.

      To install a newer version of the upgrade scripts -if available-, download the patch from SAP service marketplace and install it:
      -> Database Patches
      -> Oracle
      -> Oracle <release>
      -> Database RDBMS
      -> MS Windows platform (32-bit or x64)
      -> p9584028_<release>

      As the patch is generic, it can be installed on all platforms.

      You can install the patch using mopatch with the following command:
      OS> $ORACLE_HOME/MOPatch/ -s \
    • For Windows platforms:
      To install the upgrade scripts patch 9584028 for your target release, download the patch file and run the following commands (see SAP note 1503709):

      OS> unzip p9584028_<release>
      OS> cd 9584028
      OS> %ORACLE_HOME%/OPatch/opatch apply

      For information how to install a patch with OPatch see note 839182.


    • SAP-specific database patches are installed in the Oracle Home in subdirectory '<ORACLE_HOME>/sap'.
    • The upgrade scripts are installed in the Oracle Home in directory '<ORACLE_HOME>/sap/ora_upgrade'.

    The directory '<ORACLE_HOME>/sap/ora_upgrade' is denoted by <ora_upgrade> within the context of this note.




    Add comment
    10|10000 characters needed characters exceeded