Syscopy based expo/imp from 10.2.0.2 to 12.1

[ganimede_dignan]

Hi,

I've got a ECC system 6.00 BASIS 7.00 SP 18 on Windows 2003 SP2 X64 with Oracle 10.2.0.2. I would like a technology upgrade for this system... so next year it will be upgrade to the last ECC release (6.08 at last).

I would like to create new VMs (one for dev, one for tst and one for prd) with Windows 2012R2 and Oracle 12.1 with last available patches.

I will do it with a system copy based on export/import. Is it possible? I read several notes and documentations but I haven't find any problem. Is it enough BASIS 7.00 SP18 to run Oracle 12.1? I've find only an issue with statistics update solved by a note with code correction. Last SWMP, can it export the db from a 10.2.0.2 Oracle release?

Thank you so much.

Regards.

[manish_singh13 · Accepted solution]

Hello,

I believe using R3load base export/import method you can perform system copy from Oracle 10 to 12. There are no available notes in support of this method but considering that R3load export/import method is database independent it should work.

Please refer below for all requisite steps related to Oracle 12 (Installation, SAP SP Version etc.)

1914631 - Central Technical Note for Oracle Database 12c Release 1 (12.1)

Thanks,

Manish

[ganimede_dignan · Accepted solution]

Hello,

thank you so much for you post... but, I'ew already read this note but I would like to have a confirmation... is there a limitation/requisites on Support Packages level for ECC 6.00 with Oracle 12.1? Is Kernel level only the software requisite for Oracle 12.1?

Regards.

[manish_singh13 · Accepted solution]

Hello,

All pre-requisites are either mentioned in Central SAP Note 1914631  or there are references for other SAP Notes.

Please see below section:

You need Extended Kernel 7.21 and need Basis 6.0 SP33 for smooth operation of your System.

Thanks,

Manish

[ganimede_dignan · Accepted solution]

Hi,

>You need Extended Kernel 7.21 and need Basis 6.0 SP33 for smooth operation of your System

mhmm... SP33 is a requisite for ACO? ...so without ACO, SP33 is note a requisite... is it true?

My goal is to use Oracle 12.1 (or 11.2) but with SP 18... we haven't time to load support packages on this system

Thank you so much.

[thiago_cavalheiro · Accepted solution]

Hi,

You may implement note 2157907 if you cannot apply a more recent SP. That is mandatory even without using ACO. So the note will work too.

As per the compatibility, you can check it on PAM.

Bets regards,

Thiago

[Former Member]

Hello,

Note 2133079, which you may have read, unambiguously states that NetWeaver 7.0 is supported with Oracle 12.1. There is no restriction as to the minimum SP level. The PAM confirms that the combination is supported (with Windows 2008, 2008R2, 2012 and 2012R2). Kernel on the target platform must be 721_EXT or 722_EXT.

The only exception is for dual-stack ABAP/Java systems but your system being an ECC 6.0 that is unlikely to apply.

R3load is not concerned with the Oracle catalog, only with the objects in the SAP schema. It will be able to handle Oracle 10 as the source database.

Regards,

Mark

[Reagan]

R3load based system copy should let you move the system from 10g to 12c in one step. As long as you have supporting OS, kernel and BR*Tools for Oracle 12c, it should be alright. You do not need to patch the system to the required SP level, just apply the corrections delivered in the note 2157904 and transport it across other systems.