cancel
Showing results for 
Search instead for 
Did you mean: 

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

former_member713604
Discoverer
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Private_Member_467521
Active Contributor
0 Kudos

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
Discoverer
0 Kudos

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

Answers (0)