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.
[[email protected] dbs]$ lsnrctl status LSNRCTL for Linux: Version 126.96.36.199.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 188.8.131.52.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/184.108.40.206/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:
When I access this URL, I’m given the log in page for EM Express.
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.
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.
This post is just intended to give you a quick introduction to EM Express.
I’m Bobby Curtis and I’m just your normal average guy who has been working in the technology field for awhile (started when I was 18 with the US Army). The goal of this blog has changed a bit over the years. Initially, it was a general blog where I wrote thoughts down. Then it changed to focus on the Oracle Database, Oracle Enterprise Manager, and eventually Oracle GoldenGate.
If you want to follow me on a more timely manner, I can be followed on twitter at @dbasolved or on LinkedIn under “Bobby Curtis MBA”.