12c EM express - first view

I thought I'd take a look at the new EM express tool provided by deafult with 12c - no more messing about with the software and having to install em repositories etc - there is now something set up out of the box (well nearly out of the box in my case) with no additional software components running.

Oracle have built on top of the XDB/Apex infrastructure to create a cut down EM that will be useful for most common tasks.


I tried to use the installation after following a completely manual setup of the database and it didnt work - i had to do a couple of extra steps to activate it - these were

alter system set dispatchers="(PROTOCOL=TCP)(SERVICE=DEMOXDB)"; -- where DEMO is your SID
exec DBMS_XDB_CONFIG.SETHTTPSPORT(5500);

This is probably just because of a bug in the manual setup process (and me missing the first init parameter).

So after these are set (and the database is restarted).

You should see a couple of extra lines in the listener output

 lsnrctl stat

LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 21-JAN-2014 21:22:18

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1531)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 12.1.0.1.0 - Production
Start Date                15-DEC-2013 20:05:56
Uptime                    37 days 1 hr. 16 min. 21 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/product/12.1.0/grid/network/admin/listener.ora
Listener Log File         /oracle/diag/tnslsnr/server/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1531)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=server)(PORT=1531)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=server)(PORT=5500))(Security=(my_wallet_directory=/oracle/admin/DEMO/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "DEMO" has 1 instance(s).
  Instance "DEMO", status READY, has 1 handler(s) for this service...
Service "DEMOXDB" has 1 instance(s).
  Instance "DEMO", status READY, has 1 handler(s) for this service...
The command completed successfully

The key line being the
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=server)(PORT=5500))(Security=(my_wallet_directory=/oracle/admin/DEMO/xdb_wallet))(Presentation=HTTP)(Session=RAW))

so something is now listening on port 5500 and somehow a wallet got auto setup to allow https

we can now access the app at

https://server:5500/em

which looks like this (ignore the certficate warnings)

You can then login with your normal credentials,
SYSDBA will only work if a passwordfile has been set up.

You then get the home page - giving access to the 'stuff'

It's not the all singing all dancing thing it was before but it's good enough i think. We have a full cloud control installation anyway so are unlikely to use this facility anyway.

I'm not sure if the old style em installation is still available any more.