Oracle upgrade (10 -> 19c) in heterogeneous migration

[former_member713604]

Dear all

We are planning a heterogeneous migration of SAP systems. The source and target systems are as follows.

[Source System]

SAP: ECC 6.0 EHP4

DB: Oracle 10.0.4.0

OS: AIX 5.3

[Target System ]

SAP: ECC 6.0 EHP4

DB: Oracle19c

OS: Linux RedHat 8.2

We are to conduct the migration by export/import (R3Load) methodology.

[Question] Which of the following options is supported when performing the migration?

1. Install Oracle 19c and import data into it.

2. Install Oracle 10.0.4.0 and import data into it. After that, upgrade to Oracle 19c is performed.

We hope we can go with the option 1. Thanks in advance.

Best regards

[Private_Member_467521 · Accepted solution]

Hi kondohiroya,

Oracle Data Pump is available starting with Oracle Database 10g, so I understand your first option would work.

Here is the official Oracle document for reference. Check table 2.

https://www.oracle.com/a/tech/docs/twp-upgrade-oracle-database-19c.pdf

Relevant sap community blogs for reference:

OSDB (AIX to Linux) blog:

https://blogs.sap.com/2019/10/31/sap-os-upgrade-from-aix-to-linux-part1/

Oracle 19c database upgrade of SAP system

https://blogs.sap.com/2020/07/07/oracle-19c-database-upgrade-of-sap-system/

Relevant SAP Notes:

2800001 - Upgrading to Oracle Database 19c (DBUA)

https://launchpad.support.sap.com/#/notes/2800001

System Copy for Systems Based on SAP NetWeaver - Using Software Provisioning Manager 1.0

https://launchpad.support.sap.com/#/notes/1738258

Heterogeneous ABAP System Copy –Technical Overview

https://www.sap.com/documents/2015/07/c2ddcfe8-527c-0010-82c7-eda71af511fa.html

General OS/DB SAP Note:

https://launchpad.support.sap.com/#/notes/82478

General Linux SAP Note:

https://launchpad.support.sap.com/#/notes/2369910

Please accept the answer if it helps to address your topic

Cheers,

Luis

[former_member713604 · Accepted solution]

Dear Luis

Thank you, I now understand with oracle data pump that exported oracle 10g data can be imported to Oracle 19c directly.

Sorry I missed to tell you that I have one additional point of information. We need to conduct a Unicode conversion (single code page (Japanese) -> Unicode) as well.

Is it possible to perform unicode conversion with Oracle Data Pump?

Best regards

Hiroya