By John Abraham-Oracle on May 28, 2015
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 11g Release 2 (11.2.0).
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 (12.2) with 11gR2 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|
|IBM: Linux on System z||
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).
- Using Transportable Database to Migrate Oracle E-Business Suite Release 12.2 Using Oracle Database 11g Release 2 Enterprise Edition (My Oracle Support Document 2011169.1)
- Platform Migration Using Transportable Database Oracle Database 11g and 10g Release 2
- EBS 12.0 & 12.1 DB Migration Using 12cR1 Transportable Tablespaces Now Certified
- Transportable Database 11gR2 Certified with E-Business Suite 11i, 12.0, 12.1