Have You Used 10gR2 Transportable Tablespaces with EBS 11i?

We are soliciting your feedback on our recently announced E-Business Suite Release 11i + 10gR2 Cross Platform Transportable Tablespaces (XTTS) database migration process.

XTTS_Supported_Platforms2.png

We know that quite a few of you have requested this and are curious as to how you might be faring with it. For those customers who have downloaded the controlled patch (6158038) required for this migration of the EBS database, we would love to hear your answers to the following questions:

  1. What is the size of the E-Business Suite Database you've migrated or plan to migrate?
  2. What were the source and target platforms for this database migration (e.g. Linux Itanium to Oracle Solaris on SPARC)?
  3. Where are you currently at in your migration?
    • Not started on migration
    • Migration in progress following MOS Doc 454574.1
    • User testing of migrated system in progress
    • Completed testing and awaiting production migration
    • Live on migrated system in production
  4. Have you filed any SRs as part of your testing of your migration? And if so, what were the SR numbers?
  5. Have you analyzed the time savings when using XTTS vs export/import? If so, what were the savings?
Feel free to post a comment here, or if this information is sensitive, please drop me a line directly.

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.

Related Articles

The preceding is intended to outline our general product direction.  It is intended for information purposes only, and may not be incorporated into any contract.   It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decision.  The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle.


Comments:

We are in the start of our HP-UX 11.11 to OEL 5 migration of our E-Bus. 11.5.10.2 instance. The database is currently RDBMS 10.1.0.5. The database is currently about 620gb in size.
We have gone thru one cycle of the migration with first upgrade db to 10.2.0.4, export using expdp, then import into 10.2.0.4 instance in the Linux environment. The whole export/import process is taking 40+ hours to complete. This is currently outside the window of time we can shutdown for the migration, so we want to look at the XXTS method.

The only issue I see so far is the RDBMS objects in the apps tablespaces, specifically CTXSYS,DBSNMP,MDDATA,ORDSYS,ORDPLUGINS and SI_INFORMTN_SCHEMA.

Can these just be droppped before the process starts and recreated in the Linux environment as part of the create database process?

Posted by Doug Phelps on September 02, 2010 at 11:57 PM PDT #

