Accessing Enterprise Manager Database Express 18c, or later

Enterprise Manager Database Express (EM Express), a web-based tool for managing Oracle Database, is available on Oracle Database Exadata Cloud Service database deployments created using Oracle Database 18c, or later.

You can access EM Express in the following ways:

Note:

On Exadata Cloud Service, the EM Express network port is blocked by default. To access EM Express by using the Open EM Console menu item or by using a direct URL, you must first gain access to the network port. See Finding the EM Express Network Port and Enabling Network Access to a Compute Node.

Using the Open EM Console Menu Item to Access EM Express

Open the Instances page of the Oracle Database Cloud Service console.

For detailed instructions, see Accessing the My Services Dashboard and the Oracle Database Cloud Service Console.
From the action menu () for the deployment, select Open EM Console.
If your browser displays a warning that your connection is not secure or not private, use the browser’s advanced option to ignore the warning and continue.

You get this warning because Exadata Cloud Service database deployments use a self-signed certificate to provide HTTPS (secure HTTP) connectivity, and such certificates are considered suspicious by many web browsers.
When prompted for a user name and password, enter the name of a user with the DBA privilege (such as SYS or SYSTEM) and the password.

Enter a PDB name if you want to access a specific PDB or leave it blank to access the root container.

If you want to connect with SYSDBA privileges, select as SYSDBA.

After entering or selecting the required values, click Login.

The Open EM Console menu item is also available from the action menu () on the Oracle Database Cloud Service Instance Overview page.

Using a Direct URL to Access EM Express

In your web browser, go to the following URL:
```
https://node-ip-address:EM-Express-port/em
```
where node-ip-address is the public IP address of the compute node hosting EM Express, and EM-Express-port is the EM Express port used by the database.
If your browser displays a warning that your connection is not secure or not private, use the browser’s advanced option to ignore the warning and continue.

You get this warning because Exadata Cloud Service database deployments use a self-signed certificate to provide HTTPS (secure HTTP) connectivity, and such certificates are considered suspicious by many web browsers.
When prompted for a user name and password, enter the name of a user with DBA privilege (such as SYS or SYSTEM) and the password.

Enter a PDB name if you want to access a specific PDB or leave it blank to access the root container.

If you want to connect with SYSDBA privileges, select as SYSDBA.

After entering or selecting the required values, click Login.

Using an SSH Tunnel to Access EM Express

Create an SSH tunnel to the EM Express port on the compute node hosting EM Express. For information about creating an SSH tunnel, see Creating an SSH Tunnel to a Compute Node Port.
After creating the SSH tunnel, go to the following URL:
```
https://localhost:EM-Express-port/em
```
where EM-Express-port is the EM Express port used by the database.
When prompted for a user name and password, enter the name of a user with DBA privilege (such as SYS or SYSTEM) and the password.

Enter a PDB name if you want to access a specific PDB or leave it blank to access the root container.

If you want to connect with SYSDBA privileges, select as SYSDBA.

After entering or selecting the required values, click Login.

Finding the EM Express Network Port

When a database deployment is created, Exadata Cloud Service automatically sets a port for EM Express. You do not need to perform any manual configuration steps. Each database deployment is allocated a unique port number in a range starting with 5500, 5501, 5502, and so on.

To find the port that is in use for a specific database, connect to the database as a database administrator and execute the query shown in the following example:

SQL> select dbms_xdb_config.getHttpsPort() from dual;

DBMS_XDB_CONFIG.GETHTTPSPORT()
------------------------------
                          5502