Migrating E-Business Suite Release 11i Databases Between Platforms

[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

Comments:

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?

Posted by Danny on August 04, 2008 at 07:18 AM PDT #

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

Posted by Steven Chan on August 05, 2008 at 05:20 AM PDT #

Migrating from Linux 32 to 64 bit is already mentioned in
Split Configuration Database Tier Document 369693.1

Regards,
Vikas

Posted by Vikas on August 05, 2008 at 01:25 PM PDT #

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

Posted by Malik MAZROU on August 06, 2008 at 09:10 PM PDT #

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

Posted by Terri Noyes on August 07, 2008 at 05:37 AM PDT #

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.

Posted by Priyank Jain on August 29, 2008 at 05:48 AM PDT #

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

Posted by Steven Chan on September 02, 2008 at 05:00 AM PDT #

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

Posted by Abu Omair Hafeez on September 07, 2008 at 06:31 PM PDT #

Hi, Omar.

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

Regards,
Steven

Posted by Steven Chan on September 10, 2008 at 01:06 AM PDT #

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

Tks,
Sidney.

Posted by Sidney on January 19, 2009 at 03:08 AM PST #

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

Posted by Steven Chan on January 20, 2009 at 04:26 AM PST #

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

Regards,

Posted by Akhter Sufi on February 15, 2010 at 06:59 PM PST #

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

Posted by Steven Chan on February 25, 2010 at 02:49 AM PST #

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

Posted by suresh on March 09, 2010 at 06:27 PM PST #

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

Posted by Steven Chan on March 12, 2010 at 05:53 AM PST #

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

Posted by Manjunath on May 18, 2010 at 11:22 AM PDT #

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

Posted by John A on May 19, 2010 at 05:42 AM PDT #

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.

Posted by Fred Correa on September 08, 2010 at 10:52 AM PDT #

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

Posted by John Abraham on September 09, 2010 at 01:03 PM PDT #

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.

Posted by Nitin on December 06, 2010 at 10:10 PM PST #

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

Posted by John Abraham on December 07, 2010 at 03:12 AM PST #

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

Posted by Balaji on January 26, 2011 at 06:55 PM PST #

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

Posted by John Abraham on January 28, 2011 at 01:23 AM PST #

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

Posted by khaled Abouzeid on February 06, 2011 at 07:52 PM PST #

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

Posted by Steven Chan on February 07, 2011 at 01:18 AM PST #

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

Posted by Harish V on September 15, 2011 at 02:41 AM PDT #

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

Posted by John Abraham on September 15, 2011 at 04:12 PM PDT #

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?

Posted by Gaurav Shankhdhar on September 28, 2011 at 08:40 PM PDT #

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

Posted by John Abraham on October 07, 2011 at 04:04 AM PDT #

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

Posted by Chenthil on October 19, 2011 at 06:57 PM PDT #

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

Posted by John Abraham on October 24, 2011 at 06:13 AM PDT #

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

Posted by Srini on March 09, 2012 at 11:06 AM PST #

Hi Steve,

Any update on my above questions?

Thanks.
Srini

Posted by guest on March 14, 2012 at 06:47 AM PDT #

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

Posted by John Abraham on March 14, 2012 at 08:48 AM PDT #

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

Posted by guest on July 16, 2012 at 04:07 AM PDT #

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

Posted by guest on July 16, 2012 at 04:16 AM PDT #

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

Posted by Steven Chan on July 16, 2012 at 08:00 AM PDT #

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.

Posted by Gaurav on July 16, 2012 at 10:33 AM PDT #

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.

Posted by guest on July 17, 2012 at 11:35 PM PDT #

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

Posted by Steven Chan on July 18, 2012 at 08:18 AM PDT #

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.

Posted by guest on July 31, 2012 at 03:25 AM PDT #

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

Posted by Steven Chan on July 31, 2012 at 09:22 AM PDT #

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

Posted by Chenthil Murugan on September 10, 2012 at 10:09 AM PDT #

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

Posted by John Abraham on September 14, 2012 at 09:36 AM PDT #

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

Posted by Arun on November 29, 2012 at 08:19 AM PST #

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

Posted by Elke Phelps (Oracle Development) on December 10, 2012 at 08:20 AM PST #

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

Posted by Suresh on March 28, 2013 at 10:30 PM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
4
5
6
7
8
9
10
11
12
13
14
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today