Oracle EBS R12.2 with 19c Database - Overview

Oracle Database 19.3 was certified with Oracle E-Business Suite Release 12.2 on-premises.

As part of upgrading Database to 19c, we will convert EBS database to the CDB architecture with a single pluggable database (PDB).

Limitations:

• A CDB with one PDB (single tenant) is currently the only certified deployment for Oracle E-Business Suite with Database 19c. i.e. A CDB with multiple PDBs (multitenant) is not currently certified.
• A non-CDB architecture is not planned to be certified or supported for EBS with Database 19c.
• UTL_FILE_DIR database initialization parameter has been de-supported. txkCfgUtlfileDir.pl to migrate your previous UTL_FILE_DIR database initialization parameter settings to the new parameter when you upgrade your database.

Following are the new database context variables:

s_pluggable_database

s_pdb_name

s_cdb_name

s_cdb_unique_name

s_dbService

s_db_tenancy

s_cdb_tnsadmin

Environment Files: 

• Two environments are created in 19c EBS Database -- cdb & pdb respectively
• we can also set ORACLE_PDB_SID=<PDB_NAME> to connect PDB instance directly.
• PDB Environment are sourced for tasks like - autoconfig, ETCC validation. 
• CDB environments are sourced for tasks like - Oracle Home patching.

High Level Steps in EBS configuration:

Database Tier:

Database Listener should have below entry, to successfully connect PDB to generate context file.

USE_SID_AS_SERVICE_<CDBNAME>=ON

Following step creates context file and updates PDB configuration,

$ cd $ORACLE_HOME

$ . ./txkSetCfgCDB.env dboraclehome=/u01/app/oracle/product/19.3.0.0/dbhome_1

$ cd bin

$ perl txkPostPDBCreationTasks.pl -dboraclehome=/u01/app/oracle/product/19.3.0.0/dbhome_1 -outdir=/u01/app/oracle/product/19.3.0.0/dbhome_1/appsutil/log -cdbsid=TESTCDB -pdbsid=TEST -appsuser=apps -dbport=1521 -servicetype=[dbsystem|exadatadbsystem|onpremise]

Application Tier:

Update the tnsnames.ora in below format and run autoconfig

<TWO_TASK> =

 (DESCRIPTION =

  (ADDRESS = (PROTOCOL=tcp)(HOST=<hostname>.<domain>)(PORT=1521))

  (CONNECT_DATA = (SERVICE_NAME=TEST)(INSTANCE_NAME=TESTCDB))

 )