Skip to content

EM Express: Single Port Access for Multitenant

PURPOSE

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

SCOPE

Knowledge of multitenant architecture and EM Express is required

DETAILS

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:

https://database-hostname:portnumber/em/

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.