Migrating E-Business Suite Release 12 Databases Between Platforms

Boy, we're just smoking, now.  You can always tell that OpenWorld is heating up when all of these new certifications come pouring out of our labs.  Here's another certification that complements our previous announcement for Oracle E-Business Suite Release 11i:  Our Applications Platforms Group has announced that database migration across platforms of the same "endian" format (byte ordering) using the Transportable Database process is now certified with Oracle E-Business Suite Release 12 using 10gR2.

Platform migration is the process of moving a database from one operating-system platform to a different operating-system platform. The supported way to do this prior to Oracle Database 10g Release 2 was 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, using Transportable Database and following the Maximum Availability Architecture (MAA) best practices in the whitepaper linked below, you can expect a 50% or greater reduction in the time it takes to complete a platform migration when compared to traditional unload/load methods.

Prerequisites

The minimum 10gR2 Database version required is 10.2.0.3 on both the source and target platforms.

Suitable 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 appears in the output, Transportable Database can be used to migrate the database. Otherwise, an alternative such as export/import should be used instead.

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.  We're running an Early Adopter Program (at full capacity) for that technology right now.  I don't have any projected schedules for that 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.

References

Related Articles

Comments:

Hi,

I want to clone EBS(12.1.2) across the platform.
Is it possible?

【From】
AP: RHEL 5.3 (64bit)
DB: AIX 6.1 (64bit)

【To】
AP: RHEL 5.3 (64bit)
DB: RHEL or OEL (64bit)

If it's possible, would you advise me the guide (Note, Manual etc...) ?

regards

Posted by Yusuke Kodama on June 17, 2010 at 07:27 PM PDT #

Hello -
It would be useful to think of these two as separate migrations, and to tackle the DB migration first.
Going from AIX to RHEL/OEL would be done using the traditional export/import (Doc 454616.1 for 10gR2, 741818.1 for 11gR1/R2 ) using datapump. We are still working on the certification of XTTS with R12, so that unfortunately would not be an option at this point.
After the DB migration, you can then simply clone your application tier from the source RHEL 5.3 (64bit) to the target RHEL 5.3 (64bit) following the Rapid Clone documents (Note 799735.1).
rgds,
John

Posted by John A on June 22, 2010 at 07:45 AM PDT #

Hi, John

Thank you very much for replying.
I'll consider the migration with recommended solution.

I have an another question.
Is it certified that using XTTS like following ?

【From】-> E-Business Suite
AP: RHEL 5.3 (64bit)
DB: AIX 6.1 (64bit)

【To】-> ONLY DB
DB: RHEL or OEL (64bit)
※It will be used for DR.

regards.

Yusuke Kodama

Posted by Yusuke Kodama on June 22, 2010 at 12:27 PM PDT #

Hello -
I believe what you are proposing is still a DB migration from AIX 6 to RHEL/OEL.
As noted, XTTS is a db migration process currently only supported for 11i with 10gR2 of the Database.
rgds,
John

Posted by John A on June 23, 2010 at 03:09 AM PDT #

Hi
Is it supported now for db conversion between different endian formats ?

- Kumar

Posted by Kumar on January 04, 2011 at 10:17 AM PST #

Hi, Kumar,

Not yet. I've forwarded your request on to our EBS Platforms Engineering team so that they can factor that into their prioritization plans for this certification.

Regards,
Steven

Posted by Steven Chan on January 04, 2011 at 01:53 PM PST #

Hi,

Do you know if migration from little to big endian using transportable database is support on R12?

Many thanks

Mike

Posted by guest on November 08, 2011 at 02:21 AM PST #

Mike,

The Transportable Database feature supports only same-endian migrations.

If you're moving between different endian platforms, you need to use Transportable Tablespaces instead. Transportable Tablespaces are supported with EBS 12 on 11gR2. See:

Database Migration using 11gR2 Transportable Tablespaces Now Certified for EBS 12 (Oracle E-Business Suite Technology)
https://blogs.oracle.com/stevenChan/entry/database_migration_using_11gr2_transportable

Regards,
Steven

Posted by Steven Chan on November 08, 2011 at 03:45 AM PST #

Can we use expdp and impdp for cross platform migration from Linux Itanium to AIX 7 Power system.

source system : 12.1.3 with 10.2.0.4 DB (Linux Itanium)
target system : 12.1.3 with 11.2.0.2 DB (AIX 7.1 Power system)

Also for Transportable tablespace is it mandatory we should have same DB version on both sides.

Posted by guest on April 14, 2012 at 09:52 PM PDT #

Yes, you can - export/import with datapump (i.e. expdp and impdp) is the generic and traditional way of moving data between platforms regardless of endian format. Additionally, one can also export from 10gR2 and import into 11gR2.
The requirement for 11gR2 Transportable Tablespaces with EBS R12 is that the source be at least 11gR1 (see MOS Note 1311487.1).
Regards,
John

Posted by John Abraham on April 16, 2012 at 09:24 AM PDT #

Hi,
I have two tier environment, i.e my Apps and DB tiers are on separate nodes. The OS on both machines is linux. Now just want to migrate my database from linux to AIX and want to connect my existing APPS tier to the new DB tier. Can any one help me in this regard.

Regards,
Nadir

Posted by guest on November 26, 2013 at 01:22 AM PST #

Hi, Nadir,

You can use the documents listed above to do that. If you have questions about specific steps in those documents, you can log Service Requests with Oracle Support for additional guidance.

Good luck with your migration.

Regards,
Steven

Posted by Steven Chan on November 26, 2013 at 02:06 PM PST #

Hi All

We are on Oracle Application R12.1 and we need to upgrade application server from AIX 6.1 to AIX 7.1

Could you please let me know if there are some expected changes in code like custom shell scripts/Java Classes. Is there any documentation available to this upgrade?

Thanks,
Shashank

Posted by guest on May 19, 2014 at 09:29 AM PDT #

Hi, Shashank,

I'm not sure what you mean by "changes in code like custom shell scripts." If you have custom shell scripts, you would be the best person to determine whether there are any changes.

See this article for links to our EBS 12 + AIX 7 installation documentation:

Oracle E-Business Suite Release 12 now Certified on AIX 7
https://blogs.oracle.com/stevenChan/entry/oracle_e_business_suite_release

Regards,
Steven

Posted by Steven Chan on May 23, 2014 at 01:39 PM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Search

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