Accessing Enterprise Manager Database Express 18c

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

You can access EM Express in the following ways:

Using the Open EM Console Menu Item to Access EM Express

Note:

For database deployments built on Oracle Cloud Infrastructure Classic, the network port to access EM Express is blocked by default. To use the Open EM Console menu item, you must unblock port 5500, either by enabling the deployment’s ora_p2_dbexpress predefined access rule or by creating your own access rule that opens port 5500. For instructions, see Enabling Access to a Compute Node Port.

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

    For detailed instructions, see Accessing the Oracle Database Cloud Service Console.

  2. From the action menu (Menu icon) for the deployment, select Open EM Console.

  3. 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 Database 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.

  4. When prompted for a user name and password, enter the name of a user with theDBA 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.

    Note: if the database deployment was created using a QuickStart template, the password for SYS and SYSTEM is available in the zip file downloaded when the deployment was created.

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

Note:

On database deployments hosting an Oracle RAC database, the Open EM Console menu item opens EM Express on node 1. To open EM Express on node 2, you must use a direct URL.

Using a Direct URL to Access EM Express

Note:

For database deployments built on Oracle Cloud Infrastructure Classic, the network port to access EM Express is blocked by default. To use a direct URL, you must unblock port 5500, either by enabling the deployment’s ora_p2_dbexpress predefined access rule or by creating your own access rule that opens port 5500. For instructions, see Enabling Access to a Compute Node Port.

  1. In your web browser, go to the following URL:

    https://node-ip-address:5500/em

    where node-ip-address is the IP address of the compute node as listed on the deployment’s Overview page.

  2. 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 Database 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.

  3. 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.

    Note: if the database deployment was created using a QuickStart template, the password for SYS and SYSTEM is available in the zip file downloaded when the deployment was created.

Using an SSH Tunnel to Access EM Express

  1. Create an SSH tunnel to port 5500 on the compute node hosting EM Express. For information about creating an SSH tunnel, see Creating an SSH Tunnel to a Compute Node Port.

  2. After creating the SSH tunnel, direct your browser to the URL https://localhost:5500/em.

  3. 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.

    Note: if the database deployment was created using a QuickStart template, the password for SYS and SYSTEM is available in the zip file downloaded when the deployment was created.