EM Express#

Em express,Oracle Enterprise Manager Database Expres, is web-based graphical interface for managing an Oracle database. It is built right inside the Oracle database server hence no extra installations are needed. It is can only manage a single database instance, the instance on which it runs.

Checking Configured EM Express Ports#

EM Express uses Oracle XDB repository ports. These ports, both http and https, can be queried directly from the database.

1
--- Get HTTP port
2
select dbms_xdb_config.gethttpport() from dual;
3

4
--- Get HTTPS port
5
select dbms_xdb_config.gethttpsport() from dual;

If the result of any of the queries is 0, it means the corresponding protocol is disabled and cannot be used to access EM Express.

Enabling EM Express#

If the Oracle XDB repository http and https ports are set to 0, then EM Express is disabled.
To enable it, you need to choose a port that is available on your database node.

NOTE

• Chose a port that is not in use by any other service in your database node.
• Prefer non-privileged ports. (ports above 1024)

To set either http or https EM Express port, you will need to change the Oracle XDB repository port.

1
--- Set HTTP port
2
exec dbms_xdb_config.sethttpport(5501);
3

4
--- Set HTTPS port
5
exec dbms_xdb_config.sethttpsport(5502);

Once the ports are set, you can access EM Express via:

• http: http://<node_address>:5501/em/
• https: https://<node_address>:5501/em/

Common issues#

• XDB Wallet Permissions#

If the XDB repository ports are correctly set and EM express is unavailable, one of the potential culprits is the XDB wallet permissions. The wallet files are located in $ORACLE_HOME/admin/<DB_NAME>/xdb_wallet/.

NOTE

Replace <DB_NAME> with the SID of your database.

The wallet files should be owned by the user oracle and group asmadmin.
The user oracle should have read and write permissions.
The group asmadmin should have just read permissions.

1
-rw-r----- 1 oracle asmadmin 3880 Feb 6 2025 cwallet.sso
2
-rw-r----- 1 oracle asmadmin 3881 Feb 6 2025 ewallet.p12

• Firewall#

Ensure that no firewall is blocking traffic to and from the XDB repository ports.

This includes:

1. local node firewall, such as firewalld, iptables and ufw.
2. intermediate firewalls between the database node and the client machine.

• Security Modules#

It is also important to confirm that security modules like selinux are not blocking traffic to and from the configured ports.