EM Express – 12c Edition

With the new release of Oracle Database 12c, Oracle has removed the old Database Console.  In its place they have given us Enterprise Manager Express (EM Express for short). Be default EM Express is configured for the traditional (non-CDB) or container (CDB) database if selected when using the DBCA.  In order to access a PDB with EM Express it needs to be configured using the DBMS_XDB_CONFIG.SETHTTPSPORT() procedure.
Thet port that EM Express is running on can be identified from the listener status (lsnrctl status) command.  By default Oracle will pick a port between 5500 to 5599 to bring EM Express up on.  In the image below, we can see that the EM Express is running on port 5500.

[oracle@oel6 dbs]$ lsnrctl status
LSNRCTL for Linux: Version 12.1.0.1.0 - Production on 04-JUL-2013 17:44:51
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.1.0 - Production
Start Date 04-JUL-2013 17:01:41
Uptime 0 days 0 hr. 43 min. 10 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/product/12.1.0.1/dbhome_1/network/admin/listener.ora
Listener Log File /opt/oracle/diag/tnslsnr/oel6/listener/alert/log.xml
Listening Endpoints Summary...
 (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oel6.acme.com)(PORT=1521)))
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oel6.acme.com)(PORT=5500))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "ora12c.acme.com" has 1 instance(s).
 Instance "ora12c", status READY, has 1 handler(s) for this service...
Service "ora12cXDB.acme.com" has 1 instance(s).
 Instance "ora12c", status READY, has 1 handler(s) for this service...
Service "pdb1.acme.com" has 1 instance(s).
 Instance "ora12c", status READY, has 1 handler(s) for this service...
The command completed successfully

Once we know the port that EM Express is running on we can point our browser to the URL that will allow us to access the EM Express login page.  On my testing VM my URL is:

http://oel6.acme.com:5500/em

When I access this URL, I’m given the log in page for EM Express.
emexpresslogin.png
In order to login to EM Express, we  can use any of the users that have access to the database as long as they are granted the EM_EXPRESS_BASIC or EM_EXPRESS_ALL roles.  Users like SYS and SYSTEM, have access to the EM Express by default.  Once in EM Express, the main page shows a lot of information related to the database connected to.  Have a look around before passing judgement on this new console, it is loaded with a lot of great features for developers and administrators a like.
NewImage
What about COMMON_USERS?  Common users do not have access to EM Express by default.  Agin in order to grant access to EM Express, COMMON_USERS will need access through the roles EM_EXPRESS_BASIC and EM_EXPRESS_ALL.  When trying to access EM Express without these roles, the interface tell you exactly what needs to be granted to allow the user access.
rolesneeded.png
This post is just intended to give you a quick introduction to EM Express.
Enjoy!
twitter: @curtisbl294
blog: http://dbasolved.com

Please follow and like:
Comments
Comments are closed.

Enquire now

Give us a call or fill in the form below and we will contact you. We endeavor to answer all inquiries within 24 hours on business days.