Skip to Content

Oracle Upgrade from 10.2.0.5 to 11.2.0.2

Dear,

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

upgrade-to-oracle-database-11g-release-2-11-2-unix-for-sap/

I have downloaded below DVD

51040507 = ORACLE RDBMS 11.2.0.2 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, dbua.sap.sh) 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?

Regards,


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:
      https://service.sap.com/swdc
      -> Database Patches
      -> Oracle
      -> Oracle <release>
      -> Database RDBMS
      -> MS Windows platform (32-bit or x64)
      -> p9584028_<release>_Generic.zip

      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/mopatch.sh -s \
          p9584028_<release>_Generic.zip
    • 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>_Generic.zip
      OS> cd 9584028
      OS> %ORACLE_HOME%/OPatch/opatch apply

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


    Note:

    • 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.

    "

    Regards

    Roman

    Add comment
    10|10000 characters needed characters exceeded