X

The Latest Oracle E-Business Suite Technology News direct from
Oracle E-Business Suite Development & Product Management

  • September 18, 2008

Migrating E-Business Suite Release 12 Databases Between Platforms

Steven Chan
Senior Director

Boy, we're just smoking, now.  You can always tell that OpenWorld is heating up when all of these new certifications come pouring out of our labs.  Here's another certification that complements our previous
announcement
for Oracle E-Business Suite Release 11i:  Our Applications Platforms Group has announced that database migration across platforms of the same "endian" format (byte ordering) using the Transportable Database process is now certified with Oracle E-Business Suite Release 12 using 10gR2.

Platform migration is the process of moving a database from one operating-system platform to a different operating-system platform. The supported way to do this prior to Oracle Database 10g Release 2 was to export the data from the database on the old
platform, create a new database on the new platform, and import the data into the new database. This process could take a number of days for a large database. Starting with Oracle Database 10g Release 2, using Transportable Database and following the Maximum
Availability Architecture (MAA) best practices in the whitepaper linked below, you can expect a 50% or greater reduction in the time it takes to complete a platform migration when compared to traditional unload/load methods.

Prerequisites

The minimum 10gR2 Database version required is 10.2.0.3 on both the source and target platforms.

Suitable target platforms can be verified by querying the view V$DB_TRANSPORTABLE_PLATFORM using sqlplus (connected as sysdba) on the source platform:

SQL> select platform_name from v$db_transportable_platform;

If the intended target platform appears in the output, Transportable Database can be used to migrate the database. Otherwise, an alternative such as export/import should be used instead.

Please note that an alternative database technology known as Cross-Platform Transportable Tablespaces (XTTS) to migrate data between platforms of different endian formats is NOT yet certified with Oracle E-Business Suite.  We're running an Early
Adopter Program (at full capacity) for that technology right now.  I don't have any projected schedules for that certification yet, but you're welcome to monitor or subscribe to this blog for updates, which I'll post as soon as soon as they're available.

References

Related Articles

Join the discussion

Comments ( 14 )
  • Yusuke Kodama Friday, June 18, 2010

    Hi,

    I want to clone EBS(12.1.2) across the platform.

    Is it possible?

    【From】

    AP: RHEL 5.3 (64bit)

    DB: AIX 6.1 (64bit)

    【To】

    AP: RHEL 5.3 (64bit)

    DB: RHEL or OEL (64bit)

    If it's possible, would you advise me the guide (Note, Manual etc...) ?

    regards


  • John A Tuesday, June 22, 2010

    Hello -

    It would be useful to think of these two as separate migrations, and to tackle the DB migration first.

    Going from AIX to RHEL/OEL would be done using the traditional export/import (Doc 454616.1 for 10gR2, 741818.1 for 11gR1/R2 ) using datapump. We are still working on the certification of XTTS with R12, so that unfortunately would not be an option at this point.

    After the DB migration, you can then simply clone your application tier from the source RHEL 5.3 (64bit) to the target RHEL 5.3 (64bit) following the Rapid Clone documents (Note 799735.1).

    rgds,

    John


  • Yusuke Kodama Tuesday, June 22, 2010

    Hi, John

    Thank you very much for replying.

    I'll consider the migration with recommended solution.

    I have an another question.

    Is it certified that using XTTS like following ?

    【From】-> E-Business Suite

    AP: RHEL 5.3 (64bit)

    DB: AIX 6.1 (64bit)

    【To】-> ONLY DB

    DB: RHEL or OEL (64bit)

    ※It will be used for DR.

    regards.

    Yusuke Kodama


  • John A Wednesday, June 23, 2010

    Hello -

    I believe what you are proposing is still a DB migration from AIX 6 to RHEL/OEL.

    As noted, XTTS is a db migration process currently only supported for 11i with 10gR2 of the Database.

    rgds,

    John


  • Kumar Tuesday, January 4, 2011

    Hi

    Is it supported now for db conversion between different endian formats ?

    - Kumar


  • Steven Chan Tuesday, January 4, 2011

    Hi, Kumar,

    Not yet. I've forwarded your request on to our EBS Platforms Engineering team so that they can factor that into their prioritization plans for this certification.

    Regards,

    Steven


  • guest Tuesday, November 8, 2011

    Hi,

    Do you know if migration from little to big endian using transportable database is support on R12?

    Many thanks

    Mike


  • Steven Chan Tuesday, November 8, 2011

    Mike,

    The Transportable Database feature supports only same-endian migrations.

    If you're moving between different endian platforms, you need to use Transportable Tablespaces instead. Transportable Tablespaces are supported with EBS 12 on 11gR2. See:

    Database Migration using 11gR2 Transportable Tablespaces Now Certified for EBS 12 (Oracle E-Business Suite Technology)

    https://blogs.oracle.com/stevenChan/entry/database_migration_using_11gr2_transportable

    Regards,

    Steven


  • guest Sunday, April 15, 2012

    Can we use expdp and impdp for cross platform migration from Linux Itanium to AIX 7 Power system.

    source system : 12.1.3 with 10.2.0.4 DB (Linux Itanium)

    target system : 12.1.3 with 11.2.0.2 DB (AIX 7.1 Power system)

    Also for Transportable tablespace is it mandatory we should have same DB version on both sides.


  • John Abraham Monday, April 16, 2012

    Yes, you can - export/import with datapump (i.e. expdp and impdp) is the generic and traditional way of moving data between platforms regardless of endian format. Additionally, one can also export from 10gR2 and import into 11gR2.

    The requirement for 11gR2 Transportable Tablespaces with EBS R12 is that the source be at least 11gR1 (see MOS Note 1311487.1).

    Regards,

    John


  • guest Tuesday, November 26, 2013

    Hi,

    I have two tier environment, i.e my Apps and DB tiers are on separate nodes. The OS on both machines is linux. Now just want to migrate my database from linux to AIX and want to connect my existing APPS tier to the new DB tier. Can any one help me in this regard.

    Regards,

    Nadir


  • Steven Chan Tuesday, November 26, 2013

    Hi, Nadir,

    You can use the documents listed above to do that. If you have questions about specific steps in those documents, you can log Service Requests with Oracle Support for additional guidance.

    Good luck with your migration.

    Regards,

    Steven


  • guest Monday, May 19, 2014

    Hi All

    We are on Oracle Application R12.1 and we need to upgrade application server from AIX 6.1 to AIX 7.1

    Could you please let me know if there are some expected changes in code like custom shell scripts/Java Classes. Is there any documentation available to this upgrade?

    Thanks,

    Shashank


  • Steven Chan Friday, May 23, 2014

    Hi, Shashank,

    I'm not sure what you mean by "changes in code like custom shell scripts." If you have custom shell scripts, you would be the best person to determine whether there are any changes.

    See this article for links to our EBS 12 + AIX 7 installation documentation:

    Oracle E-Business Suite Release 12 now Certified on AIX 7

    https://blogs.oracle.com/stevenChan/entry/oracle_e_business_suite_release

    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.