Hi,
We have recently migrated our EBSuite 11.5.10.2 production (after we've done 3 test instances) from HP-UX 11.11 to RHEL 5 on the Mainframe -- zLinux of size 430GB. We used Transportable Database to convert the Tablespaces with undo segments -- SYSTEM and UNDO tablespace to convert from HP-UX to zLinux, then copied the datafiles for the other tablespaces and then transformed them to create the control files and the new database. We finished this procedure in less than 4 hours. We did not file any SR, the Notes to follow were very informative as well as detailed.

Posted by Vernnie Creencia on September 05, 2010 at 07:09 PM PDT #

Hi, Vernnie,

Thanks for sharing your experiences here. Glad to hear that that worked well for you.

Regards,
Steven

Posted by Steven Chan on September 07, 2010 at 02:01 AM PDT #

What is the size of the E-Business Suite Database you've migrated or plan to migrate?

400-500GB

What were the source and target platforms for this database migration (e.g. Linux Itanium to Oracle Solaris on SPARC)?

We are migration from HPUX 11.11 to Linux Redhat 5.3

Where are you currently at in your migration?
User testing of migrated system in progress

Have you filed any SRs as part of your testing of your migration?
Yes, there are a few impdp/expdp problem with Oracle 10.2.0.4.

Have you analyzed the time savings when using XTTS vs export/import? If so, what were the savings?

We are using the expdp/impdp migration strategy. The expdp and impdp are taking 4 and 9 hours respectively.

Posted by Teck on September 07, 2010 at 06:42 AM PDT #

Can I use this to migarte a DB from single instance to RAC instance in one step or Do I need to use it form single to single insatnce and then enable RAC for EBS 11i

Posted by Sumanta Mazumder on September 29, 2010 at 12:36 PM PDT #

Hello Sumanta -
It should be possible, but the current EBS doc on XTTS shows a single inst -> single inst migration, so as it stands now, you have to do this in 2 steps.
There may be a paper in the future that describes a single inst -> RAC migration as part of a migration to Exadata but don't have an ETA for that yet..
rgds,
John

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

Hi,

I'm currently testing XTTS with a 700GB database 10.2.0.3 on Sun Solaris (sparc) migrating to RHEL 5 and have encountered some frustrating problems.

I'm following document 454574.1 Cross Platform Transportable Tablespaces on 11i with 10gR2.

1. Export the transportable tablespace set - expdp crashed after 3 hours getting metadata for ctx domain indexes. Found a direct hit note 781638.1 patch (6991626)was supposed to fix it but it didn't. Oracle said this is a new bug so need to upgrade to supported version, so I upgraded to 10.2.0.5. expdp doesn't crash now but doesn't finish either - killed after 5 hours - as a workaround I excluded all indexes from expdp and will use exp/ipm for these. Lost several days because of this.

2. The oracle documentation is very brief - running impdp to import misceallaeous data - every object has a warning message - i guess this is because the objects haven't actually been imported yet as that's in the next step - but there's no mention of this in any oracle documentation I can find - note 454574.1 doesn't even say to check the log file??

Anyone encountered similar problems and/or have some tips they would like share - I'm sure the import is going to raise some challenges!

Thanks
Jeremy Cope
Senior DBA

Posted by Jeremy Cope on September 30, 2010 at 07:07 AM PDT #

Hi,

Continuing from my previous post. I'm running the import now and have had further problems as expected.

I'm migrating 11.5.10.2/10.2 apps DB (700GB) from Solaris 5.10 to RHEL 5 using note 454574.1 Cross Platform Transportable Tablespaces on 11i with 10gR2.

I had a problem exporting domain indexes which Oracle said was a new bug - so I excluded the indexes from the export - tried to use exclude=index:like... but this failed, according to Oracle another bug so had to exclude all indexes and got the export to complete sucessfully.

The import crashed (ORA-00600: internal error code, arguments: [ktssinseg3], [400]) but all the tablespaces were created - Oracle have yet to come back with a fix on this. I tried rerunning the import, thinking that it would continue where it left off - but I got an errror that the tablespaces already exist - which they do - so I removed the transport_datafiles parameter but then the import failed saying it's incompatible with the export dump - stalemate! Unfortunately I can't drop the tablespaces and try the import again as I've made them read-write so I can create the indexes - so I think my only option is to copy the files over from the source server and start the import again - but I may hit the same problem as before with the import crashing...

I believe my options are:
1. upgrade the source DB to 11g - this may help to prevent errors encountered so far - and rerun the export/import using XTTS.

or

2. run the traditional full export/import using data pump of course - but I'm reluctant to do this because of the size of the DB and the time the import will take.

What I might do is run both options in parallel, I just need to find some more disk.

if anyone has any advice on using XTTS for an apps DB migration - success stories or otherwise would be appreciated - I'm beginning to think this is a bad choice.

Regards
Jeremy

Posted by Jeremy Cope on October 06, 2010 at 06:52 AM PDT #

Hello Jeremy -
Option 1 above is not going to work as our current scripts and methodology only apply to 11i/10gR2 - a number of teams are working on certifying 11g with XTTS for EBS but it more than likely will be only for R12 with 11gR2. I can't, for rev rec reasons, provide a specific date as to when this might be available unfortunately.
Export/import with Datapump may not be that much slower than XTTS for the size of the DB you have, btw - you can try it with the PARALLEL option to see if things speed up, and also use the METRICS=y to look at the type of objects for an idea of what your time savings might be (since XTTS still requires metadata to be export/imported).
With regards to your ORA-600 issue, did the Support analyst provide a specific bug number to you?
rgds,
John

Posted by John Abraham on October 07, 2010 at 08:51 AM PDT #

Hi John,

thanks for that feedback.

The support analyst has not come back with a bug number on the ORA-600.

I assumed export/import with Datapump would be slower than XTTS but I'm now testing it given the problems with the latter.

thnks
Jeremy

Posted by Jeremy Cope on October 10, 2010 at 10:07 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