Configuring Enterprise Manager Database Express in Oracle 12c

  • Published on Nov 3 2017
  • # 32
  • 12c

In my setup I have a container database (CDB) named DB01 and one pluggable database (PDB) named PDB01.

I want to set up EM Database Express for both my container database CDB and my pluggable database PDB.

Setting up EM Database Express for my CDB.
The default URL’s for EM Database Express are http://localhost:5510/em and https://localhost:5500/em.

The current EM DB Express Port configuration is checked with below SQL:

sys@cdb$root:db01> select dbms_xdb_config.gethttpsport() from dual;

DBMS_XDB_CONFIG.GETHTTPSPORT()
------------------------------
                             0

1 row selected.

A value of 0 means EM Database Express is not configured. To configure EM Database Express use DBMS_XDB_CONFIG.SETHTTP(S)PORT as shown below.

sys@cdb$root:db01> exec DBMS_XDB_CONFIG.SETHTTPSPORT(5500);

PL/SQL procedure successfully completed.

sys@cdb$root:db01> exec DBMS_XDB_CONFIG.SETHTTPPORT(5510);

PL/SQL procedure successfully completed.
sys@cdb$root:db01> select
  2     dbms_xdb_config.gethttpport()
  3  ,  dbms_xdb_config.gethttpsport()
  4  from dual;

DBMS_XDB_CONFIG.GETHTTPPORT() DBMS_XDB_CONFIG.GETHTTPSPORT()
----------------------------- ------------------------------
                         5510                           5500

1 row selected.

No go to http://localhost:5510/em or https://localhost:5500/em to log on to EM Database Express.

I get ‘error’ message “Alternate HTML content should be placed here. This content requires the Adobe Flash Player. Get Flash”

Click the link to install flash on your server… After installation of the Flash plugin and granting permission in the browser to let the flash widget run I can successfully log in to EM Database Express.

Setting up EM Database Express for my PDB PDB01.
Connect to the PDB:

system@cdb$root:db01> alter session set container = pdb01;

Session altered.

Check EM DB Express port configuration:

system@pdb01:db01> select
  2     dbms_xdb_config.gethttpport()
  3  ,  dbms_xdb_config.gethttpsport()
  4  from dual;

DBMS_XDB_CONFIG.GETHTTPPORT() DBMS_XDB_CONFIG.GETHTTPSPORT()
----------------------------- ------------------------------
                            0                              0

1 row selected.

Configure EM DB Express port configuration for the PDB:

system@pdb01:db01> exec DBMS_XDB_CONFIG.SETHTTPSPORT(5501);

PL/SQL procedure successfully completed.

system@pdb01:db01>
system@pdb01:db01> exec DBMS_XDB_CONFIG.SETHTTPPORT(5511);

PL/SQL procedure successfully completed.

system@pdb01:db01>

Now my PDB’s PDB01 EM Database Express is available on http://localhost:5511/em and https://localhost:5501/em.

With help from //emarcel.com/oem-express-12c/ who rightfully points out youcan query the oracle listener services for HTTP(S) endpoints:

$ lsnrctl status
...
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DESKTOP-DBS4LAC)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=DESKTOP-DBS4LAC)(PORT=5500))(Security=(my_wallet_directory=C:\ORACLE\admin\DB01\xdb_wallet))(Presentation=HTTP)(Session=RAW))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DESKTOP-DBS4LAC)(PORT=5510))(Presentation=HTTP)(Session=RAW))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=DESKTOP-DBS4LAC)(PORT=5501))(Security=(my_wallet_directory=C:\ORACLE\admin\DB01\xdb_wallet))(Presentation=HTTP)(Session=RAW))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DESKTOP-DBS4LAC)(PORT=5511))(Presentation=HTTP)(Session=RAW))

Leave a Reply

Helpful? - leave your note below so I can brag

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>