By John Abraham-Oracle on Apr 29, 2015
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:
- Using Transportable Tablespaces to Migrate Oracle E-Business Suite Release 12.0 or 12.1 Using Oracle Database 12c Release 1 Enterprise Edition (My Oracle Support Document 1945814.1)
- Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup (My Oracle Support Document 1389592.1)
- Oracle Database Administrator's Guide 12c Release 1 (12.1)
- Database Migration using 11gR2 Transportable Tablespaces Now Certified for EBS 12
- 11gR2 Transportable Tablespaces Certified for EBS 11i