Configuring the HTTPS Port for EM Express

The steps in this section need to be performed only if Database Configuration Assistant (DBCA) did not provide you with the Oracle Enterprise Manager Database Express (EM Express) URL when configuring your database or pluggable database (PDB), or if you need to change the EM Express port later on. Otherwise, you can start EM Express by following the instructions in "Starting EM Express."

Before you can access EM Express from a Web browser, the HTTPS port for EM Express must be configured. After the HTTPS port for EM Express is configured, you use it to access EM Express.

To manually configure the HTTPS port for EM Express:

  1. Configure and start the Oracle Net Listener (the listener). You can use lsnrctl to start, stop, and view the status of the listener.
  2. If the listener is running on a nonstandard port (for example, not 1521), then the init.ora file for the database you want to manage using EM Express must contain a local_listener entry so that the HTTPS port can register with the correct listener. The local_listener entry references a TNSNAMES entry that points to the correct listener. For example: 
    local_listener=inst1

    where inst1 is a TNSNAMES entry defined in tnsnames.ora that points to the listener. For example:

    inst1= (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=host_name)(PORT=1234))
(CONNECT_DATA=(SERVICE_NAME=service_name)(SERVER=DEDICATED)))

    In this example, 1234 is the nonstandard port on which the listener has been configured to listen.

  3. Enable the TCP dispatcher by adding the following entry to the init.ora file for the database you want to manage using EM Express: 
    dispatchers="(PROTOCOL=TCP)(SERVICE=<sid>XDB)"

    For example, if the database SID is ORCL, then the entry would be:

    dispatchers="(PROTOCOL=TCP)(SERVICE=ORCLXDB)"
  4. Restart the database so that the changes made in the init.ora file take effect.
  5. Use the PL/SQL procedure DBMS_XDB_CONFIG.SETHTTPSPORT to set the HTTPS port for EM Express for the database to a port that is not in use. This will update the HTTPS port in the xdbconfig.xml file in the Oracle XML DB Repository. You must connect as SYS / AS SYSDBA to run the procedure.

    For example, to set the HTTPS port for EM Express for a non-CDB:

    SQL> exec DBMS_XDB_CONFIG.SETHTTPSPORT(5500);

    To set the HTTPS port for EM Express for a multitenant container database (CDB), go to the root in the CDB and then use the PL/SQL procedure DBMS_XDB_CONFIG.SETHTTPSPORT in the CDB to set the HTTPS port for EM Express for the CDB to a port that is not in use. This will update the HTTPS port in the xdbconfig.xml file in the Oracle XML DB Repository. You must connect as SYS / AS SYSDBA to run the procedure. For example:

    SQL> alter session set container=CDB$ROOT;
SQL> exec DBMS_XDB_CONFIG.SETHTTPSPORT(5501);

    To set the HTTPS port for EM Express for a PDB, ensure that the PDB is open in read/write mode, and then use the PL/SQL procedure DBMS_XDB_CONFIG.SETHTTPSPORT in the PDB to set the HTTPS port for EM Express for the PDB to a port that is not in use. This will update the HTTPS port in the xdbconfig.xml file in the Oracle XML DB Repository. You must connect as SYS / AS SYSDBA to run the procedure. For example:

    SQL> alter session set container=PDB1;
SQL> exec DBMS_XDB_CONFIG.SETHTTPSPORT(5502);

    Use the following command to confirm that the port has registered with the listener:

    $ lsnrctl status | grep -i 5502
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=hostname.example.com)(PORT=5502)
)(Security=(my_wallet_directory=/$ORACLE_BASE/admin/sid/xdb_wallet))
(Presentation=HTTP)(Session=RAW))
  6. To access EM Express for a non-CDB, CDB, or PDB, enter a URL in the following format in a Web browser, specifying the EM Express port number for the non-CDB, CDB, or PDB you want to manage: 
    https://database-hostname:portnumber/em/

    For example:

    https://mydbhost.example.com:5500/em/

    When prompted for your username and password, log in as a user with DBA privilege (such as SYS or SYSTEM).

    See Also: