Enabling EM Express Console in OCI Environment

By default EM Express Console is not enabled in 18.1.0.0, 12.2.0.1 and 12.1.0.2 databases.  Below is the step by step process to enable EM Express Console in Oracle Database.

In my environment, I had enabled the EM Console at PDB level.

Before enabling the console listener status would be

To enable the console and set its port

Now confirm the listener is listening on the port '5500'.

Now to open the port '5500' on DB system, follow the below steps

Once the DB port is opened, update your security list in OCI console. To do this on an existing security list, follow the below steps.

1. Open the navigation menu. Under Oracle Database, click (Bare Metal / VM / Exadata) ---> as per your environment

2. Choose your Compartment.

   A list of DB systems is displayed.

3. Locate the DB system in the list.
4. Note the DB system's Subnet name and click its Virtual Cloud Network.
5. Locate the subnet in the list, and then click its security list under Security Lists.

6. Click Edit All Rules and add an ingress rule with source type = CIDR, source CIDR=<source CIDR>, protocol=TCP, and port=<port number or port range>.

   The source CIDR should be the CIDR block that includes the ports you open for the client connection.

Known Issue:

You might get a "Secure Connection Failed" error message when tried to connect to the EM Express Console from your 1 node DB system because the correct permissions were not applied automatically. To overcome this issue follow the below steps.

Now copy the location of the wallet directory, navigate there and follow the below steps.

Ref: Monitoring a Database (oracle.com)

        Known Issues (oracle.com)

****************************நன்றி****************************