• About Me
  • Disclaimer
  • Now it’s time to change my Oracle ACE to Oracle ACE Director.

Oadba's Blog

~ The Infinite Reference for Oracle Apps DBAs

Oadba's Blog

Monthly Archives: April 2015

Using Transportable Tablespaces to Migrate Oracle E-Business Suite Release 12.0 or 12.1 Using Oracle Database 12c Release 1 Enterprise Edition

30 Thursday Apr 2015

Posted by oadba in Uncategorized

≈ Leave a comment


This page describes the process of migrating an existing Oracle Applications Release 12.0 or 12.1 database instance using the Cross Platform Transportable Tablespaces (XTTS) feature of Oracle Database 12c Release 1.

Transportable Tablespaces is a feature that provides a faster means to move bulk data from one database to another, independent of the operating system of the source and target. This cross-platform support of this feature provides improved functionality in distributing data and database migration specifically across platforms of different endian (byte-ordering) formats. For details on this feature, please refer to the section ‘Transporting Tablespaces Between Databases’ in Chapter 15 (‘Transporting Data’) of the Oracle Database Administrator’s Guide, 12c Release 1 (12.1).

Known Issues and Limitations of XTTS

  1. Built-in Limitations 
    Built-in limitations are documented in the Oracle Database Administrator’s Guide, 12c Release 1 (12.1). One important limitation outlined in this document that is relevant for EBS is that the source and target databases must have the same character set and national character set.
  2. Column Encryption Using TDE 
    Transportable Tablespaces migration is not supported for tables that have columns encrypted using the Transparent Data Encryption (TDE) functionality of Oracle Database 12c (see My Oracle Support Document 732764.1). Tables that have encrypted columns must be de-crypted prior to following the transportable tablespaces migration and then encrypted in the target database after migration.
  3. Mixing RDBMS and EBS Schemas in the same Tablespace 
    The use of RDBMS and EBS Schemas in the same tablespace is not supported as tablespaces with RDBMS schemas are disregarded in the creation of the transportable set. It is recommended that RDBMS schemas (such as CTXSYS) be in separate tablespaces (for example, SYSAUX).
  4. Cross Platform Incremental Backup
    Cross Platform Incremental Backup is only certified to work with RDBMS 12.1.0 source.
  5. Full Transportable Export/Import
    Full Transportable Export/Import is only certified to work with RDBMS 12.1.0 source.

The most current version of this document is Note 1945814.1 on My Oracle Support.

Subscribe

  • Entries (RSS)
  • Comments (RSS)

Archives

  • May 2015
  • April 2015
  • March 2015
  • February 2015
  • January 2015
  • December 2014
  • February 2014
  • January 2014
  • December 2013
  • September 2013
  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • December 2012
  • November 2012
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • February 2012
  • December 2011
  • November 2011
  • October 2011
  • September 2011
  • August 2011
  • July 2011
  • May 2011
  • March 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010
  • October 2010
  • August 2010
  • July 2010
  • February 2009
  • January 2009

Categories

  • AD Utilities
  • Administration
  • Application Patching
  • Career Management
  • Certification
  • Cloning
  • DEMOs
  • Essential OS Commands
  • General
  • Installation
  • Monitoring & Troubleshooting
  • MOS Docs
  • My Oracle Support (MOS)
  • Oracle Cloud
  • Oracle Fusion Apps
  • Oracle Utilities
  • Oracle VM
  • Oracle Workflow
  • Patching
  • Performance & Tuning
  • RAC Specific
  • Scripts
  • Security
  • Troubleshooting
  • Uncategorized
  • Upgrades

Meta

  • Register
  • Log in

Blog Stats

  • 86,082 hits

OADBA Blog Search

April 2015
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
27282930  
« Mar   May »
Locations of visitors to this page

Documentation

  • Release 12.1 Documentation Library

Blog at WordPress.com.

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Follow Following
    • Oadba's Blog
    • Join 239 other followers
    • Already have a WordPress.com account? Log in now.
    • Oadba's Blog
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar