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

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Julian Dontcheff's Database Blog

The good DBA is one who learns from his mistakes, the best DBA is one who learns from other DBA's mistakes

Martins Blog

Trying to explain complex things in simple terms

Oracle Data Warrior

Changing the world, one data model at a time. How can I help you?

Maaz Anjum's Blog

A life yet to be lived...

PeteWhoDidNotTweet

Stuff that interests me, if not you!

The Oracle Instructor

Explain, Exemplify, Empower

Frits Hoogland Weblog

IT Technology; Oracle, linux, TCP/IP and other stuff I find interesting

Oracle Spin - Flimatech Blog

Sharing Our Database Experience

Oracle Scratchpad

Just another Oracle weblog

Follow

Get every new post delivered to your Inbox.

Join 1,556 other followers

%d bloggers like this: