Database Reference
In-Depth Information
Chapter 6
Monitoring the Oracle Database
Appliance
The Oracle Database Appliance can be viewed as a single box or as two separate boxes, depending on how you want
to monitor it. In reality, the Oracle Database Appliance is a machine that solves problems for businesses by shrinking
the physical hardware footprint, yet increases overall usability. The Oracle Database Appliance can be used to help
organizations be scalable with their architecture. When scaling out architectures with new hardware, especially with
an engineered system like the Oracle Database Appliance, monitoring becomes a concern. How does one monitor the
Oracle Database Appliance?
Monitoring the Oracle Database Appliance is quite the same as monitoring any other database environment;
the difference is that you have two physical servers collocated in a single box. As discussed in previous chapters, the
Oracle Database Appliance can have an associated database configured in Stand Alone (Enterprise Edition), Oracle
RAC One, or Oracle Real Application Clusters (RAC) modes. All three configurations can be monitored in a few
different ways. In this chapter, we will look at how to configure, verify, reconfigure, start, stop, and deconfigure a utility
called Database Control for an Oracle 11g Release 2 database on the Oracle Database Appliance. This is the utility by
which you control the appliance. Then later we will take a look at how to deploy Oracle Enterprise Manager Agents
against the appliance.
■
Oracle Database 12c has not been certified with the Oracle Database Appliance. The use of Enterprise Manager
(EM) Express with the Oracle Database 12c on the Oracle Database Appliance has not been verified.
Note
Configuring Database Control
Database Control is the lightweight version of the Oracle Enterprise Manager for Oracle Database 11g. The
functionality provided by Database Control helps database administrators and developers identify and resolve
performance and administrative issues that may be related to current and ongoing processing in the database.
There are three ways to configure Database Control: during installation, from Database Configuration Assistant
(DBCA), and from the command line using the Enterprise Manager Configuration Assistant (EMCA). For the purpose
of this chapter, let's focus on configuring the Database Control with the EMCA tool.
