Why Are So Many Businesses Upgrading Oracle E-Business Suite to 19c?

Why Are So Many Businesses Upgrading Oracle E-Business Suite to 19c?

Digital Transformation

Why Are So Many Businesses Upgrading Oracle E-Business Suite to 19c?

Since the Oracle E-Business Suite (EBS) upgrade to 19c was released, businesses have been busy upgrading their EBS databases. The latest upgrade provides a multi-tenant architecture that allows for database consolidation and data/metadata manageability.

The Figure 1 outlines the lifetime support policy and plan:

Figure-1_Lifetime-Support-Timeline

Figure 1: Lifetime Support Timeline

To understand the 19c upgrade process, first we need to understand the basics of EBS database portfolio – shown in the Figure 2: Database Portfolio Basics and Figure 3: Pluggable Database

Figure-2-Database-Portfolio-Basics-e1649845896704

Figure 2: Database Portfolio Basics

Pluggable Database

Figure 3: Pluggable Database | Source: Pluggable Database Image via Redgate Hub (https://www.red-gate.com/simple-talk/databases/oracle-databases/getting-started-with-oracle-database-12c-multitenant-architecture/)

 

Key Highlights of Upgrading to 19c:

  • Oracle EBS supports single container database (CDB) with a single pluggable database (PDB)
  • Any database version below 12c is considered a non-CDB database and 11g is a non-CDB database
  • CDB databases are available for Cloud 12c and onward
  • 19c database requires OEL 7
  • Cloud databases hold structure as GRID Home and database Home
Figures-4-and-5-from-left-to-right-Oracle-Grid-Home-and-Database-Home

Figures 4 and 5 (from left to right): Oracle Grid Home and Database Home

The diagram shows 2 oracle home elements– one is Grid home on the left and oracle home on the right, in line with last bullet point.

Upgrading the Database on OCI

There are various approaches for upgrading the database, including migrating, and upgrading or performing an “in-place” upgrade, as shown in the diagram below:

Figure-6-Performing-an-In-Place-Upgrade

Figure 6: Performing an In-Place Upgrade

For a non-CDB database, an additional step is required to convert the database into a PDB. This is done by creating a descriptor file and restarting the database. Additionally, as depicted in the diagram above, a virtual machine database with a 12c database requires an in-place upgrade and a PAR-URL for Oracle software.

Leave your thought here

Your email address will not be published. Required fields are marked *

Select the fields to be shown. Others will be hidden. Drag and drop to rearrange the order.
  • Image
  • SKU
  • Rating
  • Price
  • Stock
  • Availability
  • Add to cart
  • Description
  • Content
  • Weight
  • Dimensions
  • Additional information
  • Attributes
  • Custom attributes
  • Custom fields
Click outside to hide the comparison bar
Compare