[email protected]
(214) 310-1020
Why Are So Many Businesses Upgrading Oracle E-Business Suite to 19c?
April 21, 2022 by Srikanth

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:

[tm_image align=”center” image=”3556″]

Figure 1: Lifetime Support Timeline

[tm_spacer size=”lg:30″]

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

[tm_image align=”center” custom_border_color=”#f3f5f5″ image=”3557″ lg_spacing=”border_top:2;border_right:2;border_bottom:2;border_left:2″]

Figure 2: Database Portfolio Basics

[tm_spacer size=”lg:30″]
[tm_spacer size=”lg:30″][tm_image action=”custom_link” align=”center” custom_border_color=”#f3f5f5″ image=”5331″ lg_spacing=”border_top:2;border_right:2;border_bottom:2;border_left:2″ custom_link=”url:https%3A%2F%2Fwww.red-gate.com%2Fsimple-talk%2Fdatabases%2Foracle-databases%2Fgetting-started-with-oracle-database-12c-multitenant-architecture%2F”]

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
[tm_spacer size=”lg:30″][tm_image action=”custom_link” align=”center” custom_border_color=”#f3f5f5″ image=”3560″ lg_spacing=”border_top:2;border_right:2;border_bottom:2;border_left:2″ custom_link=”url:https%3A%2F%2Fwww.red-gate.com%2Fsimple-talk%2Fdatabases%2Foracle-databases%2Fgetting-started-with-oracle-database-12c-multitenant-architecture%2F”]

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.
[tm_spacer size=”lg:30″]

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:

[tm_image action=”custom_link” align=”center” custom_border_color=”#f3f5f5″ image=”3561″ lg_spacing=”border_top:2;border_right:2;border_bottom:2;border_left:2″ custom_link=”url:https%3A%2F%2Fwww.red-gate.com%2Fsimple-talk%2Fdatabases%2Foracle-databases%2Fgetting-started-with-oracle-database-12c-multitenant-architecture%2F”]

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.

[tm_spacer size=”lg:30″]

Share: LinkedIn · X