Platform migration is the process of moving a database from one
operating-system platform to a different operating-system platform. There are two supported methods for doing this: - 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.
- Use the Transportable Database feature
Transportable Database 10gR2 was certified for the E-Business Suite last year. I'm pleased to announce that our Applications Platforms Group has certified this for the next database release -- Transportable Database 11gR1 -- with the E-Business Suite.
Prerequisites
Database migration across platforms of the same "endian" format (byte ordering) using the Transportable Database (TDB) process is now certified with Oracle Database 11gR1 (11.1.0.7) for Oracle E-Business Suite Releases 11i (11.5.10.2) and 12 (12.0.4 and higher).
Suitable target platforms can be verified by querying the view V$DB_TRANSPORTABLE_PLATFORM using sqlplus (connected as sysdba) on the source platform:
Not the same as Cross-Platform Transportable Tablespaces (XTTS)
Please note that an alternative database technology known as Cross-Platform Transportable Tablespaces (XTTS) to migrate data between platforms of different endian formats is NOT yet certified with Oracle E-Business Suite.
References
Database migration across platforms of the same "endian" format (byte ordering) using the Transportable Database (TDB) process is now certified with Oracle Database 11gR1 (11.1.0.7) for Oracle E-Business Suite Releases 11i (11.5.10.2) and 12 (12.0.4 and higher).
Suitable target platforms can be verified by querying the view V$DB_TRANSPORTABLE_PLATFORM using sqlplus (connected as sysdba) on the source platform:
If the intended target platform appears in the output, Transportable Database can then be used to migrate the database to this target. Otherwise, an alternative such as export/import should be used instead.SQL> select platform_name from v$db_transportable_platform;
Not the same as Cross-Platform Transportable Tablespaces (XTTS)
Please note that an alternative database technology known as Cross-Platform Transportable Tablespaces (XTTS) to migrate data between platforms of different endian formats is NOT yet certified with Oracle E-Business Suite.
References
- Using Transportable Database to migrate Oracle E-Business Suite Release 11i Using Oracle Database 10g Release 2 or 11g Release 1 (Note 729309.1)
- Using Transportable Database to migrate Oracle E-Business Suite Release 12 Using Oracle Database 10g Release 2 or 11g Release 1 (Note 734763.1)
- Platform
Migration using Transportable Database Oracle Database 11g and 10g Release
2 (OTN, PDF 284K)
- Migrating E-Business Suite Release 12 Databases Between Platforms
- Migrating E-Business Suite Release 11i Databases Between Platforms
- Call for Early Adopter Program Participants: Using Cross-Platform Transportable Tablespaces with Apps 11i
- Database 11gR1 Version 11.1.0.7 Certified with EBS 12
- Database 11gR1 Version 11.1.0.7 Certified with EBS 11i
Comments (2)
Hi,
Are these doc published, as I am not able to see them. As this is one off my favourate topic.
Rgds
Sundeep
Posted by Sundeep | October 18, 2009 9:24 AM
Posted on October 18, 2009 09:24
Thanks I was able to view it now, seems some issue with metalink on my Laptop.
Regards
Sundeep
Posted by Sundeep | October 19, 2009 3:59 AM
Posted on October 19, 2009 03:59