Oracle E-Business Suite with Oracle Database 19c FAQs

Oracle EBS is now certified to use with Oracle database 19c(19.13) 

A Container Database(CDB) with one Pluggable Database(PDB) (single-tenant) is currently the only certified deployment for Oracle E-Business Suite with Database 19c. So oracle database has to be multitenant on Oracle 19c.

• How does E-Business Suite support the Oracle Database multitenant architecture?

  Oracle E-Business Suite supports the multitenant architecture with a single CDB containing a single pluggable Oracle E-Business Suite database (PDB) in the following combinations:

  For R12.2
  Oracle E-Business Suite 12.2.3 and later with Oracle Database 19c on-premises
  Oracle E-Business Suite 12.2.3 and later with Oracle Database 12cR1 VM DB Systems or Oracle Database 12cR1 in an Exadata DB System
  For R12.1
  Oracle E-Business Suite 12.1.3 with Oracle Database 19c on-premises
  Oracle E-Business Suite 12.1.3 with Oracle Database 12cR1 VM DB Systems or Oracle Database 12cR1 in an Exadata DB System

• Are there additional licensing requirements?

Oracle E-Business Suite currently supports a single pluggable database (single-tenant) with a CDB architecture (see the previous question). A single PDB in a CDB does not require licensing the Oracle Multitenant database option.

• How to connect to the Oracle E-Business Suite CDB as SYSDBA?

Source the CDB environment file in the ORACLE_HOME and then use SQL*Plus to connect to the CDB as SYSDBA:

$ cd $ORACLE_HOME

$ source <CDB_NAME>_<NODE_NAME>.env

$ sqlplus "/ as sysdba"

 

• How to connect to the Oracle E-Business Suite PDB as SYSDBA?

Source the CDB environment file,  then export the Oracle EBS PDB name, then use SQL*Plus to connect to the PDB as SYSDBA

$ source <CDB_NAME>_<NODE_NAME>.env

$ export ORACLE_PDB_SID=<PDB NAME>;

$ sqlplus "/ as sysdba"

 

• How to Start and Shutdown the CDB that hosts the Oracle E-Business suite PDB?

Depending on the Database Instance Environment you are using for either Single Node or RAC

Starting Single Node:

$ source <CDB_NAME>_<NODE_NAME>.env

$ sqlplus "/ as sysdba"

SQL> startup;

 Stopping Single Node:

$ source <CDB_NAME>_<NODE_NAME>.env

$ sqlplus "/ as sysdba"

SQL> shutdown normal;

Starting RAC Environment:

$ source <CDB_NAME>_<NODE_NAME>.env

$ srvctl start database -d

Stopping RAC Environment:

$ source <CDB_NAME>_<NODE_NAME>.env

$ srvctl stop database -d

 

• How to open the Oracle E-Business Suite PDB?

Source the CDB environment file, then connect to the CDB as SYSDBA, and after that execute the SQL shown in the example to start the PDB

$ source <CDB_NAME>_<NODE_NAME>.env
$ sqlplus "/ as sysdba"
SQL> alter pluggable database open read write services=all;

• How to close the Oracle E-Business Suite PDB?

Source the CDB environment, then connect to the CDB as SYSDBA, and after that execute the SQL shown in the example to close the PDB:

$ source <CDB_NAME>_<NODE_NAME>.env
$ sqlplus "/ as sysdba"
SQL> alter pluggable database close immediate;

 

• How to find Oracle EBS PDB information and status?

$ source <CDB_NAME>_<NODE_NAME>.env

$ sqlplus "/ as sysdba"

SQL> show pdbs;

 

• How to list the OPatch inventory for a multitenant database?

$ source <CDB_NAME>_<NODE_NAME>.env
$ export PATH=$PATH:$ORACLE_HOME/OPatch
$ opatch lsinventory -detail

 

• How to set up the environment to install a database patch in an Oracle E-Business Suite multitenant database?

$ source <CDB_NAME>_<NODE_NAME>.env
$ export PATH=$PATH:$ORACLE_HOME/OPatch

 

• How to set up the environment to run an Oracle E-Business Suite Script or SQL session?

$ source <CDB_NAME>_<NODE_NAME>.env
$ export ORACLE_PDB_SID=<PDB NAME>
$ sqlplus "/ as sysdba"