X

The Latest Technology Stack News Directly from EBS Development

EBS 12.0 & 12.1 DB Migration Using 12cR1 Transportable Tablespaces Now Certified

John Abraham
Director

Database migration across platforms of different "endian" (byte ordering) formats using the Transportable Tablespaces (TTS) process is now certified for Oracle E-Business Suite Release R12 (12.0.6, 12.1.3) with Oracle Database 12c Release 1 (12.1.0). Migration between different platforms of the same "endian" format with 12c can be accomplished using export/import (datapump) utilities.  This certification requires that the source database be 11gR2 (11.2.0.3 or higher) and the target database be 12cR1 (12.1.0.1 or higher).  

This migration process requires a patch delivered by our EBS Platform Engineering team that is 'Controlled', i.e. it requires a password obtainable through Oracle Support. We released the required patch in this manner to monitor customer issues 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

The use of Transportable Tablespaces can greatly speed up the migration of the data portion of the database - it does not affect metadata which must still be migrated using export/import. We recommend that users initially perform a test migration with export/import on their database with the 'metrics=y' parameter to find out the relative size of data vs metadata in their database and to have 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.

Pending Certifications

Testing with 12cR1 as the source is still pending.

Full transportable export/import, a new feature in 12c to move an entire database, is not certified for use with E-Business Suite databases yet. 

Transportable Database (TDB), a migration process for platforms of the same "endian" format, is also a pending 12cR1 certification exercise.   

References

 

 Related Articles

Join the discussion

Comments ( 10 )
  • guest Thursday, November 20, 2014

    Hello Steven, Any thoughts on when 12.1.0.2 recently released on the platforms (IBM/ITA/Win) will be certified with 12.1.3.

    Regards,


  • Steven Chan Friday, November 21, 2014

    Hello, Guest,

    It's already certified. See:

    Database 12.1.0.2 Certified with E-Business Suite 12.1

    https://blogs.oracle.com/stevenChan/entry/12_1_0_2_db

    Regards,

    Steven


  • guest Friday, November 21, 2014

    Hello Steven,

    Thanks for your reply.

    I am aware of that note/post, however 12.1.0.2 was released on ITANIUM, IBM and Windows platform just a week ago. Does your reply mean that 12.1.0.2 on these platforms are automatically certified for 12.1.3, based on prior certifications for LINUX and Solaris.

    Regards


  • guest Friday, November 21, 2014

    Hello Steven,

    Thanks for your reply.

    I am aware of that note/post, however 12.1.0.2 was released on ITANIUM, IBM and Windows platform just a week ago. Does your reply mean that 12.1.0.2 on these platforms are automatically certified for 12.1.3, based on prior certifications for LINUX and Solaris.

    Regards


  • John Abraham Tuesday, November 25, 2014

    hi -

    This needs to clarified as there may have been a misunderstanding in this thread - our policy is not to simply "paper certify" platforms as there typically are patches, and sometimes processes to follow, that are different for each platform. The Certifications page in My Oracle Support (https://support.oracle.com) remains the source of truth for E-Business Suite, technology and platforms certifications.

    While the 12.1.0.2 patchset was just released on AIX, HP Itanium and Windows, the EBS R12 certifications with 12.1.0.2 on these platforms are *NOT* complete. These certifications are planned and you can stay tuned to this blog site for updates - Oracle Revenue Recognition policies do not allow us to disclose future estimated dates for certifications.

    Regards,

    John


  • guest Wednesday, November 26, 2014

    Hello,

    That is exactly how I understood it, I checked the certification site and there was no certification for the combination of EBS version, Platform and 12.1.0.2.

    The interoperability note lists a patch that is not released for the new AIX, HP Itanium and Windows platforms.

    There are other Oracle DB blogs that are pushing for a 12.1.0.2 upgrade instead of 11204, however without proper certification and earlier 12.1.0.2 DB releases on all platforms, kind of ties the customers hand, as all customers are not on LINUX or Solaris.

    Regards,


  • Guest Friday, June 9, 2017
    Hi Steven,

    My understanding is that EBS 12.1.3 DB migration using 12cR1 Transportable Tablespaces is not certified for source Database 11.1.0.7. Is there any certification in progress to include pre-11.2.0.3 DB as source ?

    Regards,
  • John Abraham Wednesday, June 14, 2017
    Hello -
    No, we didn't certify 11.1.0.7 as a source for this migration and don't as of yet have plans to.
    Regards,
    John
  • Dipankar Ghosh Friday, October 20, 2017
    Hi Nicoleta,

    As per the steps mentioned in 12c- Doc ID 2005729.1 , Step 4.3 - Apply last incremental backup to destination datafiles executed in the target, This step will apply the last incremental backup to the datafiles. In addition, it will restore the dump file for phase5A and a script file, xttplugin.txt, containing the syntax. So DUMP File () is created in the target.
    In Phase 5 - Transport Phase: Import Object Metadata into Destination Database (same doc) this dump file is imported as per the command generated in xttplugin.txt. During this phase, the tablespaces are plugged into the destination database.
    Phase -5 has Two Options which we have executed.

    For this step, there are two options
    A) Import using dump file ---> fails with ORA-00600


    B) Import using network_link so that we can skip the generation of dump file
    Fails with
    ORA-39006: internal error
    ORA-39065: unexpected master process exception in DISPATCH
    ORA-06502: PL/SQL: numeric or value error: character string buffer too small
    ORA-39097: Data Pump job encountered unexpected error -6502
  • Steven Chan Friday, October 20, 2017
    Hello, Dipankar,

    I'm sorry to hear that you've encountered an issue with this.

    We can provide general conceptual guidance here, but I'm afraid that this blog isn't the best place to get technical support for specific issues like the one that you're working through.

    Your best bet would be to log a formal Service Request via My Oracle Support (formerly Metalink) to get one of our specialists engaged.

    Please feel free to forward your Service Request number to me if it gets stuck in the support process for some reason.

    Regards,
    Steven
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha
Oracle

Integrated Cloud Applications & Platform Services