As a follow up to a prior announcement, database migration across platforms of different “endian” or byte ordering formats using the Transportable Tablespaces (TTS) process is now certified for Oracle E-Business Suite Release R12 (12.1.3) with Oracle Database 12c Release 1 (12.1.0) as both the source and target database. The previous announcement covered the use of 11gR2 as the source and 12cR1 as the target database. Furthermore, this TTS migration process uses the new 12c feature of full transportable export/import to move the entire database to further speed up the migration process. Also, users have the option to use cross platform incremental backup, a way to minimize database downtime and data transfer times. This migration process requires a patch delivered by EBS Development that is ‘Controlled’, i.e. it requires a password obtainable through Oracle Support subject to approval. We released the required patch in this manner to assess suitability, potentially monitor customer issues due to the nature of this technology and to gauge uptake.

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

SQL> select platform_name, endian_format from v$transportable_platform;

Here’s a list of relevant platforms certified for the EBS R12 with 12cR1 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  MS Windows x64

For more information, please review the following:

Related Articles