Skip to content

Oracle EBS 11i to R12.1.3 Upgrade

Oracle EBS 11i to R2.1.3 upgrade can be a lengthy process and requires different teams to work togather for a successful execution.

The idea behind creating this upgrade guide was to put down all the TECHNICAL steps at one place. There are many functional steps that are involved in EBS 11i to R2.1.3 upgrade, which are NOT included in this guide. As such this guide is good starting point for an Oracle Apps DBA to get details on steps involved in the upgrade process. Going through all the related Oracle documents is essential for planning a production upgrade to R12.1.3 as different 11i setups may have different pre-requirements to be met before upgrade to R12.1.3.

This upgrade guide has been divided into below five parts:

1) Install Fresh EBS 11i on Linux 5 32 Bit (PART 1 in “11i to R12.1.3 upgrade” series)
2) Upgrade database 9.2.0.6 to 11.2.0.4 in 11i (PART 2 in “11i to R12.1.3 upgrade” series)
3) 11i Split configuration- Move 11g Database to Linux 6 64Bit (PART 3 in “11i to R12.1.3 upgrade” series)
4) Upgrade 11i TO R12.1.1 (PART 4 in “11i to R12.1.3 upgrade” series)
5) Upgrade R12.1.1 To R12.1.3 (PART 5 in “11i to R12.1.3 upgrade” series)

Overview:

Below is the overview of what each part accomplish:

1) Install Fresh EBS 11i on Linux 5 32 Bit (PART 1 in “11i to R12.1.3 upgrade” series)

– Create virtual machine with Linux 32 Bit (64 Bit not supported)
– Install 11i with Fresh or Vision database. We chose fresh database just to save disk space.

End Result : 11i single node (both database 9.2.0.8 and application on same 32 Bit node)

 

2) Upgrade database 9.2.0.6 to 11.2.0.4 in 11i (PART 2 in “11i to R12.1.3 upgrade” series)

– Upgrade database from 9.2.0.6 to 9.2.0.8 and then to 11.2.0.4.
– Apply all interoperability patches for EBS 11i to work with 11.2.0.4 database.
– Upgrade JDK/JRE to supported version.

End Result : 11i single node (both database 11.2.0.4 and application on same 32 Bit node)

 

3) 11i Split configuration- Move 11g Database to Linux 6 64Bit (PART 3 in “11i to R12.1.3 upgrade” series)

– Configure another Linux machine with 64 Bit OS.
– Install 64 Bit Database 11.2.0.4 software on the new 64 Bit Linux machine.
– Move 11i database from old Linux 32-bit to new Linux-64 bit machine and attach 11i application to new 64 Bit database.

End Result : 11i Multi node (database 11.2.0.4 on 64 Bit Linux machine and application on same 32 Bit Linux machine)

 

4) Upgrade 11i TO R12.1.1 (PART 4 in “11i to R12.1.3 upgrade” series)

– Prepare 11i database for upgrade (configuration, applying patches etc).
– Install R12.1.1 upgrade filesystem on the same 64 Bit Linus machine that we configured earlier and where our database currently run.
– Configure R12.1.1 application with existing 11.2.0.4 64 Bit database.

End Result : R12.1.1 single node (both database 11.2.0.4 and application on same 64 Bit node)

 

5) Upgrade R12.1.1 To R12.1.3 (PART 5 in “11i to R12.1.3 upgrade” series)

– Upgrade all ORACLE_HOMEs (database, forms 10.1.2, web 10.1.3)
– Upgrade R12.1.1 application to R12.1.3 on Linux 64 Bit machine.

End Result : R12.1.3 single node (both database 11.2.0.4 and application on same 64 Bit node)

Infrastructure used:

Virtualization:

Oracle Virtual Box has been used to create Linux Virtual machine.

Operating System:

a) OEL 5.6 32 Bit has been used for EBS 11i setup. Note that 64 Bit OS is not supported for EBS 11i.

b) OEL 6.5 64 Bit has been used for upgraded EBS R12.1.3 system. So during the upgrade process we also transferred our application/database from 32 Bit to 64 Bit OS.

RAM:

Total RAM for the Host machine is 16 GB. We allocated around 8-10 GB to our Linux Machine and it worked OK.

CPUs:

Our Host Machine is Quad-Core and we allocated 2 CPU to  our Linux Machine.

Hard Disk:

We used 512 GB Solid State Drive (SSD). Using SSD over HDD really provides performance improvement.

 

References:

Many Oracle Guides and Note IDs were referred all through the upgrade process. You will need My Oracle Support(MOS) credentials to access much of this material.

11i docs> http://docs.oracle.com/cd/B25516_18/current/html/docset.html
http://www.oracle.com/technetwork/documentation/p19-relnotes-176790.pdf
http://docs.oracle.com/cd/B53825_01/current/acrobat/121upgrade.pdf
https://docs.oracle.com/cd/E11882_01/server.112/e10839/appc_linux.htm#UNXAR337
Migrating and upgrading EBS 11i to EBS 12.1.3 on a x86-64 bit ULN server using Notes 1377213.1
Interesting Documents Concerning E-Business Suite 11i to R12 Upgrades (Doc ID 850008.1)
Note 761564.1 – ‘Oracle Applications Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86’
471566.1 Migrating Oracle E-Business Suite R12 from Linux 32-bit to Linux 64-bit
Oracle Applications Upgrade Guide : Release 11i to Release 12.1.1
Note 269.1 – ‘Upgrade Advisor: E-Business Suite Technology Stack Upgrade from 11.5.10.2 to 12.1.3’
Note 250.1 – ‘Oracle Support Upgrade Advisors’
Note 752619.1 – ‘Oracle E-Business Suite Release 12.1.1 Maintenance Pack Installation Instructions’
Note 374398.1 – ‘Preparing Custom Development for Next Oracle E-Business Suite Release’
Note 461705.1 – ‘Oracle E-Business Suite Upgrade Center – Home’
Note 761570.1 – ‘Database Preparation Guidelines for an E-Business Suite Release 12.1.1 Upgrade’
Note 807319.1 – ‘Oracle E-Business Suite Release 12.1 Transfer of Information (TOI) Online Training’
Note 780989.1 – ‘R12: Upgrade vs. Reimplementation (Financials)’
Note 987516.1 – ‘Planning Your Oracle E-Business Suite Upgrade from Release 11i to Release 12.1’
Note 1448102.1 – ‘Oracle E-Business Suite Pre-Install Patches Report [Video]’
1. Oracle ATG Family Pack H RUP7 (ATG_PF.H RUP 7) Installation [ID 783600.1]
2. Database Preparation Guidelines for an E-Business Suite Release 12.1.1 Upgrade [ID 761570.1]
3. Interoperability Notes Oracle EBS 11i with Oracle Database 11gR2 (11.2.0) [ID 881505.1]
4. Oracle® E-Business Suite Upgrade Guide Release 11i to 12.1.1 [ Part No. E16342-04 ]
5. Oracle Applications Release Notes, Release 12.1.1 [ID 798258.1]
6. Upgrading to the Latest OracleAS 10g 10.1.3.x Patch Set in Oracle E-Business Suite Release 12 [ID 454811.1]
R11i : About Oracle Applications DBA Minipack 11i.AD.I (Doc ID 233044.1)
R11i : About Oracle Applications Technology 11i.ATG_PF.H.delta.7 (RUP 7) (Doc ID 783600.1)
Release 11i Use of Multiple Organizations in Oracle Applications (OracleMetaLink Document 210193.1).
WebADI – About Web Applications Desktop Integrator Mini-pack 11i.BNE.D (Doc ID 287080.1)
About Oracle Report Manager Minipack 11i.H (FRM.H) (Doc ID 378338.1)
About Oracle Report Manager Minipack 11i.G (FRM.G) (Doc ID 280631.1)
Upgrading Oracle XML Parser v9.0.4 with Oracle Applications 11i (Doc ID 271148.1)
Database Initialization Parameters for Oracle Applications Release 11i (Doc ID 216205.1)
Ora-01408 Error Upgrading from 9i to 11g using Dbua (and manual upgrade) [ID 737400.1]
Note:401561.1 – Using J2SE Version 6 with Oracle E-Business Suite 11i
Deploying Sun JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 11i (Note 290807.1)
Upgrading Developer 6i with Oracle E-Business Suite 11i (Note 125767.1)
Migrating Oracle E-Business Suite R12 from Linux 32-bit to Linux 64-bit (Note 471566.1)
Applications Release 12 Upgrade Sizing and Best Practices (Doc ID: 399362.1)
How To Find Out If OLAP Is Being Used (Doc ID 739032.1)
Database Initialization Parameters for Oracle Applications Release 12 (Doc ID: 396009.1).
Applications Multiple Organizations Implementation Guide, Use of Multiple Organizations (Multi-Org) in Release 11i (Doc ID: 210193.1),
MOAC in Oracle Purchasing (Doc ID: 404800.1).
Improved Convert to Multi-Org Process In Oracle Applications 11i (Doc ID 208267.1)
396351.1 Switching from Single-Org To Multi-Org
392374.1 Any Multi Org problem read This or even before running convert to Multi org
FAQ – Multiple Organizations Architechure (Multi-Org) [ID 165042.1]
How Do You Setup a New Organization and Connect It to a New AP Responsibility (Doc ID 181790.1)
How to setup a new Organization and Set of Books for a Payables Responsibility (Doc ID 248088.1)
ORA-20001: FND-ORG_ID PROFILE CANNOT READ when starting Apps 11i (Doc ID 400840.1)
Things to Know About Linux (Doc ID 265262.1)
Oracle Applications Release 11i Information Center (Doc ID 112552.1)
R11i / R12 : Planning Your Oracle E-Business Suite (EBS) Upgrade from Release 11i to Release 12 (Doc ID 1406960.1)
Database Preparation Guidelines for an E-Business Suite Release 12.1 Upgrade (Doc ID 761570.1)
Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Linux x86-64 (Doc ID 761566.1)
Oracle Applications Installation Update Notes, Release 11i (11.5.10.2) (Doc ID 316806.1)
Migrating Oracle E-Business Suite R12 from Linux 32-bit to Linux 64-bit (Note 471566.1)
*** Using Oracle Applications with a Split Configuration Database Tier on Oracle 11g Release 2 (946413.1)
Migrating OLAP From 32 Bits to 64 Bits or Across Platforms (Doc ID 352306.1)
Note: 216550.1 – Oracle Applications Release 11i with Oracle9i Release 2 (9.2.0)
Database Documentation Resources for EBS Release 11i and R12 [ID 1072409.1]
Upgrading Developer 6i with Oracle Applications 11i (Doc ID 125767.1)
Bug 6338981 : FORMS/REPORTS 6I PATCH 19 (6194129) README NOT ACCESSIBLE
881505.1 — Interoperability Notes for 11i with 11gr2(11.2.0.4)
1058763.1 — Interoperability Notes for R12 with 11gr2(11.2.0.3)

[Post Views: 8095]

Brijesh Gogia

I’m an experienced Oracle Applications DBA with more than a decade of full-time DBA experience. I have gained a wide knowledge of the Oracle software stack and have worked on several big projects for multi-national companies. I enjoy working with the leading-edge technology and have passion for database performance and stability. Thankfully my work allows me time for researching new technologies (and to write about them).
  
You can connect with me on LinkedIn.

Be First to Comment

Leave a Reply

Required fields are marked *

error: Alert: Content is protected !!