10gR2 Transportable Tablespaces Certified for EBS 11i

Database migration across platforms of different "endian" (byte ordering) formats using the Cross Platform Transportable Tablespaces (XTTS) process is now certified for Oracle E-Business Suite Release 11i (11.5.10.2) with Oracle Database 10g Release 2.  This process is sometimes also referred to as transportable tablespaces (TTS).

What is the Cross-Platform Transportable Tablespace Feature?

XTTS_Supported_Platforms2 comparison of endian-ness of operating system platforms
The Cross-Platform Transportable Tablespace feature allows users to move a user tablespace across Oracle databases. It's an efficient way to move bulk data between databases. If the source platform and the target platform are of different endianness, then an additional conversion step must be done on either the source or target platform to convert the tablespace being transported to the target format. If they are of the same endianness, then no conversion is necessary and tablespaces can be transported as if they were on the same platform.

Moving data using transportable tablespaces can be much faster than performing either an export/import or unload/load of the same data. This is because transporting a tablespace only requires the copying of datafiles from source to the destination and then integrating the tablespace structural information. You can also use transportable tablespaces to move both table and index data, thereby avoiding the index rebuilds you would have to perform when importing or loading table data.

Obtaining the Required EBS Patch

This EBS database migration process was previously only available to participants of a TTS Early Adopter Program. This migration process currently requires a patch delivered by our EBS Platform Engineering team that is 'Controlled', i.e. it requires a password that you can obtain by logging a formal Service Request with Oracle Support. We are distributing the required patch in this manner to monitor potential customer issues due to the nature of this technology, gather feedback, and assess the technology's adoption rate.

Does it meet your requirements?

Users migrating large databases across platforms of the same "endian" format are advised to use the Transportable Database (TDB) migration process instead of Transportable Tablespaces. The "endian-ness" 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 does not appear in the output, it means that it is of a different endian format from the source and Transportable Tablespaces (for large databases) or export/import should be used for database migration.

Other Certifications Still Underway

Transportable Tablespaces for other Database and EBS versions (such as 10gR2+R12, 11g+R12 and 11g+11i) are still under evaluation.  Oracle's Revenue Recognition rules prohibit us from discussing certification and release dates, 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.

Documents in My Oracle Support referred to in the Certifications section of My Oracle Support pertaining to general information on EBS 11i (such as Document 986762.1) are in the process of being updated to reflect this certification.

References
Related Articles
Comments:

Will 10gR2 XTTS be certified for 11.5.9 ?

Posted by Gazanfurali on April 18, 2010 at 05:18 AM PDT #

Hello, Gazafurali,

No, I'm afraid not. We have no plans to certify XTTS with 11.5.9.

Regards,
Steven

Posted by Steven Chan on April 18, 2010 at 02:13 PM PDT #

Hi Steve
Is XTTS certifed for DB(11.1.0.7) migration from AIX5.3 to OEL5 ?
with Apps(12.1.1)

Posted by Naveen on May 19, 2010 at 02:32 AM PDT #

We are migrating from HP-UX/11i/10gR2 to Linux/11i/11gR1.
XTTS Note says the source and target ORACLE_HOMEs have to be same version.
Any update on the certification and on the ORACLE_HOME being on same version requirement?

Posted by Venkat on June 11, 2010 at 02:43 AM PDT #

Hi, Venkat,

No, there have been no changes to this requirement.

Regards,
Steven

Posted by Steven Chan on June 17, 2010 at 04:27 AM PDT #

Hi Steve,

We are in the process testing migration of an application database from HP-UX to LINUX per note:454574.1. Any idea when the patch 6158038 will be available to download?

Thanks
SBabu

Posted by SBabu on July 07, 2010 at 05:15 AM PDT #

Hi, SBabu,

It's available for download now, but we're trying to keep track of who's using it so that we can ensure that you're successful with this process. Please log a formal Service Request via My Oracle Support (formerly Metalink) to get the password for this patch.

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

Regards,
Steven

Posted by Steven Chan on July 07, 2010 at 06:28 AM PDT #

Thanks for the quick response Steve. I opened SR #3-1908638351 for the password but I was informed that the patch is not available for download. I would appreciate if you could help me on this.

Posted by SBabu on July 07, 2010 at 12:16 PM PDT #

Hi, SBabu,

Your Support Engineer is following up with the team that owns this patch. He'll be providing you with an update in your SR directly.

Regards,
Steven

Posted by Steven Chan on July 08, 2010 at 01:11 AM PDT #

Hi Steve,

Oracle support didn’t provide the password yet. I would appreciate if you can help me on this so that I can test the XTTS and evaluate the best option.

Thanks
SBabu

Posted by Sbabu on July 12, 2010 at 12:23 AM PDT #

Hi, Sbabu,

Your Support engineer will be updating your SR with some additional questions for you shortly. Please monitor your SR for the next steps.

Regards,
Steven

Posted by Steven Chan on July 13, 2010 at 03:11 AM PDT #

Hi Steve,

What is the plan for certification for XTTS with EBS R12 and DB 10gR2? Any timeline

Posted by Guru on August 10, 2010 at 04:08 AM PDT #

Guru-
We are currently soliciting feedback on the 11i/10gR2 customer exercises, and concentrating forward-looking certification efforts on 12.1.x and 11gR2. Unfortunately, there is no timeline, since this is not a straightforward test effort but truly a proof-of-concept and we have/will hit impediments. Thanks for your understanding, and sorry to break the news.

-Terri

Posted by Terri Noyes on August 11, 2010 at 04:28 AM PDT #

Hi. We are planning a platform migration from Sun Solaris to HP Linux as well as an upgrade from R11 to R12 and DB10G to DB11.

Approach.

1(a) Migrate Database (10G to 10G) using Import / Export or TableSpace approach (DB size approx 700GB). Include change from 32bit to 64bit.
1(b) Upgrade Database to 11G.

This leaves a split configuration for a period of time.

2 - Apply OATM

3(a) - Implement HP App Servers
3(b) - Upgrade to R12.

It would seem that the main benefit of Tablespace approach will be making the platform migration a much shorter exercise. However I'm not seeing much evidence of it's success / ease of implementation? Are you able to provide a summary of the customer feedback on this approach and how successful it has been. We will be on a tight project timeframe and while it will be faster to deploy this way - i need to consider how long it will actuall ytake to get working if it's been generally problematic.

Regards

Martin

Posted by Martin Paget on August 16, 2010 at 12:39 PM PDT #

Hello Martin -
We continue to monitor the uptake of the XTTS controlled patch and don't have enough data yet to provide a definitive summary of all customer feedback.
What I can say is that the benefits of XTTS, while specific to your own tolerance for downtime, become more apparent for EBS databases that are >1TB wherein the time savings outweigh the more complicated process.
In order to also assess your potential time savings, you could also run an export/import using the optional parameter METRICS=y to see what sorts of objects are in your particular database and to find out where a TTS migration procedure could help.
Another consideration (in favor of export/import in your case) is that one can save a step by simply exporting from 10gR2 and importing into 11g (as outlined in the MOS note 557738.1).
rgds,
John

Posted by John Abraham on August 17, 2010 at 05:53 AM PDT #

Hi Steven,

I would like to use XTTS to migrate an EBS11i 10gR2 DB from solaris to Linux RHEL5. The DB is 800GB and I've already performed OATM.

According to the 10gR2 Admin guide one of the restrictions is that
"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."

Does this mean I'm going to have rejected tablespaces as I've already implemented OATM and I know there are RDBMS and EBS schemas mixed in some of the tablespaces.

Is this the same as 'self contained tablespaces'? - if not could you explain this.

I'm planning on starting this 'investigation' phase very soon and don't really want to revert to a full export/import if this fails as this will be pushing the project timeframes too much.

If I do get into problems how confident are Oracle that they can help resolve all of my issues - a bit vague I know but it is certified.

thanks
Jeremy

Posted by Jeremy Cope on August 23, 2010 at 09:55 AM PDT #

Jeremy,
Yes, it's true that you cannot mix RDBMS and EBS schemas in the same tablespace. We've had issues when including RDBMS schemas like CTXSYS (user) in the transportable set. You will get errors and may instead want to move the RDBMS schemas out and migrate them separately.

Can you let us know, what is the origin of the mixed schemas -- and were they mixed before the OATM migration?

I'm not clear on your reference to the self contained tablespaces, but will check with my engineering team and get back to you.

-Terri

Posted by Terri Noyes on August 24, 2010 at 03:15 AM PDT #

Steven,

We are on 10.2.0.4 RAC database on Linux Itanium 64 bit with 11.5.10.2 ERP installed.

Plan is to migration database tier from Linux Itanium 64 bit to Solaris Sparc 64 bit and then upgrade the database on Solaris from 10.2.0.4 to 11.2.0.1.

Please confirm if this is feasible/certified.

Regards,
Ramneek

Posted by Ramneek Sahota on September 01, 2010 at 03:16 AM PDT #

Hi -
Yes this is feasible. With export/import you can do the DB migration and upgrade in one step. With large DBs you can save time with xtts but you'd have to do the upgrade later separately.
rgds,
John

Posted by John Abraham on September 01, 2010 at 11:32 AM PDT #

You mention on Aug 16, that you can export from 10.2 into 11.1 but the following, last sentance seems to imply this is not possible:

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). You may not downgrade using export/import. "Environments using Oracle8i Enterprise Edition Release 8.1.7, Oracle9i Enterprise Edition Release 2 (9.2.0), or Oracle Database 10g Release 1 (10.1.0) have to be upgraded to at least Oracle Database 11g Release 1 (11.1.0) before you begin the export/import process. "

This seems to say that if you have a 10.1 db you need to update to 11.1 before import to 11.1. How about upgrade to 10.2 then export/import to 11.1?

Posted by Doug Phelps on September 03, 2010 at 12:37 AM PDT #

