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.1 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.1) 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 x64*
 IBM: Linux on System z  
* Microsoft Windows x64 is not yet certified and will be announced 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) or Transportable Tablespaces (TTS).

References

Related Articles