Oracle Enterprise manager overview

The enterprise manager is usually divided into 2 sections

Database Control

Grid Control / Cloud Control

Database Control

Database control is the most basic form of monitoring and it comes with the standard installation of Oracle as an option. During the normal installation Oracle will ask you if you either:

Configure Database Control, or

Configure Agent to Cloud control / Grid control

If a Database Control is chosen, then Oracle will configure repository for that database only

* Check the agent:

* Check the DB Control server:

Create repository

Drop reposistory

Oracle Enterprise manager overview after 12c

It is important to note that, since Oracle wants to gain as much money as they can, they disabled the enterprise manager database control from 12c, HOWEVER they created Enterprise Manager express, which is at least “something” To configure the EM Express, you should just execute a simple procedure:

Then you can open the following address: https://node-ip-address:EM-Express-port/em, where node-ip-address is the public IP address of the compute node hosting EM Express, and EM-Express-port is the EM Express port used by the database.

Again, this offers VERY limited functionality, like storage configuration and database settings. Global performance data like active sessions and others.