Use EM Express

Contents

  1. 1 Overview
  2. 2 References
  3. 3 Procedure
    1. 3.1 Find Current HTTP Port for EM Express
  4. 4 Activate EM Express
  5. 5 Verify EM Express Configuration
    1. 5.1 Grant Access to Non-Administrative Users

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

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:

Front page of EM Express for SYS User on CDB

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:

Front page of EM Express for Non-Admin User on JAM0 PDB