Intelligent Process Automation: A Strategy to Combine Synergistic Digital Capabilities
April 4, 202210 Vital Things to Consider When Migrating an Oracle EBS(R12) Environment
April 21, 2022
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
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
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
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
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.