12C: EM Express for CDB/PDB/Non-CDB

EM Express:

EM express is a web based light weight tool that will help in managing Oracle 12C databases.  It offers support for basic administrative tasks such as storage and user management, and provides comprehensive solutions for performance diagnostics and tuning. To manually set up EM Express, simply configure the HTTPS or HTTP port by logging into the database and setting the port using dbms_xdb_config.sethttpsport (https) and dbms_xdb_config.sethttpport (http)

Requirement:

To setup and access EM Express for  all three types of 12C databases

1) CDB

2) PDB

3) Non-CDB

1) EM express for CDB

Get the port number on which EM express is configured.

You can find it out either from lsnrctl status or using SQL query as shown below.

lsnrctl status | grep http

...........

DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=MyHost.oracle.com)(PORT=5500))(Security=(my_wallet_directory=MyWallet_Dir_Path))(Presentation=HTTP)(Session=RAW))

OR

Login to CDB as SYS user and issue the following query

select dbms_xdb_config.gethttpsport from dual;

GETHTTPSPORT

-------------------

5500

We can then access the EM express by entering following URL in the browser

https://<hostname>:5500/em

If the port is not configured, then we can do so by setting the HTTP/HTTPS port. 

SQL> exec dbms_xdb_config.sethttpsport(5500);

2) EM express for PDB

Login to PDB and then configure a port. In the example my PDB name is PDB1.

SQL> alter session set container=pdb1;

sho con_name

CON_NAME

------------------------------

PDB1

Configure the port for EM express

Here we are going to configure port number 5501 for EM express

SQL> exec dbms_xdb_config.sethttpsport(5501);

Confirm that EM has been configured on specified port (1501)

SQL> select dbms_xdb_config.gethttpsport from dual;

GETHTTPSPORT

------------

5501

Access  EM express by entering following URL in the browser:

https://<hostname>:5501/em

3) EM Express for Non-CDB

Login to non-CDB. The container name would come as Non consolidated in case of Non-CDB

SQL> conn sys/pwd as sysdba

sho con_name

CON_NAME

------------------------------

Non Consolidated

Get the port configured for EM Express with following SQL query

SQL > select dbms_xdb_config.gethttpsport from dual;

GETHTTPSPORT

------------------------

5502

Access  EM express by entering following URL in the browser:

https://<hostname>:5502/em

Note:

Above method of configuring EM Express will only work if DB is registered with the default listener running on port 1521. If the DB is registered with the non-default listener then you need to add an entry for the listener in tnsnames.ora file and also set init parameters LOCAL_LISTENER (to the non default listener) and DISPATCHERS  

local_listener=<host_name>:<port no>