Skip to content

EM Express: Single Port Access for Multitenant


This document explains the EM Express new feature introduced in 12.2 – Single Port Access for Multitenant Databases.


Knowledge of multitenant architecture and EM Express is required


Oracle Enterprise Manager Database Express (EM Express) is enhanced for multitenant container database (CDB) to support a single port or URL that is used to access any of the pluggable databases (PDBs) within the CDB.

When logging into EM Express, you can specify a pluggable database name allowing you to log directly into that PDB. Default is the root container.

1. To enable single port acess:

alter session set container=CD$ROOT;

exec dbms_xdb_config.SetGlobalPortEnabled(TRUE);

2. Check whether EM Express is configured:

select dbms_xdb_config.gethttpsport() from dual;

If a value other than 0 is returned by the gethttpsport procedure, the returned value is the port that you should use to connect to the CDB using EM Express.

If a value of 0 is returned by this statement, it means that an HTTPS port is not configured for the CDB and you can configure it using DBMS_XDB_CONFIG.SETHTTPSPORT.

3. To access EM Express for a non-CDB, CDB, or PDB, enter a URL in the following format in a Web browser, specifying the EM Express port number for the non-CDB, CDB, or PDB you want to manage:

In the Login page, you can specify the PDB to which you want to connect. If its not specified, EM Express connects to the root container.

%d bloggers like this: