Skip to Content

filesystem /oracle/DBSID/11203/sap not created during oracle upgrade 11.2.0.3

Hi

As i am doing oracle upgrade on a sandbox system from 10.2.0.4 to 11.2.0.3 but facing many issues in that -

According to master guide , last 2 final steps are

1> running preupgrade scripts by changing directory to /oracle/DBSID/11203/sap

2> running DBUA by going to directory Oracle_home_tgt/sap/ora_upgrade/pre_upgrade.

But this directory /oracle/DBSID/11203/sap does not exist at all.

We have created filesystems

/oracle/GSP/112_64 and /oracle/stage/11203

I have downloaded Bundle patch from note-1524205 "11ginstall-11203-039-complete.zip and

placed it filesystem /oracle/stage/11203/database and extracted it in /oracle/stage/11203/database/SAP

Now i am not able to understand where it went wrong.

I referred master guide step wise.

what shuld i do nxt to troubleshoot this.

According to master guide i downloaded Oracle files from SMP that are placed in directory /oracle/stage/11203

from https://service.sap.com/oracle-download -

ORACLE RDBMS 11.2.0.3 AIX 64bit 1 of 8

ORACLE RDBMS 11.2.0.3 AIX 64bit 2 of 8

ORACLE RDBMS 11.2.0.3 AIX 64bit 3 of 8

ORACLE RDBMS 11.2.0.3 AIX 64bit 4 of 8

ORACLE RDBMS 11.2.0.3 AIX 64bit 5 of 8

ORACLE RDBMS 11.2.0.3 AIX 64bit 6 of 8

ORACLE RDBMS 11.2.0.3 AIX 64bit 7 of 8

ORACLE RDBMS 11.2.0.3 AIX 64bit 8 of 8

This directory oracle/DBSID/11203/sap doesnot exist , is it becoz something wrong with MOpatch installations

or wrong files downloaded or is it becoz i have created file /oracle/GSP/112_64 which shuld be /oracle/GSP/11203

I am not able to understand where it went wrong.Please advice.

WR

