Select Page

Planning Tips and Best Practices for Upgrading to EBS 12.2

Author: Vivek Tiwari | | January 3, 2017

Thinking of upgrading to Oracle E-Business Suite (EBS) 12.2? Before you do, we suggest you prepare by considering these planning tips first. Follow with the best practices to ensure a smooth installation with minimized downtime. For a more in-depth look at the new Oracle EBS 12.2, download our whitepaper, EBS 12.2 Upgrade: A Managed Services Approach. 

Use key reference materials to finalize your upgrade path

The most crucial step in planning an upgrade is to start with the Oracle EBS 12.2 upgrade guides. There are multiple upgrade paths available for the earlier versions of Oracle EBS (see illustration below).


Identify the upgrade impact on supporting applications

The minimum required database version for EBS 12.2 is and the recommended version EBS 12.2 works only with 64-bit operating systems and the following operating systems: OEL/RHEL 5 and 6, and Oracle VM-minimum version 3.2

Prepare for architectural changes


Oracle E-Business Suite Architecture in 12.2 has major changes in the application tier with multiple file systems and WebLogic components, including:

  1. Forms and Reports Services
  2. HTML-based apps
  3. Oracle JDeveloper 10.1.2

Understand your upgrade process

  • All EBS patches for Release 12.2 and beyond are online patches
  • The new DUAL FILE System enables online patching of code and the Database Editioning  feature introduced with 11gR2
  • Cross Edition Triggers and Database Editioning views enable online patching of  tables

Best upgrade practices

1. Upgrade overview

Before undertaking the upgrade, it is important that you understand the process, potential upgrade paths, and your reasons for considering an upgrade. Upgrade downtime can be drastically reduced through proper planning, preparation, and testing of upgrade techniques and procedures.

2. Planning and Preparation

The upgrade’s success depends on how explicit the upgrade plan is. Pre-production testing and validation on a comparable system prior to the actual upgrade is key to minimizing unforeseen contingencies.


  • Platform migration should be planned as a separate downtime.
  • Plan for a database upgrade as a separate downtime and upgrade the RDBMS version to the latest certified version for the current APPS level.
  • Manage data volumes by purging old and/or transient data. Use OAM to configure, initiate, and monitor the purge program.


  • Identify required patches/tasks then prepare a complete list of pre- and post-patches and recommended code levels.
  • Manage customizations by checking custom code, then identify and fix custom code to comply with online patching standards.
  • Remove unnecessary workloads/overheads.
  • On the database tier, gather the necessary statistics such as schema, dictionary, and fixed stats. Properly size SGA/PGA memory then upgrade and initialize parameters.
  • On the application tier, carry out the upgrade and autoconfig.

Supported upgrade paths and upgrade resources

Customers running Oracle EBS 10.7, 11.0.3 and 11.5.x will have full support including access to newly created patches and fixes and upgrade scripts to the most current Oracle E-Business Suite software releases (see illustration below).


Pre-upgrade and post-upgrade processes

  • Prepare the database by upgrading to the minimum required version ( or the latest certified version (, then migrate db.platform.
  • Use Rapid Install (RI) for the target platform to lay down 12.2.0 code and tech stack and create the dual file system.
  • Upgrade to 12.2.0.
  • Enable online patching.
  • Upgrade to 12.2.2.X then apply latest EBS RUP patches.
  • Apply the following patches as an online patch: 12.2+12.2.X NLS.
  • Deploy apps tier custom code and external integrations per integration-specific codes.
  • Configure system to production capacity-per-sizing analysis, add nodes (horizontal scale-up), then add managed servers (vertical scale-up).

If you would like to learn more about planning, preparation and testing for the upgrade to EBS 12.2 please contact Datavail today. With more than 600 database administrators worldwide, Datavail is the largest database services provider in North America. As a reliable provider of 24×7 managed services for applications, BI/Analytics, and databases, Datavail can support your organization, regardless of the build you’ve selected.

How to Solve the Oracle Error ORA-12154: TNS:could not resolve the connect identifier specified

The “ORA-12154: TNS Oracle error message is very common for database administrators. Learn how to diagnose & resolve this common issue here today.

Vijay Muthu | February 4, 2021

Data Types: The Importance of Choosing the Correct Data Type

Most DBAs have struggled with the pros and cons of choosing one data type over another. This blog post discusses different situations.

Craig Mullins | October 11, 2017

How to Recover a Table from an Oracle 12c RMAN Backup

Our database experts explain how to recover and restore a table from an Oracle 12c RMAN Backup with this step-by-step blog. Read more.

Megan Elphingstone | February 2, 2017

Subscribe to Our Blog

Never miss a post! Stay up to date with the latest database, application and analytics tips and news. Delivered in a handy bi-weekly update straight to your inbox. You can unsubscribe at any time.

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.


Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.