X

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

  • August 4, 2008

Migrating E-Business Suite Release 11i Databases Between Platforms

Steven Chan
Senior Director

[Sept 18 Update: Transportable Database is now certified for EBS 12 environments, too. See this article for details.]

[Aug 5, 2008 Update: Clarified the use of Export/Import as a fallback if the Transportable Database option doesn't work for a given source and target platform]

Platform migration is the process of moving a database from one operating system platform to a different operating system platform. You might wish to migrate your E-Business Suite database to create testing instances, experiment with new
architectures, perform benchmarks, or prepare for actual platform changes in your production environment. A new method for performing platform migrations is now certified for E-Business Suite databases: Transportable Database (TDB).

Comparing Export/Import to Transportable Database

The supported way to accomplish this in prior releases of the Oracle database has been 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, Transportable Database can be used to reduce the amount of time required to migrate a database between platforms that share the same "endian" format (byte ordering). Note that if the endian format is
different between the source and target platforms, then Transportable Database cannot be used. For generic databases, a different method, such as Streams, Data Pump, or Cross-Platform Transportable Tablespaces must be used instead. An upcoming paper titled "Platform Migration using Transportable Tablespaces" will discuss migrating a database to a platform that is a different endian format. For E-Business Suite databases, only the Export/Import option is a viable fallback if the Transportable Database feature can't be used for your source and target platforms.

The reductions in migration times can be significant. For example, a test database within the Maximum Availability Architecture (MAA) High Availability Lab was migrated to a new platform using Data Pump export and import in 74 minutes. The same database was
migrated using Transportable Database in 37 minutes, a 50% reduction in migration time.

What Platforms Are Supported for Transportable Databases?

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

SQL> select platform_name from v$db_transportable_platform;

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

References

Related Articles

Join the discussion

Comments ( 48 )
  • Danny Monday, August 4, 2008

    Hi Steven,

    There is also the following metalink if you are migrating from 32 to 64-bit Linux

    Note: 341880.1, How to convert a 32-bit database to 64-bit database on Linux?


  • Steven Chan Tuesday, August 5, 2008

    Thanks, Danny. That's a useful pointer. We haven't reviewed that Note here in the Applications Division, but it should be generically applicable to E-Business Suite environments.

    Regards,

    Steven


  • Vikas Tuesday, August 5, 2008

    Migrating from Linux 32 to 64 bit is already mentioned in

    Split Configuration Database Tier Document 369693.1

    Regards,

    Vikas


  • Malik MAZROU Thursday, August 7, 2008

    Hi Steven,

    Could you tell me if there is a certified/supported way to migrate/convert 11i Environment from Windows system (x86) to a UNIX certified platforms ? What is the best solution to accomplish this migration ?

    Thank you in advance for your response.

    Regards

    Malik


  • Terri Noyes Thursday, August 7, 2008

    Please review these two documents on the OracleMetalink site for instructions on how to migrate the E-Business Suite Release 11i middle tier between Windows and your chosen UNIX platform (please ignore the misleading title of the first note):

    1. Migrating to Linux with Oracle Applications Release 11i

    https://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=238276.1

    See the Note: This process can be used to migrate from any platform to any supported Unix platform. Substitute references to Linux with the Target platform.

    2. Debugging Platform Migration Issues in Oracle Applications 11i

    http://metalink.oracle.com/metalink/plsql/ml2_documents.showNOT?p_id=567703.1

    Thanks-

    Terri


  • Priyank Jain Friday, August 29, 2008

    Hi Steve,

    I did try migrating a 10g database from HP-UX to Linux (32 bit), that have different endian formats using transportable tablespaces.

    Despite 3 days of effort, I am still struggling to get things working. Had to manually create the roles, 1000s of synonyms, sequences and packages and yet I'm not very confident that it will work exactly the same way. This is just a test database so I can afford to play around.

    Finally, I am now trying the datapump to get the full database export. Hope this will work.

    Do you have any other suggestions that can help me with this situation?

    Regards,

    Priyank.


  • Steven Chan Tuesday, September 2, 2008

    Hi, Priyank,

    I'm sorry to hear that you've been struggling with this. If you provide your Service Request number with the details of the issues you've encountered, I'll let our Applications Platform Group know about this.

    Regards,

    Steven


  • Abu Omair Hafeez Monday, September 8, 2008

    Hi Steve

    I need Metalink DOC id for platform migration of oracle11i(application + database) from windows to HP UX.

    Thanks

    With Regards

    Abu Omair Hafeez


  • Steven Chan Wednesday, September 10, 2008

    Hi, Omar.

    Metalink Note 238276.1 will do the trick. This note applies to EBS migrations between any platform.

    Regards,

    Steven


  • Sidney Monday, January 19, 2009

    I would like to know if is possible to migrate OEBS R12 from Linux to Windows.

    Tks,

    Sidney.


  • Steven Chan Tuesday, January 20, 2009

    Sidney,

    Yes, that's technically feasible. However, I'm afraid that I'm not a platforms specialist and don't have the appropriate Metalink Note handy. You should be able to get a pointer to that Note by logging a formal Service Request via Metalink.

    Good luck with your platform conversion.

    Regards,

    Steven


  • Akhter Sufi Tuesday, February 16, 2010

    Hi,

    Is there any worth to migrate eBiz 11i or R12 from IBM AIX box to Linux?

    Regards,


  • Steven Chan Thursday, February 25, 2010

    Hi, Akhter,

    This is a deceptively simple question with deep implications. Our Applications Platforms Group generally feels that there are simply too many customer specific variables to take into account one way or another and that the customers should engage themselves in a process of understanding the pros/cons or get help to assess their particular situation and needs with respect to their hardware needs, costs structures, current system administration abilities, supportability by software applications, and so on.

    Best of luck with your platform evaluation.

    Regards,

    Steven


  • suresh Wednesday, March 10, 2010

    hi

    Greetings

    ours is a construction company and at presnt we are using 11i and we want to migrate to R12 to meet organizational requirement .

    Could you please explain the procedure for data migration from11i to 12.

    what type of interface is reuuired ?

    AMG & API is required or any other alternative.

    Regards

    Suresh


  • Steven Chan Friday, March 12, 2010

    Hi, Suresh,

    Good timing for your question. I'd recommend reading the new whitepaper that we just released:

    New Whitepaper: Planning Your E-Business Suite Upgrade from Release 11i to 12.1

    http://blogs.oracle.com/stevenChan/2010/03/ebs_121_upgrade_whitepaper.html

    Regards,

    Steven


  • Manjunath Tuesday, May 18, 2010

    Steven,

    Source version:

    EBS 11.5.8 with 9.2.0.5 database on AIX.

    Database sizes are 2.5 - 3 TB

    Target environments needed:

    EBS 12.1.1 with 11gR1/R2 database on OEL.

    What would be your suggestion for this migration and upgrade.. In particular I am in need of a solution for data migration at this point in time from source 9205 db. The R12 upg part of the requirement is fine.

    Traditional Exp/imp from 9205 to 11g or 10g is not possible (not supported for EBS dbs). So we need to have an intermediate 9i db on the target to accomplish the data migration part. It can then be upgraded to 11g after data migration (and then upgraded to R12).

    But Exp/imp is going to take a lot of time for db of this size.

    Assuming upgrade of source to 11.5.10 is not an option now, is there any other way to eliminate traditional exp/imp (and use XTTS or atleast datapump).

    Is 11.5.8 certified with 10gR2 - if that is possible then only db can be upgraded to 10gR2 on source and then data pump could be used. This may be faster than traditional exp/imp .

    Any suggestions?

    Thx

    Manjunath


  • John A Wednesday, May 19, 2010

    hi Manjunath -

    From a Dev point of view, here are the following facts pertaining to this problem you face:

    (a) The 11i/10gR2 interoperability notes (362203.1) state that at least 11.5.9 is required for use with 10gR2 and we never certified anything less even for the earlier 10.2.0 versions.

    (b) One must upgrade to at least 11.5.9 before upgrading to 12.1.1 - we in fact recommend going to 11.5.10.2 from earlier 11i releases to meet this requirement (see 761570.1).

    (c) XTTS is currently only certified for 11.5.10.2/10gR2 DB migrations

    (d) As you note, use of export/import in 10gR2/11gR1/11gR2 for EBS requires datapump which did not exist pre 10gR2. So the source of any migration to these versions must be at least 10gR2.

    So, it seems to me that there's no easy way you can avoid going to 11.5.10.2 with 10gR2 on the source environment prior to doing a DB migration (using XTTS, which will save you time), and then to do a 12.1.1 upgrade using Rapid Install to lay down a new application tier on the Linux platform.

    One, I suppose, could also try an intermediate upgrade to 11.5.9 then upgrade to 10gR2 on the source, and then use datapump export/import to migrate the DB instance. I would think that this would be slower than the first option though..

    rgds,

    John


  • Fred Correa Wednesday, September 8, 2010

    We are planning to purchase Sun X4450s with quad 2.9 Intel x86 processors. Want to know if there is a certified path to migrate current ebs 11.5.9 with Oracle 9 on sun 1.2 sparc processors to Sun x86 platform? We eventually will get to 11.5.10 and then to R12, but need to migrate current install first.


  • John Abraham Thursday, September 9, 2010

    Hello Fred -

    We support Solaris on x86-64 as a 'database tier only' or 'split tier' platform starting with 10gR2 version of the database (for both 11i and R12). So you'd need to upgrade first to 10gR2 first on 11.5.9 (CU2) before migrating the database over to Solaris on x86-64.

    The My Oracle Support Doc 369693.1 ('Using Oracle Applications with a Split Configuration Database Tier on Oracle 10g Release 2') covers the steps to perform this migration to a split tier platform for EBS 11i.

    rgds,

    John


  • Nitin Tuesday, December 7, 2010

    Hi,

    i am currently looking for the metalink notes for Platform migration of EBS 11.5.10.2 application and database from HP-UX to windows server. Also can anyone tell me how to check if existing database can be a candidate for transportable database feature during platform migration, especially when its 8i or 9i release.

    Quick revert would be highly appreciated.


  • John Abraham Tuesday, December 7, 2010

    Hello Nitin -

    HP-UX is a big endian platform while Windows is small, so Transportable Database is not an option here. You can check endianness by running the following in sqlplus (as sysdba):

    SQL> select platform_name, endian format from v$transportable_platform;

    You should use export/import to migrate your 8i or 9i EBS database from HP-UX to Windows following the Support documents 204015.1 or 230627.1.

    It should be noted that neither of these DB versions are actively supported and you will need to upgrade to at least 10gR2 of the DB if you find issues. You should also review the platform/operating system version details for supportability with 11i and the DB versions on the target platform, which may require DB upgrades as well.

    rgds,

    John


  • Balaji Thursday, January 27, 2011

    Hi Steve

    We are in the process of migrating 11.5.10.2 from solaris to RHEL 5 (only database from non rac to rac database). Please let me know we have to do transportable tablespace or expdp and impdb the size of db is 700GB. Also do i have to migrate the db first and then need to make the instance as RAC or creating RAC instance with ASM then migrate.

    Please let me know if any link is available for the same details.

    Regards

    H. Balaji


  • John Abraham Friday, January 28, 2011

    Hello Balaji -

    A database this size is probably right at the cusp of what we'd consider the point where XTTS makes sense. You should try this on a test instance first (using datapump with METRICS=y to look at the relative makeup of metadata vs data along with the PARALLEL option).

    Please file an SR as per instructions in the XTTS doc 454574.1 to request the required patch for XTTS if you decide to go this route.

    I'll clarify recommendations around RAC but it seems to me that it should not matter though you should probably plan to perform a migration to single node first and then enable RAC on your target machine.

    rgds,

    John


  • khaled Abouzeid Monday, February 7, 2011

    we are planning to migrate from both systems

    Grate planes Ver. 9 For Finance and Procurements

    HRNET by Net Solutions for Payroll and HRMS into

    Oracle e-buiness suite.

    can you please advice on the data migration tips and if you have any white papers concerning this topic in particular


  • Steven Chan Monday, February 7, 2011

    Khaled,

    I don't know of any whitepapers that cover those migration scenarios specifically. Your Oracle account manager should be able to help identify staff in Oracle Consulting who can assist with planning and executing these aspects of your implementation.

    Good luck with your project.

    Regards,

    Steven


  • Harish V Thursday, September 15, 2011

    Hello,

    We've to migrate a 3.5 TB Oracle E-Biz 11i 11gR2 database from HP to Linux 64 bit. Please suggest whether export/import is the best option and also steps/options which could reduce the migration downtime.

    Thanks,

    Harish


  • John Abraham Thursday, September 15, 2011

    Hello Harish -

    We are in the process of certifying XTTS with 11i/11gR2 which is likely the best option for migrating a very large database such as yours across platforms of different endian formats.

    Please stay tuned for updates on this along with new documentation, etc. required for this.

    rgds,

    John


  • Gaurav Shankhdhar Thursday, September 29, 2011

    Any time line for certifying XTTS for 11i/11gR2?

    Can we use "Using Transportable Database to migrate Oracle E-Business Suite 11i Using Oracle Database 10.2.0 or 11g [ID 729309.1]" instead of XTTS as of now?


  • John Abraham Friday, October 7, 2011

    Hello Gaurav -

    You can use Transportable Database if you are migrating between platforms of the same endian format (for example between HP-UX and Solaris SPARC).

    XTTS for 11i/11gR2 continues to be in progress.

    thanks,

    John


  • Chenthil Thursday, October 20, 2011

    Can you give us the documentation for 11i migration from HP PA Risc to Linux X86-64 using XTTS. The database is 11gR2.

    Thanks

    Chenthil


  • John Abraham Monday, October 24, 2011

    Hello Chenthil -

    This particular combination (11i/11gR2) for XTTS is awaiting a broader certification exercise which I continue to internally monitor and is still in progress.

    Regards,

    John


  • Srini Friday, March 9, 2012

    Hi Steve,

    I Have migrated database and application from windows to linux using Note:238276.1 note:567703.1

    After migrating from windows to linux I have upgraded DB 10gr2 to 11gr2 on linux in EBS 11i using note:881505.1.

    I would like to know we can move data from windows 10gr2 database(ebs11i) to linux 11gr2(ebs11i) using datapump. If so how do I do it?

    I would like to move data from my production instance which is 10gr2 in ebs 11i environment on windows to Linux 11gr2 in ebs 11i environment

    .

    Does the following note applies to my cituation.

    Export/import notes on Applications 11i Database 11g [ID 557738.1]

    Thanks.

    Srini


  • guest Wednesday, March 14, 2012

    Hi Steve,

    Any update on my above questions?

    Thanks.

    Srini


  • John Abraham Wednesday, March 14, 2012

    Hello Srini -

    Yes, those export/import notes are what you would use to perform a datapump export from 10gR2 and an import into 11gR2 with 11i.

    In particular, please refer to the following sentence in the top section:

    "The target (import to) ORACLE_HOME directory must be Oracle Database 11g (11.x). The source (export from) ORACLE_HOME directory must be either Oracle Database 10g Release 2 (10.2.0), or Oracle Database 11g (11.x)."

    thanks,

    John


  • guest Monday, July 16, 2012

    Hi Steven,

    "An upcoming paper titled "Platform Migration using Transportable Tablespaces" will discuss migrating a database to a platform that is a different endian format. For E-Business Suite databases, only the Export/Import option is a viable fallback if the Transportable Database feature can't be used for your source and target platforms."

    From the above, do you men to say that we will not be able to use "Transportable Tablespaces" to migrate DB to a platform that is a different endian format.

    Can you please confirm


  • guest Monday, July 16, 2012

    Hi Steve,

    I have got another question.

    What would be the idle approach for a Platform migration + DB Upgrade Activity + 11i to R12 Upgrade

    Platform Migration: From HP UX to Linux

    DB Upgrade : 10.2.0.4 to 11gR3

    Applications : From 11i to R12

    Thank you


  • Steven Chan Monday, July 16, 2012

    Hi, Guest,

    We've certified Transportable Tablespaces for R12. See:

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

    In general, most customers upgrade their server first, since the faster hardware makes all subsequent operations go faster. I would then upgrade to 11.2.0.3, and then do your 11i to R12 upgrade.

    Regards,

    Steven


  • Gaurav Monday, July 16, 2012

    The simple path for you can be:

    1) Upgrading the source RDBMS to 11gR2 (On existing HP-UX System)

    2) Migrate Oracle EBS Release 11i database to Linux (x86) (Instance running 11i split configuration)

    3) Upgrade from 11i to R12

    You can customize, as per your business requirements, for example, As Steven said, migrate the DB to Linux first and then do the upgrade. This approach will allow the newer, faster servers to be deployed early in the migration in order to handle most of the heavy lifting during the migration process. But, the disadvantage of this approach is that this approach requires usage of the older version of Oracle DB 10gR2 export/import utility to migrate the data.

    Or you can upgrade the DB at to 11gR2 at source and then do the migration and upgrade exercise.


  • guest Wednesday, July 18, 2012

    Hi Steven,

    We are planning to migrate the existing Applications 11i(11.5.10.2) Database of version 10.2.0.4 - HP UX to 10.2.0.4 - Linux.

    For this we would like to follow " Cross Platform Transportable Tablespaces on 11i with 10gR2 [ID 454574.1] "

    Let us know if we need to refer to any other docs as well.

    Also while going through your blogs..found that

    " An upcoming paper titled "Platform Migration using Transportable Tablespaces" will discuss migrating a database to a platform that is a different endian format. For E-Business Suite databases, only the Export/Import option is a viable fallback if the Transportable Database feature can't be used for your source and target platforms. "

    It was mentioned that Only the Export/Import option is available for E-Business Suite databases.

    Can you please comment on this ?

    Thanks,

    Prasad.


  • Steven Chan Wednesday, July 18, 2012

    Hi, Prasad,

    The Note you've identified is the correct one to use. I suspect that the article that you excerpted was written before the Transportable Tablespaces feature was certified.

    Good luck with your migration.

    Regards,

    Steven


  • guest Tuesday, July 31, 2012

    hi Steven,

    Does oracle still support if we migrate 32-bit dbTier 9.2.0.3 to 64-bit dbTier 9.2.0.3? We are still using Oracle EBS 11i (appsTier 11.5.9)? Tks.


  • Steven Chan Tuesday, July 31, 2012

    Hi, Guest,

    Premier Support for 11.5.9 ended in June 2008. The current minimum patching baseline for EBS 11i is 11.5.10.2. Extended Support for 11.5.10.2 is available to the end of November 2013. If you report any E-Business Suite issues that require new patches, those new patches will require 11.5.10.2 as a prerequisite. I would strongly recommend that you upgrade your environment to 11.5.10.2 as soon as possible.

    Extended Support for 9.2.0.3 ended in July 2010. You have access to existing patches for that database release, but no new patches are being created at this point. I would strongly recommend that you upgrade your environment to the 11.2.0.3 database as soon as possible.

    Regards,

    Steven


  • Chenthil Murugan Monday, September 10, 2012

    Hi,

    During 11i Platform migration, the database we have will be in Linux server 64 bit and the concurrent and web will still continue to reside in HP-PA Risc.

    Do you have any documentation or research done on how Log and out directories will resopond also how the $APPLTMP, $APPLPTIME, $REPTEMP will respond and where do they have to be placed.

    In the database server or concurrent manager server.

    Thanks

    chenthil


  • John Abraham Friday, September 14, 2012

    Hello Chenthil -

    As only your dB server is migrating to Linux in a split tier configuration, your app tier log files and directories pertaining to your CP, Web Tier, etc. will remain on the PA RISC platform.

    Regards,

    John


  • Arun Thursday, November 29, 2012

    Hi Steve,

    We are currently on 11.5.10.2 with RDBMS 9.2.0.8 on HP-UX 11.11 PA-RISC platform. As a first step towards moving to R12, we are moving application and database to Linux platform. Please find below the migration plan

    1) Upgrade Source Database to 10gR2 (11g and above is not supported on above version of HP-UX) and carry out steps as per 362203.1

    2) Install 11.2.0.3 on Linux (64 Bit) and use datapump to create target database

    3) Migrate Application Tier to Linux as per 238276.1

    However, our concern is that we have no way to upgrade source database to 11.2 and as we are migrating the application stack as well, we are bit unsure on how the database and application will talk during the migration due to lack of apps interop patches for 11.2. The other option is to first migrate database to 10.2 and then post application migration upgrade to 11.2 but this is going to prolong the already stretched downtime window. Please suggest

    Regards

    Arun


  • Elke Phelps (Oracle Development) Monday, December 10, 2012

    Arun,

    Thanks for the inquiry. Projects that include E-Business Suite upgrades, database upgrades and platform migrations for the application tier and database tier can be quite tricky.

    In general, we recommend the following:

    - Consider the application and database upgrade separately

    - Migrate and upgrade your database first

    - Migrate and upgrade your application tier by laying down the new R12 tier on the target platform as part of the upgrade

    Please review the following for additional information:

    -Best Practices for Combining

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

    -Oracle E-Business Suite Upgrades and Platform Migration (Note 1377213.1)

    -Using Oracle E-Business Suite with a Split Configuration Database Tier on Oracle 11g Release 2 (Note 946413.1)

    If you still have questions after reviewing the above, please consider contacting your Oracle account manager who can put you in contact with an E-Business Suite upgrade specialist.

    Regards,

    Elke


  • Suresh Friday, March 29, 2013

    we are testing the Ebiz 11i single node database from IBM AIX to RAC with ASM on RHEL 6+, by following the oracle metalink note "Using Transportable Tablespaces for EBS 11i Using Database 11gR2 [ID 1366265.1]". but the expdp "using auexpxtts.dat(which is transportable tablespace) taking close to 12.5 hours. we have raised an Oracle SR and they are still working on it.

    we tried the options to exclude=Table statistics, index_statistics, but still it remains the same timing. do you have any suggestion for us.

    here is the SR detail

    SR 3-6951687671 : FULL METADATA DATAPUMP expdp is very slow to migrate from AIX to Redhat Linux with ASM

    our db size is close to 5TB , to complete the migration it takes close to 30 hours from AIX single node to RHEL RAC with ASM

    any suggestion is appreciated.

    -Suresh


  • Manthri Srikanth Thursday, July 7, 2016

    Hi Steven,

    We are planning to migrate the existing Applications 11i(11.5.10.2) that has been hosted on Solaris 11.3 SPARC (X86-64) with Database version 10.2.0.4 and the database size is of around 200 GB to Oracle Linux 5.11.

    Either to use XTTS or Exp/Imp Method, kindly let me know what is the best solution to accomplish this migration? The specific challenge we have is in migrating a number of databases in a robust and repeatable manner against aggressive timescales.

    What about CLOB, BLOB datatypes, will the Exp/Imp will take care of these datatypes or any additional steps required? Kindly suggest.

    Source configuration:

    EBS 11.5.10.2 with 10.2.0.4 database on Solaris 11.3 SPARC (X86-64).

    Database sizes are 175 GB - 200 GB

    Target Configuration:

    EBS 11.5.10.2 with 10.2.0.4 database on Oracle Linux 5.11.

    Thanks and Regards,

    Manthri Srikanth,


Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.