Database migration across platforms of different "endian" (byte ordering) formats using the Transportable Tablespaces (TTS) process is now certified for on-premise Oracle E-Business Suite Release 12.1.3 with Oracle Database 19c.
To use this certified process the source database must be either Oracle Database 11gR2 (188.8.131.52), 12cR1 (184.108.40.206) or 19c and the target database is Oracle Database 19c. The target database will consist of a single pluggable database (PDB) in a container database (CDB).
This EBS 12.1 with Database 19c database migration process utilizes the full transportable export/import feature. The full transportable export/import feature significantly speeds up the migration process while also offering the optional use of incremental backup to minimize downtime.
Patch 31405457, delivered by the EBS Platform Engineering team, is required for this migration process. The patch is now generally available on MOS for use by EBS customers. The patch provides various SQL scripts to facilitate the export and import of an EBS database instance using TTS.
The "endian-ness" of platforms can be checked by querying the view V$TRANSPORTABLE_PLATFORM using sqlplus (connected as sysdba) with the following statement:
SQL> select platform_name, endian_format from v$transportable_platform;
The following table is a list of relevant platforms certified for the EBS 12.1 with Database 19c on the database tier:
|Big Endian||Little Endian|
|Oracle Solaris on SPARC||Linux x86-64|
|HP-UX Itanium||Windows x64|
|IBM AIX on Power Systems|
|Linux on IBM Z|
Guidance for Using Transportable Tablespaces
The use of TTS may greatly speed up the migration of the data portion of the database. It does not however affect the speed of migrating the metadata which is done using export/import. Smaller databases (less than 1TB) may see little gain from the use of TTS and other techniques like export/import are simpler and possibly faster.
We recommend that when considering the use TTS, you first perform a test migration with export/import on your database using the 'metrics=y' parameter. This will provide information regarding the relative size of data vs metadata in your database and thereby give you a basis to compare any gains in timing. Generally speaking, the larger the relative size of data (as compared to metadata), the more likely it would be that TTS is suitable as a migration process to reduce downtime.
This particular certification is specific to on-premise platform migrations. Additional platform migration certifications that are in progress or planned include the following:
- EBS 12.2 and 12.1.3 DB cross-platform migration to Oracle Cloud using 19c Transportable Tablespaces
- Using Transportable Tablespaces to Migrate Oracle E-Business Suite Release 12.1 using Oracle Database 19c Enterprise Edition on a Multitenant Environment (MOS Note 2707504.1)
- Interoperability Notes: Oracle E-Business Suite Release 12.1 with Oracle Database 19c (MOS Note 2580629.1)
- Database Initialization Parameter Settings for Oracle E-Business Suite Release 12 (MOS Note 396009.1)
- Information Center: Oracle Database 19c with Oracle E-Business Suite 12.2 and 12.1 (MOS Note 2655839.2)
- Oracle Database Administrator's Guide 19c