System copy from SAP R/3 47x110 with Oracle 10.2 to Oracle 11.2

[Botte]

Hello,

I want to do a system copy from SAP R/3 4.7 Enterprise 47x110 with Oracle 10.2 to a new machine with same SAP version but with oracle 11.2. (After this I will upgrade to ERP 6.0)

I will do this with export/import but I don't find any documentation (manuals or notes).

I only find this:

Note 1499877 - Oracle 11.2 for R/3 Enterprise 4.7 Ext. Set 1.10

but this note is only for a new installation, I don't know if this work with system copy

Note 516246 - INST- System Copy for SAP Systems based on SAP Web AS 6.20

This don't have information about oracle 11.2

I read the manual "Homogeneous and Heterogeneous System Copy for SAP® Systems Based on SAP Web Application Server 6.20" but this also don't say nothing about oracle 11.2

Can you help me? Where can I find this documentation and what DVDs (master and kernel) should I use?

Best regards

[nicholas_chang · Accepted solution]

Hi,

You can perform a system migration where you export your oracle 10.2 database to a dump file with sapinst. After that, re-import the dump file in target with sapinst again. Prior to this, sapinst will prompt you for database installation where 11g direct installation is supported for SAP R/3 Enterprise 4.7 Extension set1 and 2. Refer to Note 1398634 - Oracle database 11g: Integration in SAP environment for more info.

Cheers,

Nicholas Chang

[JPReyes]

Hi filipe,

Why don't you simply upgrade your current system to 11g and then take the export to build your new system??, upgrade to 11g is not a complicated process.

Regards

Juan

[Botte]

I have to do a system copy to a new machine, were we are going to upgrade to ERP 6.0.

If I upgrade oracle 10.2 to 11.2 I also have to do a system copy to the new machine.

So, I think the best way is only to do one system copy, export oracle 10.2 and import in oracle 11.2.

Best regards

[JPReyes]

Sure, then make sure that you have the latest 4.7 Installation Master as well as the 11g RDBMS, Instant Client and SBP.

Usually its not a problem to upgrade the DB when doing a system copy using IMPORT/EXPORT method.

Regards

Juan

[Botte]

Hi Juan,

Thanks for your answer.

That is my doubt, what installation master shoud I use for export oracle 10.2 and import in oracle 11.2?

Note "1499877 - Oracle 11.2 for R/3 Enterprise 4.7 Ext. Set 1.10" say that I can use installation master of R/3 4.7 Set 2 (47x200) to install a new system.

I found this media:

51033746_9 Installation Master 6.20/6.40 Linux on x86_64 64bit

and

51040087_7 NW 04 SR1 Inst. Mst. Linux x86_64 64bit f. Oracle 10.2/11.2

I think this is the note that I need:

Note 1478351 - Oracle 11g Support on UNIX: 6.40-Based SAP Systems

[JPReyes]

I think your answer is on Note 1499877 - Oracle 11.2 for R/3 Enterprise 4.7 Ext. Set 1.10.

Use the Installation Master DVD for SAP R/3 Enterprise 4.7 Ext 2 SR1 and proceed with the manual steps as per the Note

The installation master the should be 51033746_9

Regards

Juan

[Botte]

I think your answer is on Note 1499877 - Oracle 11.2 for R/3 Enterprise 4.7 Ext. Set 1.10.

Use the Installation Master DVD for SAP R/3 Enterprise 4.7 Ext 2 SR1 and proceed with the manual steps as per the Note

Regards

Juan

Hi Juan,

Yes, is that note and these:

Note 1478351 - Oracle 11g Support on UNIX: 6.40-Based SAP Systems

Note 971646 - 6.40 Patch Collection Hom./Het.System Copy ABAP

Regards and thank you all.

[former_member686974]

HI ,

You told that you are going to use export/import method for sysetm copy. So first check the correct Installation master which can support both Oracle 10.2 and 11.2.

After taking the export successfully inport the data dump in the target system using the R3load but first install the 11.2 Orcale s/w then start the ABAP import.

You can check with the below three material nos.

51019679

51019680

51019686

Thanks

Mukul

[Botte]

Thanks for your answers.

Mukul chand,

But where can I find which DVDs should I use for both export/import?

Best regards

[Former Member]

Hi,

What hardware are you on ?

Mark

[Botte]

Is in Linux RedHat 5.x