Home > Database, new features in 12c, Oracle > Enterprise Manager Database Express in Database 12c Release 1

Enterprise Manager Database Express in Database 12c Release 1

Introduction

Key things to remember about Enterprise Manager Database Express.

  • EM DB Express is not Cloud Control or Grid Control!
  • EM DB Express is not a replacement for the DB Control from 11g, as it has significantly less functionality.
  • A DBA will not be able to administer the database using just EM DB Express.

If your organisation uses Cloud Control, which it should, you will probably never use EM Database Express. If on the other hand you are playing around with the database and want a pretty interface to perform some tasks, the EM Database Express might be your answer.

Configuration

If you’ve done the sort of database installations, you’ve probably already got EM Database Express configured. Unlike the DB Control, it runs from inside the database using the XML DB infrastructure, so there are no additional parts to install or executables to start.

To get up and running, you just need to check the HTTPS port is set for the XML DB.

SQL> SELECT DBMS_XDB.gethttpport FROM dual;

GETHTTPPORT
-----------
          0

SQL> SELECT DBMS_XDB_CONFIG.gethttpsport FROM dual;

GETHTTPSPORT
------------
        5500

SQL> EXEC DBMS_XDB_CONFIG.sethttpsport(5500);

PL/SQL procedure successfully completed.

SQL>

Once that is done, EM Database Express is accessible using the following type of URL.

https://<hostname>:<port>/em/

Example:

https://ol6-121.localdomain:5500/em/

Enter your database login details and click the “Login” button.

Ekran Resmi 2014-08-25 22.00.57

You are presented with the home page for the database.

Ekran Resmi 2014-08-25 22.02.16

Usage

The menu structure for DB Express is quite simple.

Configuration
  - Initialization Parameters
  - Memory
  - Database Feature Usage
  - Current Database Properties

Storage
  - Undo Management
  - Redo Log Groups
  - Archive Logs
  - Control Files

Security
  - Users
  - Roles

Performance
  - Performance Hub
  - SQL Tuning Advisor

You will notice, there is very little in the way of administration screens. This is not a tool a DBA will use to administer the database.

Most of the screens are self explanatory. The only really interesting screen is the Performance Hub, which actually looks nicer than the Cloud Control equivalent.

Ekran Resmi 2014-08-25 22.03.31

What About the Missing Bits

As mentioned previously, you will quickly realise DB Express is not a replacement for the 11g DB Control. How do you perform the tasks that are not supported by DB Express?

  • Cloud Control : Your company should be using Cloud Control. If you are not, you are making a big mistake.
  • SQL Developer : SQL Developer has matured significantly over recent versions. It now includes a number of administration features.
  • SQL*Plus : Even with Cloud Control, I still find myself using SQL*Plus all the time.
Advertisements
  1. Abdullah Sahin
    August 25, 2014 at 7:38 pm

    So did Oracle introduced EM DB Express with 12c where before with 11th they had db control ( I assume both are free when you buy the db) ? But they cut some features off em db express and included in Grid Control ?

    • August 25, 2014 at 8:39 pm

      Nope, exact release version of EM DB Express is 12c(and for sure it is free), so it is newer than 11g’s grid control. The main ideas are avoiding from slowness complaints and decreasing the memory usage. So, we can say the easiest way to manage memory is to use the graphical user interface of Oracle Enterprise Manager Database Express (EM Express), and also it is the simplified version of EM or “they cut some features off em db express and included in Grid Control”.

  2. September 2, 2014 at 2:01 pm

    Reblogged this on Dinesh Ram Kali..

  1. No trackbacks yet.

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

%d bloggers like this: