Accessing Enterprise Manager Database Express 12c

Enterprise Manager Database Express 12c (EM Express), a web-based tool for managing Oracle Database 12c, is available on Oracle Database Cloud Service database deployments created using Oracle Database 12c Release 1 (12.1) or Oracle Database 12c Release 2 (12.2).

Before you access EM Express to manage your database you must determine, and in some cases configure, the network port that is used to access EM Express as follows:

  • To manage the CDB. When a database deployment is created, Database Cloud Service automatically sets port 5500 on the deployment’s compute nodes for EM Express access to the CDB. You do not need to perform any manual configuration steps.

  • To manage a PDB with Oracle Database 12c Release 1 (version 12.1). For a version 12.1 database deployment, you must manually set a port for each PDB you want to manage using EM Express. See Setting the Port for EM Express to Manage a PDB.

  • To manage a PDB with Oracle Database 12c Release 2 (version 12.2). With Oracle Database 12c Release 2, EM Express can be configured to access the CDB and all PDBs on a single port, which is known as the global port. For version 12.2 database deployments created after early December 2016, the global port is set by default. For deployments created prior to December 2016, see Setting the Global Port for EM Express to Manage a CDB and the PDBs (Oracle Database 12.2 Only).

Note:

To confirm 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

After you determine the EM Express port for the CDB or PDB that you want to manage, you must choose one of the following options to access EM Express:

Setting the Port for EM Express to Manage a PDB

In Oracle Database 12c Release 1, a unique HTTPS port must be configured for the root container (CDB) and each PDB that you manage using EM Express.

To configure a HTTPS port so that you can manage a PDB with EM Express:

  1. Invoke SQL*Plus and log in to the PDB as the SYS user with SYSDBA privileges.

  2. Execute the DBMS_XDB_CONFIG.SETHTTPSPORT procedure.

    SQL> exec dbms_xdb_config.sethttpsport(port-number)

Setting the Global Port for EM Express to Manage a CDB and the PDBs (Oracle Database 12.2 Only)

In Oracle Database 12c Release 2, you can configure a single port (known as the global port), which enables you to use EM Express to connect to all of the PDBs in the CDB using the HTTPS port for the CDB.

In database deployments created after early December 2016, the global port is set by default.

To configure the global port in deployments created before December 2016:

  1. Invoke SQL*Plus and log in to the root container (CDB) as the SYS user with SYSDBA privileges.

  2. Execute the DBMS_XDB_CONFIG.SETGLOBALPORTENABLED procedure.

    SQL> exec dbms_xdb_config.SetGlobalPortEnabled(TRUE)

Accessing EM Express Using the EM Express Port

If the EM Express port is not blocked, you can access EM Express by directing your browser to the 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.

You can also access EM Express to manage the CDB in 12.1 or the root container and PDBs through the global port in 12.2 through the Oracle Database Cloud Service console:

  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.

    The EM Express login page is displayed.

  3. Enter the name of a user with theDBA privilege (such as SYS or SYSTEM) and the password. To connect with SYSDBA privileges, select as sysdba. Then click Login.

This option is also available from the action menu (Menu icon) on the Oracle Database Cloud Service Instance Overview page.

Note:

On a database deployment hosting an Oracle RAC database, the link Open EM Console opens EM Express on node 1. To open EM Express on node 2, direct your browser to the URL https://node2-ip-address:EM-Express-port/em, where node2-ip-address is the public IP address of node 2, and EM-Express-port is the EM Express port used by the database.

Accessing EM Express Using an SSH Tunnel

To access EM Express when its port is blocked, you must create an SSH tunnel to the EM Express port on the compute node hosting EM Express. See Creating an SSH Tunnel to a Compute Node Port.

After the SSH tunnel is created, you can access EM Express by directing your browser to the URL https://localhost:EM-Express-port/em.

After the EM Express login page is displayed, enter the name of a user with theDBA privilege (such as SYS or SYSTEM) and the password. To connect with SYSDBA privileges, select as sysdba. Then click Login.