Since EM Express is built inside the database, the database has to be open in order to use EM Express, and EM Express cannot perform actions outside the database.
EM Express does not have background tasks or processes that periodically collect information. Instead, it utilizes data that is already collected by the database. Data is requested only when the user interacts with the UI and all UI processing is done in the browser, thus minimizing load on the database server.
SQL> select dbms_xdb.getHttpPort() from dual; ---http port
SQL> select dbms_xdb_config.getHttpsPort() from dual;--https
- Configure and start the Oracle Listener.
local_listenerentry references a TNSNAMES entry that points to the correct listener.
local_listener = orcl ; --(orcl is the tnsnames)
SQL> alter system set local_listener = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=host_name)(PORT=1526))(CONNECT_DATA=(SERVICE_NAME=service_name)(SERVER=DEDICATED)))' ;
- Enable the TCP dispatcher by adding the following entry to the
init.orafile for the database you want to manage using EM Express:
- Then Restart the database so that the changes made can take effect.