Call for Early Adopter Program Participants: Using Cross-Platform Transportable Tablespaces with Apps 11i

As you saw in yesterday's announcement, E-Business Suite environments running the 10gR2 Database users can now use the Transportable Database (TDB) feature to migrate their database between platforms that share the same "endian" format.  But what if you need to migrate a database between platforms that use different endian formats?  That's the case for using Cross-Platform Transportable Tablespaces (XTTS).  It isn't certified with the E-Business Suite yet, but we're now actively seeking customers who might be interested in participating in a short Early Adopter Program for this feature.

What is the Cross-Platform Transportable Tablespace Feature?

Different endian operating system platforms supported by Oracle 10gR2 database Cross Platform Transportable Tablespace feature

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.

Technical Prerequisites

  • Oracle E-Business Suite Release 11i version 11.5.10.2
  • EBS database upgraded to Oracle Database 10g Release 2 according to MetaLink Note 362203.1

Not Supported in this Early Adopter Program

Use in production environments

The nature of this particular feature of the database where data is transferred from one system to another lends itself to significant risk if bugs are found in the process of migrating data. As a result, Early Adopter Program customers are not to use this feature to transfer data for the intention of use in production environments.

Customers are expected to wait till certification is announced before using the latest certified builds to migrate their production environments.

Use of RAC

The use of this feature with Real Application Clusters (RAC) and EBS 11i is currently not supported. While this restriction may be eased in a future build, we would currently like to isolate all issues independent of any that may arise from the use of RAC.

Built-in Limitations of XTTS

These are documented in the Oracle Database Administrator's Guide 10g Release 2 (10.2).

One important limitation outlined in this document that is relevant for EBS is that the source and target databases must have the same character set and national character set.

Early Adopter Program Participation Criteria

  1. Licencing: You are licenced for the Oracle E-Business Suite 11i.
  2. Commitment: You are committed to testing this feature of 10gR2 with 11i.
  3. Expertise: You have strong E-Business Suite 11i DBA and technology stack expertise and are comfortable with debugging and reproducing undocumented issues.
  4. Account Management: You have strong and proactive Oracle account management support
  5. Risk Tolerance: You have reasonable tolerance for unexpected technical issues.
  6. Flexible Schedules: You have flexible deadlines with sufficient time to investigate unexpected technical issues.
  7. Configuration Coverage: You have cross platform testbeds to provide the test coverage across the various 11i supported platforms.
  8. Test Coverage: You are able to perform a reasonably large number of tests across as wide a product range as possible.

What Required of Early Adopter Program Participants?

We make significant investments in ensuring the success of Early Adopter program participants. In return, participants are asked:

  • To file detailed service reports (SRs) via Metalink with well-formed problem descriptions, logs, and error messages
  • To provide feedback on the quality of documentation and patches
  • To provide periodic updates on progress via conference calls and/or status reports
  • To ensure that skilled DBA and systems administration staff are assigned to the project
  • To participate in post-implementation reviews or other working sessions to assess quality and issues encountered
  • To participate in customer reference-related activities such as OracleWorld or Radio Oracle programs after a successful implementation (optional)
  • To upgrade to the latest certified configuration using the latest patches as soon as possible

How Does the Early Adopter Program Work?

  • We deliver an Early Adopter Program build to you
  • You install and configure the Early Adopter Build
  • You report any issues through the Early Adopter Program support process
  • You provide periodic updates on your progress
  • Oracle Development releases documentation updates and new Builds based on ongoing internal certification tests and participant feedback
  • The Early Adopter Program concludes when participant feedback validates all of our program objectives
  • Early Adopter participants upgrade to the latest certified Builds (whose documentation will be published in MetaLink, and scripts made available as a patch) and transition to regular support channels.

Interested in Participating?

Effective immediately, we're accepting nominations for this Early Adopter Program. If you're interested in participating, send me an email with the following information:

  • Your organization's name and location of data center where implementation will take place
  • Your contact information
  • Frequency of Oracle account management meetings
  • Desired timeline for implementation
  • Ability to sustain schedule slippage
  • Your risk tolerance for product defects, incomplete documentation, undocumented steps for unusual configurations
  • Names of Oracle Consulting staff (if any) engaged on-site
  • Operating system platform and version of source and target systems.
  • Oracle E-Business Suite Release 11i Rapid Install release
  • Number of Release 11i environments to be tested with Early Adopter software
  • Products that are targeted for testing, and the extent of testing planned.
  • Number of registered users for test environment
  • Special configuration requirements (e.g. Real Applications Clusters, firewalls, demilitarized zones, software or hardware-based load balancing, multiple application-tier nodes, distributed architectures)
  • Reasons for interest in this Early Adopter program
  • Your understanding of the requirement to upgrade from the Early Adopter configuration to the latest Builds available after the Early Adopter Program concludes

Related Articles

Comments:

Hello Steven,

could you comment using XTTS with OeBS R12?
Is it possible migrate with XTTS whole apps database ?

Regards,

Viacheslav

Posted by Viacheslav on August 05, 2008 at 04:38 PM PDT #

Hello, Viacheslav,

No, XTTS isn't certified for E-Business Suite R12 yet. We're planning to look at that combination after this R11i Early Adopter Program concludes.

