OEM : Add OEM 12c express edition console on database

Database Name: SMRPATCH7 ( standalone test database )

Hostname :  srv1.example.com

Operating System : SUSE 12 SP5 64 bit 

Note: Even we have configured EM Express with on of on our live  RAC 2 node machine  using scan DNS name. Due to free licience issue we have to configure free oem express edition  on that database. 

•  Login database and Check port configuration information for EM express edition console.

SQL> SELECT DBMS_XDB_CONFIG.gethttpport FROM dual;

GETHTTPPORT

-----------

          0

• Configure EM express port. In our case we have provided 5500

SQL> EXEC DBMS_XDB_CONFIG.sethttpsport(5500);

PL/SQL procedure successfully completed.

• Check EM configuration port.

SQL> SELECT DBMS_XDB_CONFIG.gethttpsport FROM dual;

GETHTTPSPORT

------------

        5500

• Check dispatcher entry , in some database i have seen no entry on dispatchers so OEM console didn't run even configuring port.

SQL>

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

dispatchers                          string      (PROTOCOL=TCP) (SERVICE=SMRPATCH7XDB)                      

max_dispatchers                      integer

• You can add entry on pfile  or dynamically below.

*.dispatchers='(PROTOCOL=TCP) (SERVICE=SMRPATCH7XDB)'

alter system set dispatchers = '(address=(protocol=tcp)(host=srv1.example.com))(dispatchers=40)(service=SMRPATCH7)(listener=listener_name)';

• Login EM express edition OEM console below.

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