New Installation of ERP 2004 with Oracle 10g

[Former Member]

Hello,

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.

Thorsten

[volker_borowski2]

Hi,

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.

Volker

[Former Member]

Hello Volker,

thanks a lot for hinting me at 969519. At first glance this looks exactly what I was looking for.

We want to combine the Oracle Upgrade with a Unicode conversion, so we'll have to use R3load anyway.

Do you see any problems with combining the Unicode migration with the DB Upgrade?

Best Rgs

Thorsten

[volker_borowski2]

> Do you see any problems with combining the Unicode migration with the DB Upgrade?

No,

not in terms that are related to doing an export on Ora 9 and import on Ora 10.

Volker

[Former Member]

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.