Monitoring a Database

This topic explains how to set up an:

  • Enterprise Manager Express console to monitor a version 12.2.0.1 or version 12.1.0.2 database
  • Enterprise Manager Database Control console to monitor a version 11.2.0.4 database

Each console is a web-based database management tool inside the Oracle database. You can use the console to perform basic administrative tasks such as managing user security, memory, and storage, and view performance information.

Required IAM Policy

Some of the procedures below require permission to create or update security lists. For more information about security list policies, see Security Lists.

Monitoring a Database with Enterprise Manager Express

On 1- and 2-node RAC DB Systems, by default, the EM Express console is not enabled on version 12.2.0.1 and 12.1.0.2 databases. You can enable it for an existing database as described below, or you can enable it when you create a database by using the dbcli create-database command with the -co parameter.

You must also update the security list and iptables for the DB System as described later in this topic.

When you enable the console, you'll set the port for the console. The procedure below uses port 5500, but each additional console enabled on the same DB System will have a different port.

Monitoring a Database with Enterprise Manager Database Control

By default, the Enterprise Manager Database Control console is not enabled on version 11.2.0.4 databases. You can enable the console:

  • when you create a database by using the dbcli create-database with the -co parameter
  • for an existing database as described here.

Port 1158 is the default port used for the first console enabled on the DB System, but each additional console enabled on the DB System will have a different port.

Note

For a version 11.2.0.4 database on a 2-node RAC DB System, see To enable the console for a version 11.2.0.4 database on a multi-node DB System .

Opening Ports on the DB System

Open the following ports as needed on the DB System:

  • 6200 - For Oracle Notification Service (ONS).
  • 5500 - For EM Express. 5500 is the default port, but each additional EM Express console enabled on the DB System will have a different port. If you're not sure which port to open for a particular console, see Monitoring a Database with Enterprise Manager Express.
  • 1158 - For Enterprise Manager Database Control. 1158 is the default port, but each additional console enabled on the DB System will have a different port. If you're not sure which port to open for a particular console, see Monitoring a Database with Enterprise Manager Database Control.

For important information about critical firewall rules, see Essential Firewall Rules.

Updating the Security List for the DB System

Review the list of ports in Opening Ports on the DB System and for every port you open in iptables, update the security list used for the DB System, or create a new security list.

Note that port 1521 for the Oracle default listener is included in iptables, but should also be added to the security list.