Database migration across platforms of the same “endian” (byte ordering) formats using the Transportable Database (TDB) process is now certified for Oracle E-Business Suite Release 12.2 with Oracle Database 12c Release 1 (12.1.0).

The “endian-ness” of platforms can be checked by querying the view V$TRANSPORTABLE_PLATFORM using SQL*Plus (connected as SYSDBA):

SQL> select platform_name, endian_format from v$transportable_platform;

The following is a list of relevant platforms certified for Oracle E-Business Suite Release 12 (12.2) with Oracle Database 12c Release 1 on the database tier:

Big Endian Platforms Little Endian Platforms
Oracle Solaris on SPARC Linux x86-64
HP-UX Itanium Oracle Solaris on x86-64
IBM AIX on POWER Systems Microsoft Windows x641
IBM: Linux on z Systems  

1 Note: Microsoft Windows x64 is not yet certified and will be announced separately at a later date.

Using Transportable Database is the fastest method for migration between platforms of the same endian format. A requirement of this migration process is that the source and target database versions must match (including patch set version), so database upgrades as part of the migration cannot be done. For migration between platforms of different endian formats, users must use alternative migration methods such as export/import (datapump).

References

Related Articles