Connecting To Oracle Multitenant Database

Oracle E-Business Suite Release 12.2.3 (and later) with Oracle 19c supports a multitenant architecture. Specifically, this is a single CDB (Container Database) containing a single PDB (Pluggable Database) in EBS.

Connecting to the CDB as SYSDBA is pretty much the same. Connecting to the PDB requires an extra step.

The following are examples of how to connect to your CDB/PDB as SYSDBA on a Linux host.

Connect to the E-Business Suite CDB as SYSDBA

To connect to the CDB using SQL*Plus, you first need to source the CDB environment file.


unix> source $ORACLE_HOME/_.env
unix> sqlplus sys as sysdba


You can confirm your connection with the following command:


SQL> show con_name


You will see the following if you are connected to the CDB:


CON_NAME
--------------------
CDB$ROOT


Connect to the E-Business Suite PDB as SYSDBA

To connect to the PDB using SQL*Plus, you first need to source the CDB environment file and set the ORACLE_PDB_SID environment variable:


unix> source $ORACLE_HOME/CDB_NAME>_.env
unix> export ORACLE_PDB_SID=
unix> sqlplus sys as sysdba


You can confirm your connection with the following command:


SQL> show con_name


You will see the following if you are connected to the PDB:


CON_NAME
--------------------