Swati

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Mar 09, 2013 at 02:30 PM

    Also during checking prerequisites check , command

    - ./runInstaller -executeSysPrereqs

    was not successfull, it was showing some refrence data error

    So followed note number 1431796

    and executed

    - ./runInstaller ignoreSysPrereqs

    Add comment
    10|10000 characters needed characters exceeded

    • Hi

      Please find below the folders under /oracle/DB sid/112_64

      -rw-r----- 1 oragsp dba 50 Feb 03 2011 oraInst.loc drwxr-xr-x 2 oragsp dba 256 Mar 08 12:18 lost+found drwxr-xr-x 8 oragsp dba 256 Mar 08 15:25 ord drwxr-xr-x 4 oragsp dba 256 Mar 08 15:25 oracore drwxr-xr-x 5 oragsp dba 256 Mar 08 15:25 olap drwxr-xr-x 6 oragsp dba 256 Mar 08 15:25 odbc drwxr-xr-x 6 oragsp dba 256 Mar 08 15:25 nls drwxr-xr-x 6 oragsp dba 256 Mar 08 15:25 md drwxr-xr-x 2 oragsp dba 256 Mar 08 15:25 log drwxr-xr-x 4 oragsp dba 256 Mar 08 15:25 jdev drwxr-xr-x 8 oragsp dba 256 Mar 08 15:25 javavm drwxr-xr-x 8 oragsp dba 256 Mar 08 15:25 ide drwxr-xr-x 4 oragsp dba 256 Mar 08 15:25 has drwxr-xr-x 3 oragsp dba 256 Mar 08 15:25 emcli drwxr-xr-x 4 oragsp dba 256 Mar 08 15:25 dv drwxr-xr-x 3 oragsp dba 256 Mar 08 15:25 diagnostics drwxr-xr-x 3 oragsp dba 256 Mar 08 15:25 demo drwxr-xr-x 6 oragsp dba 256 Mar 08 15:25 cv drwxr-xr-x 3 oragsp dba 256 Mar 08 15:25 csmig drwxr-xr-x 6 oragsp dba 256 Mar 08 15:25 crs drwxr-xr-x 8 oragsp dba 256 Mar 08 15:25 assistants drwxr-xr-x 3 oragsp dba 256 Mar 08 15:25 wwg drwxr-xr-x 3 oragsp dba 256 Mar 08 15:25 usm drwxr-xr-x 4 oragsp dba 256 Mar 08 15:25 uix drwxr-xr-x 3 oragsp dba 256 Mar 08 15:25 sqlj drwxr-xr-x 3 oragsp dba 256 Mar 08 15:25 slax drwxr-xr-x 4 oragsp dba 256 Mar 08 15:25 scheduler drwxr-xr-x 4 oragsp dba 256 Mar 08 15:25 relnotes drwxr-xr-x 7 oragsp dba 256 Mar 08 15:25 precomp drwxr-xr-x 4 oragsp dba 256 Mar 08 15:25 owm drwxr-xr-x 6 oragsp dba 256 Mar 08 15:25 plsql drwxr-xr-x 2 oragsp dba 256 Mar 08 15:25 dbs drwxr-xr-x 2 oragsp dba 256 Mar 08 15:25 mesg drwxr-xr-x 2 oragsp dba 256 Mar 08 15:26 utl drwxr-xr-x 7 oragsp dba 256 Mar 08 15:26 xdk drwxr-xr-x 2 oragsp dba 256 Mar 08 15:26 instantclient drwxr-xr-x 20 oragsp dba 4096 Mar 08 15:26 oc4j drwxr-xr-x 2 oragsp dba 256 Mar 08 15:26 timingframework drwxr-xr-x 5 oragsp dba 4096 Mar 08 15:27 clone drwxr-xr-x 4 oragsp dba 256 Mar 08 15:27 j2ee drwxr-xr-x 8 oragsp dba 4096 Mar 08 15:27 apex drwxr-xr-x 13 oragsp dba 4096 Mar 08 15:27 sqldeveloper drwxr-xr-x 2 oragsp dba 4096 Mar 08 15:28 jlib drwxr-xr-x 2 oragsp dba 256 Mar 08 15:28 dc_ocm drwxr-xr-x 7 oragsp dba 256 Mar 08 15:26 xdk drwxr-xr-x 2 oragsp dba 256 Mar 08 15:26 instantclient drwxr-xr-x 20 oragsp dba 4096 Mar 08 15:26 oc4j drwxr-xr-x 2 oragsp dba 256 Mar 08 15:26 timingframework drwxr-xr-x 5 oragsp dba 4096 Mar 08 15:27 clone drwxr-xr-x 4 oragsp dba 256 Mar 08 15:27 j2ee drwxr-xr-x 8 oragsp dba 4096 Mar 08 15:27 apex drwxr-xr-x 13 oragsp dba 4096 Mar 08 15:27 sqldeveloper drwxr-xr-x 2 oragsp dba 4096 Mar 08 15:28 jlib drwxr-xr-x 2 oragsp dba 256 Mar 08 15:28 dc_ocm drwxr-xr-x 7 oragsp dba 256 Mar 08 15:28 jdk drwxr-xr-x 3 oragsp dba 256 Mar 08 15:28 ucp drwxr-xr-x 3 oragsp dba 256 Mar 08 15:28 jdbc drwxr-xr-x 7 oragsp dba 256 Mar 08 15:28 ccr drwxr-xr-x 26 oragsp dba 4096 Mar 08 15:28 owb drwxr-xr-x 6 oragsp dba 256 Mar 08 15:28 mgw drwxr-xr-x 7 oragsp dba 256 Mar 08 15:28 opmn drwxr-xr-x 6 oragsp dba 256 Mar 08 15:28 css drwxr-xr-x 2 oragsp dba 256 Mar 08 15:28 config drwxr-xr-x 3 oragsp dba 256 Mar 08 15:28 cdata drwxr-xr-x 3 oragsp dba 256 Mar 08 15:28 EMStage drwxr-xr-x 15 oragsp dba 4096 Mar 08 15:28 sysman drwxr-xr-x 12 oragsp dba 4096 Mar 08 15:28 ldap drwxr-xr-x 9 oragsp dba 256 Mar 08 15:28 srvm drwxr-xr-x 7 oragsp dba 256 Mar 08 15:28 racg drwxr-xr-x 10 oragsp dba 256 Mar 08 15:28 ctx drwxr-xr-x 7 oragsp dba 256 Mar 08 15:29 sqlplus drwxr-xr-x 4 oragsp dba 12288 Mar 08 15:32 lib drwxr-xr-x 8 oragsp dba 4096 Mar 08 15:32 oui drwxr-xr-x 5 oragsp dba 256 Mar 08 15:32 perl drwxr-xr-x 11 oragsp dba 4096 Mar 08 15:32 network drwxr-xr-x 5 oragsp dba 256 Mar 08 15:32 hs drwxr-xr-x 4 oragsp dba 4096 Mar 08 15:32 deinstall -rwxr-x--- 1 oragsp dba 392 Mar 08 15:32 root.sh drwxr-xr-x 13 oragsp dba 4096 Mar 08 15:32 rdbms drwxrwx--- 13 oragsp dba 4096 Mar 08 15:32 inventory drwxr-xr-x 2 root system 256 Mar 08 15:34 y drwxr-xr-x 8 oragsp dba 4096 Mar 08 15:36 install drwxr-xr-x 2 oragsp dba 16384 Mar 08 15:36 bin drwxr-xr-x 6 oragsp dba 256 Mar 08 16:22 cfgtoollogs drwxr-xr-x 2 oragsp dba 256 Mar 08 16:22 ccr_stage drwxr-xr-x 8 oragsp dba 4096 Mar 08 16:50 OPatch drwxr-xr-x 2 oragsp dba 256 Mar 08 16:56 MOPatch -rw-r--r-- 1 oragsp dba 518 Mar 08 17:31 network.admin drwxr-xr-x 2 oragsp dba 256 Mar 09 17:21 patches
  • avatar image
    Former Member
    Mar 09, 2013 at 04:34 PM

    Please read Note 1431793 - Oracle 11.2.0: Upgrade Scripts

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

    Regards,

    Roman

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 09, 2013 at 09:51 PM

    Hello

    I have downloaded Bundle patch from note-1524205 "11ginstall-11203-039-complete.zip and

    placed it filesystem /oracle/stage/11203/database and extracted it in /oracle/stage/11203/database/SAP

    These are not Bundle Patches. They are installation scripts for Oracle database on an SAP environment.

    Did you start the Oracle installation with the file runInstaller or with RUNINSTALLER ?

    Cheers

    RB

    Add comment
    10|10000 characters needed characters exceeded