Use EM Express

Overview

EM Express can access one (1) CDB or one (1) PDB at a time. Each port has to be unique on a host. The main PL/SQL package for settings is DBMS_XDB_CONFIG. Non-administrative users can gain read-only access to EM Express through the EM_EXPRESS_BASIC role.

References

• Database 2 Day DBA
  • Getting Started with Database Administration
    • 3.4 Starting EM Express
• Database PL/SQL Packages and Types Reference
  • 183 DBMS_XDB_CONFIG
    • GETHTTPPORT Function
    • GETHTTPSPORT Function
    • SETHTTPSPORT Procedure

Procedure

Find Current HTTP Port for EM Express

I ran the following command on the JAR instance on PADSTOW to see if EM Express was configured:

SELECT dbms_xdb_config.gethttpsport, dbms_xdb_config.gethttpport FROM dual;

The result was:

GETHTTPSPORT GETHTTPPORT ------------ ----------- 0 0

Thus, EM Express is not configured here.

Activate EM Express

I ran the following command on the JAR instance on PADSTOW to configure EM Express:

EXEC dbms_xdb_config.sethttpsport(5500)

The result was:

PL/SQL procedure successfully completed.

Verify EM Express Configuration

I ran the following command on the JAR instance on PADSTOW to see if EM Express was configured correctly:

SQL> SELECT dbms_xdb_config.gethttpsport, dbms_xdb_config.gethttpport FROM dual;

The result was:

GETHTTPSPORT GETHTTPPORT ------------ ----------- 5500 0

I was able to use HTTPS://PADSTOW.YAOCM.ID.AU:5500/EM to connect to the EM Express Console after igoring the security warnings. The following page appears:

Grant Access to Non-Administrative Users

I ran the following set of commands on the JAR instance on PADSTOW to:

1. Switch to the JAM0 PDB
2. Allocate a new port, 5501, for EM Express to connect to this PDB
3. Create a user called DOUGLAS
4. Give the user, DOUGLAS, enough privileges to connect to the PDB and to access EM Express in read-only mode.

SQL> ALTER SESSION SET container = jam0; Session altered. SQL> SQL> EXEC dbms_xdb_config.sethttpsport(5501) PL/SQL procedure successfully completed. SQL> SQL> CREATE USER douglas IDENTIFIED BY "&password."; User DOUGLAS created. SQL> SQL> GRANT em_express_basic, 2 CREATE SESSION 3 TO douglas; Grant succeeded.

I was able to use the url, HTTPS://PADSTOW.YAOCM.ID.AU:5501/EM, to connect to the EM Express Console for the JAM0 PDB after igoring the security warnings, and get the following screen: