Home / Installations/Configurations-Applications / Oracle EBS with Oracle Database 19c FAQs

Oracle EBS with Oracle Database 19c FAQs

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"

 

 

  • 5

About Syed Saad Ali

As a certified and experienced Oracle Database Administrator with Almost 12 Years of Experience I am able to perform all levels of database maintenance and am fully qualified to do Oracle updates as well. Capitalizing on my interest in Business & IT both, I chose to navigate my career towards Enterprise Solutions, which has enabled me to excel in the combination of both. I have developed exceptional analytical skills that allow me to diagnose and take care of issues immediately. Extremely skilled in planning and execution of special projects in time- critical environments. Extensive knowledge in directing, coordinating and exercising concern authority for planning, organization, control and successful completions. Very skilled at solving customer relations issues by seeking first to understand and then to be understood. Effectively able to communicate with customers, vendors and management.

Check Also

How to Get Apps Password From Backend

How to Get Apps Password From Backend   STEP 1.  First login to Database through …

Leave a Reply