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.3 or higher with Oracle Database 19c for on-premises environments. An example of platforms of the same endian format are Linux and Windows on x86-64.Oracle-DB-19c

This process requires that the source database (19c) be the same version as the target  database (19c). The entire database (including the SYSTEM tablespace) is copied from one platform to another with transportable database. No export/import step is required with TDB.

The following is a list of a few restrictions when using TDB with EBS 12.2 and Database 19c:

  • Migratiing between platforms of different “endian” formats should be done with other techniques such as transportable tablespaces or export/import.
  • Upgrading the database as part of a platform migration using TDB is not supported.
  • Transporting case sensitive pluggable database (PDB) names is not currently supported.  If you are not using an uppoer case PDB name, you should review documentation to implement case-insensitive PDB names.

The following is a list of relevant platforms certified for the EBS 12.2 with 19c on the database tier by format:

Little Endian

  • Linux x86-64
  • Windows x64

Big Endian

  • Oracle Solaris on SPARC
  • HP-UX Itanium
  • IBM AIX on Power Systmes
  • Linux on IBM Z

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

SQL> select platform_name, endian_format from v$transportable_platform;

References

Related Articles