Skip to Content
avatar image
Former Member

New Installation of ERP 2004 with Oracle 10g


is there any documented procedure for UNIX/AIX to do a combinded System Copy / Oracle Database Upgrade to 10g for SAP ERP 2004?

Note 932722 - Upgrade to Oracle 10.2 during a database copy describes the process on Windows, but the note also has certain software attachments, that seem to be meant specifically for Windows.

Best Rgs and Thanks for your support in this.


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jul 26, 2010 at 09:30 AM

    Neither the DB upgrade guide to version Oracle 10.2 nor the system copy guide contains such information.

    Therefore you should do it in two stages. Perform the system copy first and the db upgrade as the second step (if you only wish to upgrade the newly copied system).

    Alternate approach would be to upgrade the source and the target database in the first step and then perform a system copy. In this case both systems run on the upgraded db version.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 26, 2010 at 01:20 PM


    if you do the copy with R3load, you can do the export with Oracle 9

    and do the installation with Oracle 10g using

    969519 - 6.20/6.40 Patch Collection Installation : Oracle/UNIX

    That would be the most simple solution and I strongly recommend using this one!

    If you want to use backup / restore, it is possible as well, but you

    need to do it without the DB Migration assistent, and do some tricks in addition,

    and be very carefull about the environment variables and in what session you are.

    I'd only recommend this to setup a sandbox an not a production system.

    The basic tricks to get this to work would be

    - the restore of a 9er backup to a 10er system

    - creation of a symlink /oracle/SID to make binary SRC-Controlfile work on target

    - a session with ORACLE_SID set to SRC and ORACLE_HOME set to TGT and a carefully adopted initSID.ora

    - a manual upgrade procedure according to the Oracle docs without the mig-assistent

    But again, I'd recommend to use R3load.


    Add comment
    10|10000 characters needed characters exceeded