Hello Doug -
The last sentence is a recommendation for those who are on versions below 10gR2. I agree that on the face of it one should be able to upgrade first to 10gR2 and then do the export/import, but I suppose the question is why one would do that when you could accomplish getting up to 11.1? I suppose you may find that datapump tools with export/import in 10gR2 may speed things up, or as I'm guessing you want to go up to 10gR2 to use XTTS as a possibility.
I'll clarify with our engineering lead on how we can clear up that paragraph.
rgds,
John

Posted by John Abraham on September 03, 2010 at 06:30 AM PDT #

John,

The ERP (11.5.10.2) database planned for migration from 10.2.0.4 RH Itanium 64 to 11.2.0.1 Database Solaris SPARC is around 7 TB in size.

Please confirm which approach is better, imp/exp or Transportable Tablespace for migration.

Additional Info
---------------------
Final aim is to migrate the database and then setup (POC) Golden Gate for Near Real Time Replication with source as 10.2.0.4 RH Linux Itanium 64 bit and target as 11.2.0.1.

Both Source and destination will be RAC databases with split configuration.

Regards,
Ramneek

Posted by Ramneek Sahota on September 04, 2010 at 02:05 PM PDT #

Hello Ramneek -
It is difficult to give a definitive statement of which is better given the specific customer's data, hardware, DBA expertise, tolerance for downtime and tolerance for risk.
I would strongly suggest a poc exercise on your part to investigate the use of export and importing into the 11.2 target db (with the use of optimization like the PARALLEL parameter set to greater than 1) as compared to the use of XTTS + upgrade to 11.2 on the target.
rgds,
John

Posted by John Abraham on September 07, 2010 at 02:48 AM PDT #

I´m in the process of extracting EBS objects from a database where there are lots of non-ebs schemas.
BUT, it´s still 9.2.0.8 - 11.5.9
I'm thinking of using TTS (same platform, of course)
Is there any issue with this ??
How can I be sure everythig EBS needs is moving to the other DB ?

Thanks

Posted by Alejandra on September 16, 2010 at 12:16 AM PDT #

Hi Steven,

We are about to migrate a mutli TB 11i ebs DB from HP to linux using cross platform TT ( or expdp) . We are interested in using goldengate to reduce the downtime for the migration as time is critical. In this case the actual migration to the new platform is using fully supported methods but I can't find anywhere that confirms it will be certified to sync up the new DB using Goldengate before we switch over and run post-clone and migration patches on the new DB. Based on the Goldengate whitepapers I can't see any gotcha's for this. DB is 10.2.0.4 and need will be upgraded to 11g during migration.

Posted by Steve on November 03, 2010 at 06:22 AM PDT #

Hi, Steve,

This question really depends upon the answer to a much-deeper policy question, namely, will the Server Technologies division support Oracle database migrations using GoldenGate?

I don't know the answer to that one yet. The GoldenGate team is working with the Server Technologies division to determine the certification and support policy for that use case. If Server Technologies supports the use of GoldenGate for generic database migrations, then it is likely that we will support that for EBS databases specifically.

Stay tuned; I'll post updates on this blog when I learn more.

Regards,
Steven

Posted by Steven Chan on November 04, 2010 at 04:11 AM PDT #

Hi Steven,

We are migrating EBS 11.5.10.2 from Solaris to AIX. We are on 11.2.0.3 for RDBMS and want to use transportable database feature to perform database migration.

We are having an issue opening the database on the target after the migration - keeping getting a core dump - Illegal OPCode.

We do have an active SR with support but I was wondering if this combination is certified for transportable database?

Any help is greatly appreciated!

Thanks!
Matt

p.s. You are doing a great job sharing your knowledge!

Posted by guest on January 13, 2013 at 09:53 AM PST #

hi Matt -
Yes, the migration from Solaris to AIX (i.e. platforms of the same endian format) should be done with the Transportable Database process using the MOS Note 729309.1 ('Using Transportable Database to migrate Oracle E-Business Suite Release 11i Using Oracle Database 10g Release 2 or 11g Enterprise Edition').
thanks,
John

Posted by John Abraham on January 14, 2013 at 10:03 PM PST #

Hi Steven
I'm testing a database migration from 10.2.0.4 EE (Linux 5 on IBM Power PC) to a 11.2.0.3 EE RAC database (Linux 5 on Intel 86-64). Both databases are with ASM. I want to check with you if some paremeter like COMPATIBLE, needs to be set in 10.2 in the target databaase (basically to avoid some specific issue with the ASM or RDBMS stage).

Thank you and best regards
Adrian

Posted by Adrian Godoy on June 10, 2013 at 06:54 AM PDT #

hi Adrian -
Any compat issues be taken care of in the documentation, patch and scripts we provide as part of the TTS migration from 10gR2 to 11gR2.
Regards,
John

Posted by John Abraham on June 18, 2013 at 11:36 AM 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
19
20
21
24
25
26
27
28
29
30
   
       
Today