Configuring OEM Express Control

Starting 12c, OEM Database Control has been replaced by OEM Database Express. OEM Express configuration is very simple as compared to previous OEM Database Control. Following is the method to configure OEM Express. OEM Express Database is configured separately for container database and each pluggable database. Method is same; you just need to set current container to pluggable database for which you want to configure the OEM, and execute the steps as explained bellow.

Container database
Check dispatcher configuration in the database

SQL> show parameter dispatcher NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ dispatchers                          string      (PROTOCOL=TCP) (SERVICE=salman12XDB) max_dispatchers                      integer

Check current port set for XML DB. If not set, set the port

SQL> SELECT dbms_xdb_config.gethttpsport from dual; GETHTTPSPORT ------------            0 SQL>  exec dbms_xdb_config.sethttpsport(5000) PL/SQL procedure successfully completed. SQL> SELECT dbms_xdb_config.gethttpsport from dual; GETHTTPSPORT ------------         5000

If you check listener status, you can see the port.

C:\>lsnrctl status LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 04-DEC-2015 16:33:13 Copyright (c) 1991, 2014, Oracle.  All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SALMQURE-SG)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias                     LISTENER Version                   TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Production Start Date                04-DEC-2015 08:53:23 Uptime                    0 days 7 hr. 39 min. 49 sec Trace Level               off Security                  ON: Local OS Authentication SNMP                      OFF Listener Parameter File   C:\app\salmqure\product\12.1.0\dbhome_1\network\admin\listener.ora Listener Log File         C:\app\salmqure\product\12.1.0\dbhome_1\log\diag\tnslsnr\SALMQURE-SG\listener\alert\log.xml Listening Endpoints Summary...   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SALMQURE-SG)(PORT=1521)))   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=SALMQURE--SG)(PORT=5000))(Security=(my_wallet_directory=C:\APP\SALMQURE\admin\salman12\xdb_wallet))(Presentation=HTTP)(Session=RAW)) Services Summary... Service "pdb1.sg.oracle.com" has 1 instance(s).   Instance "salman12", status READY, has 1 handler(s) for this service... Service "pdb2.sg.oracle.com" has 1 instance(s).   Instance "salman12", status READY, has 1 handler(s) for this service... Service "salman12.sg.oracle.com" has 1 instance(s).   Instance "salman12", status READY, has 1 handler(s) for this service... Service "salman12XDB.sg.oracle.com" has 1 instance(s).   Instance "salman12", status READY, has 1 handler(s) for this service... The command completed successfully C:\>

Start using OEM Database Express using URL similar to the following

https://<host_name>:port_number For example https://salmqure-sg:5000/em

For Pluggable Database

SQL> alter session set container=pdb1; Session altered. SQL> select name,open_mode from v$pdbs; NAME                           OPEN_MODE ------------------------------ ---------- PDB1                           READ WRITE SQL> SELECT dbms_xdb_config.gethttpsport from dual; GETHTTPSPORT ------------            0 SQL>  exec dbms_xdb_config.sethttpsport(5001) PL/SQL procedure successfully completed. SQL> SELECT dbms_xdb_config.gethttpsport from dual; GETHTTPSPORT ------------         5001

Now use following URL to access OEM for pluggable database

https://salmqure-sg:5001/em