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 asSYS
orSYSTEM
) 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, andEM-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 asSYS
orSYSTEM
) 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 asSYS
orSYSTEM
) 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.
SQL> select dbms_xdb_config.getHttpsPort() from dual;
DBMS_XDB_CONFIG.GETHTTPSPORT()
------------------------------
5502