Configure Oracle Database 12c - Enterprise Manager Database Express

In this post, I am showing how we can access the Oracle Database Enterprise Manager.

Oracle Enterprise Manager Database Express will be installed while installing the Oracle Database 12c in the below installation step (follow here, for oracle DB 12c installation) , but when we access the ur we can see that enterprise manager is not accessible. For that, we have to set the https port configuration and can access the EM.

Step 1 : Connect the database using sqlplus

               sqlplus “/as sysdba”

Step 2: get the http port already configured

               SELECT DBMS_XDB_CONFIG.gethttpport FROM dual;

Step 3: Get the https port already configured

               SELECT DBMS_XDB_CONFIG.gethttpsport FROM dual;

Step 4: Set the https port

               EXEC DBMS_XDB_CONFIG.sethttpsport(5500);

Note: The DBMS_XDB_CONFIG package provides an interface for configuring Oracle XML DB and its repository. PL/SQL package DBMS_XDB_CONFIG is the Oracle XML DB resource application program interface (API) for PL/SQL for DBAs to configure their system. This API provides functions and procedures to access and manage Oracle XML DB Repository resources using PL/SQL. It includes methods for managing resource security and Oracle XML DB configuration.

Enterprise Manager URL is

https://<hostname>:<port>/em

Example is, 

https://desktop-627vpan:5500/em