Regards,
Steven

Posted by Steven Chan on August 05, 2008 at 11:43 PM PDT #

Hi Steven,

It has been quite a while that EAP was announced. I could not find any further update on the program from internet and hence thought of requesting your POV.

I was considering performing XTTS to migrate platform of a big 11.0 database (in terabytes) to 11i during upgrade to 11i.

After the database is migrated, 11i upgrade patching would be completed. Considering the db size, would this be the right approach ? And would the resulting upgraded instance (11i) be supported by Oracle. (Currently, Oracle does support exp-imp).

Your response would be highly appreciated.

Thanks
Jaydeep

Posted by Jaydeep Nath on August 05, 2009 at 04:07 PM PDT #

Hi, Jaydeep,

As of now (Aug 2009), I'm afraid that we are still investigating NLS-related data corruption issues with XTTS in E-Business Suite environments. Until we resolve those issues, XTTS isn't considered certified with either Oracle E-Business Suite Release 11i or 12.

Export/Import is still the only certified and supported method for moving EBS environments between different-endian platforms.

I don't have firm schedules for the XTTS 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.

Regards,
Steven

Posted by Steven Chan on August 06, 2009 at 04:54 AM PDT #

Hi Steven

Thanks a lot for your reply. Really appreciate that.

Considering that currently the issues are around NLS data corruption, could this approach be considered (from a support perspective) for customers without NLS installations?

A restricted/limited certification for EBS non-NLS installations would immensely help lot of customers.

Thanks
Jaydeep

Posted by Jaydeep Nath on August 09, 2009 at 03:52 PM PDT #

Hi, Jaydeep,

It's unlikely that we'd certify this technology just for non-NLS installations. These types of obscure restrictions tend to be missed or ignored, which means that EBS customers often get themselves into serious trouble.

Nonetheless, I appreciate the suggestion, and will pass it on to our Platforms Engineering Group for their review.

Regards,
Steven

Posted by Steven Chan on August 10, 2009 at 03:04 AM PDT #

Hello Steven,

can you inform us about the status according XTTS and 11i / R12 platform migration support?

Regards Reinder

Posted by Reinder on November 17, 2009 at 12:05 AM PST #

Hello, Reinder,

I'm afraid that we're still stuck on this certification. We've hit issues with NLS-related tables that may or may not get corrupted in the migration process. These have turned out to be very difficult to isolate. So, no news on the actual Generally Available release of this certification yet.

Regards,
Steven

Posted by Steven Chan on November 17, 2009 at 04:02 AM PST #

Steven,

thank you for your reply.

Regards Reinder

Posted by Reinder on November 17, 2009 at 03:53 PM PST #

Steven,

Have we moved forward on certification of XTTS for migrating Ebiz databases. What is the estimated point of time when we could see this being certified ?

Thanks you in advance.

--Danish

Posted by Danish Abrol on December 10, 2009 at 03:25 PM PST #

Hi, Danish,

I'm afraid that this certification is moving along at a much slower pace than any of us had hoped. We're still working on this right now.

I don't have firm schedules for this 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.

Regards,
Steven

Posted by Steven Chan on December 11, 2009 at 05:44 AM PST #

Hi Steven,

Just wondering whether there has been any progress on this now. Is this now certified on 11i?

Thanks

Posted by Ging on January 20, 2010 at 06:47 PM PST #

Hi, Ging,

Yes, there has been some progress on this, but not enough to release this certification yet. I'll post a more-detailed update on the remaining issues as soon as possible.

Regards,
Steven

Posted by Steven Chan on January 21, 2010 at 01:28 AM PST #

Steven.
Can you please update on certification- XTTS for 11i. Our production migration is planned in March-2011 from Solaris (SUN OS 5.8) to RHEL 5.6; Wondering if XTTS will be officially certified by that time or we should plan for Datapump.
Regards,
Ganesan.

Posted by Ganesan Srirangan on June 28, 2010 at 10:48 PM PDT #

Hello, Ganesan,

This was certified a few months ago. See:

10gR2 Transportable Tablespaces Certified for EBS 11i
http://blogs.oracle.com/stevenChan/2010/04/10gr2_xtts_ebs11i.html

Regards,
Steven

Posted by Steven Chan on June 29, 2010 at 01:30 AM PDT #

The note doesn't have details about self contain tablespace due to Oracle Applications Tablespace Model (OATM) concept in 11.5.10.2. Following 4 Tablespaces are not self contained:

APPS_TS_QUEUES
APPS_TS_SUMMARY
APPS_TS_TX_DATA
APPS_TS_TX_IDX

which is expected due to OATM.
What should we do about it? Due to this limitation, the step 8 Export the transportable tablespace set of of Section 3: Export source database objects of Cross Platform Transportable Tablespaces on 11i with 10gR2 [ID 454574.1], is failing with error "ORA-29341: The transportable set is not self-contained"

Posted by Gaurav Shankhdhar on August 03, 2010 at 03:22 PM PDT #

Gaurav,

I'd like to get someone to help you with this. Please log a formal Service Request via My Oracle Support (formerly Metalink) to get one of our specialists engaged.

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 August 04, 2010 at 01:54 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
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today