5 Monitoring Oracle Database Appliance

You can view all critical issues in the system, monitor performance, and drill down to individual targets from the Oracle Database Appliance home page.

Oracle Enterprise Manager Database Appliance management simplifies monitoring by integrating all hardware and software components into one entity.

Topics:

Monitoring All Oracle Database Appliance Targets

View monitoring information for all Oracle Database Appliance targets on the Oracle Database Appliance home page.

When you open the Oracle Database Appliance home page, you will see data aggregated from all Oracle Database Appliance systems that are managed by Oracle Enterprise Manager.

To display data for all systems:

  1. From the Oracle Enterprise Manager home page, open the Targets menu (target icon), then select Oracle Database Appliance.

    Oracle Enterprise Manager displays the Oracle Database Appliances page showing all the available targets.

  2. Use the tabs in the Oracle Database Appliance home page to monitor the aggregated topology.

Available Data for Oracle Database Appliance Targets

View available data for all Oracle Database Appliances or for a group of Oracle Database Appliances.

Whether you are monitoring all or a subset (group) of Oracle Database Appliance systems in the topology, the information is organized and grouped in tabs on the Oracle Database Appliance home page.

Figure 5-1 Oracle Database Appliance Home Page

Description of Figure 5-1 follows
Description of "Figure 5-1 Oracle Database Appliance Home Page"

Oracle Database Appliance Availability Tab

Use the Availability tab to view charts showing the status and states of Oracle Database Appliances.

System Status Chart

The System Status pie chart indicates whether the Oracle Database Appliance systems in the selected group are currently online or offline.

Click the pie chart sections to view detailed information about the system availability represented by the chart. The details are displayed in the table at the bottom of the tab.

Virtual Machine Status Chart

The Virtual Machine Status chart displays the status (online, offline, or missing) of all of the virtual machines in the selected group. If Oracle Database Appliance is not deployed with the Virtualized Platform, this chart is not displayed.

Click the elements in the chart to view detailed status information about the virtual machine components. The details are displayed in the table at the bottom of the tab.

System Component Graph

The System Component graph displays the status (online, offline, or missing) of components such as Appliance Manager, Oracle ASM, Oracle Database, hosts, and Oracle ILOMs for the selected group.

Click the bars in the chart to view detailed information about the components represented by the bar. The details are displayed in the table at the bottom of the tab.

Physical Disk Status Chart

The Physical Disk Status chart displays the status of all of the disks in the selected group.

Click sections of the pie chart to view detailed information about the physical disk availability represented by the chart. The details are displayed in the table at the bottom of the page.

Availability Table

The table at the bottom of the page changes based on elements you click in the other sections of the page

Click the pie chart in the System Status section to display the system status of each system in the group. The table lists all Oracle Database Appliance systems in the selected group, along with their statuses. Each Oracle Database Appliance system name is a URL link, which, if clicked, opens the Oracle Database Appliance system home page of the selected system.

The Oracle Database Appliance system home page contains detailed information for one Oracle Database Appliance system. See Monitoring Individual Oracle Database Appliance Targets.

Oracle Database Appliance Capacity Tab

Use the Capacity tab to view the space, memory, and CPU capacities that are utilized by managed Oracle Database Appliance systems.

Local FileSystem Space Utilization Chart

Each Oracle Database Appliance server node contains 600 GB local storage. The local file system space utilization chart displays the mount points and their space utilization. Place your mouse over the bar to display the mount point details. Click on a bar in the chart to list all systems in that utilization range in the table at the bottom of the Capacity tab.

CPU Load Chart

Systems are grouped in ranges of percentage of CPU utilization. Click on a bar in the chart to list all systems in that CPU load range in the table at the bottom of the Capacity tab.

Memory Utilization Chart

The Memory Utilization chart displays the memory utilization across the Oracle Database Appliances in the group. The bars represent the percentage of memory utilization. Place your mouse over the bar to display the total number of nodes in this utilization range. Click on a bar in the chart to list all systems in that utilization range in the table at the bottom of the Capacity tab.

Shared FileSystem Space Utilization Chart

Oracle Database Appliance uses Oracle ACFS file systems to store database and non-database files, guest VM templates, and virtual disk. The chart displays the shared file space utilization groupings, and the number of mount points that fall into this utilization grouping. Place your mouse over the bar to display the utilization group and number of mount points. Click on a bar in the chart to list all systems in that utilization range in the table at the bottom of the Capacity tab.

Disk Group Space Utilization Chart

Disk groups (such as RECO, REDO, DATA, and FLASH) are grouped in ranges of percentage of space utilization. Click on a bar in the chart to list all systems in that utilization range in a table at the bottom of the Capacity tab.

Oracle Database Appliance Configuration Tab

Use the Configuration tab to view the hardware and software configurations on managed Oracle Database Appliance systems.

Configured Cores Chart

The Configured Cores pie chart displays a segment representing the number of systems with a similar number of cores configured. Click a segment to display the names of each system with that number of configured in the table at the bottom of the Configuration tab.

Hardware Type Chart

The Hardware Type pie chart displays a segment representing the number of systems with a similar hardware platform (such as X5-2, X4-2, X3-2, and V1). Click a segment to display the names of the systems with that hardware platform in a table at the bottom of the Configuration tab.

Configuration Type Chart

The Configuration Type pie chart displays a segment representing the number of systems with a similar configuration type (such as VM-ODA_BASE). Click a segment to display the names of the systems with that configuration type in a table at the bottom of the Configuration tab.

Version Chart

The Version pie chart displays a segment representing the number of systems with the same software version, for example, 12.1.2.5.0. Click a segment to display the names of the systems with that software version in a table at the bottom of the Configuration tab.

Capacity Table

The table at the bottom of the page changes based on elements you select in the page.

Oracle Database Appliance Incidents Tab

Use the Incidents tab view all incidents related to all, or a subset (group) of, Oracle Database Appliance systems managed by Oracle Enterprise Manager.

Click a summary link to open a page with details about the selected incident.

Use the options in the View menu to adjust the columns and order of the table.

Using the Category drop-down list to filter the incidents by category.

Oracle Database Appliance Topology Tab

Use the Topology tab of the Oracle Database Appliance home page to view the topology of all systems or a group of systems.

See Viewing Oracle Database Appliance Topology.

Monitoring Groups of Oracle Database Appliance Targets

Use tags to organize your Oracle Database Appliance systems into different monitoring groups.

Topics:

About Monitoring Groups

Use tags to monitor a specified groups of targets.

Oracle Database Appliance systems are grouped using tags. When you monitor groups of targets, the Oracle Database Appliance home page only displays an aggregate of the data available for the group of targets defined by the tag. Oracle Database Appliance targets can belong to more than one group.

To monitor a group of Oracle Database Appliance systems, click on its tag in the tree on the left side of the page.

Creating an Oracle Database Appliance Group

Create a tag and add your Oracle Database Appliance targets to the tag to create a group for monitoring.

  1. From the Oracle Enterprise Manager home page, open the Targets menu (target icon), then select Oracle Database Appliance.

    Oracle Enterprise Manager displays the Oracle Database Appliances page showing all the available system groups in the navigation tree.

  2. Click the plus sign icon (Add Tag) above the navigation tree.

    Figure 5-2 Creating an Oracle Database Appliance Group

    Description of Figure 5-2 follows
    Description of "Figure 5-2 Creating an Oracle Database Appliance Group"
  3. In the Add Tag dialog box, enter a display name for the tag, and (optionally) a description. Click OK.

    Figure 5-3 Add Target Dialog Box

    Description of Figure 5-3 follows
    Description of "Figure 5-3 Add Target Dialog Box"
  4. Select the tag in the navigation tree, and click the wrench icon (Modify Systems).

    Note that when you select the tag in the navigation tree, the Topology tab shows a representation of MyTag, the tag created for this example, but there are no systems branched from it.

  5. In the Modify Systems dialog box, select systems to add to the group by moving them from the left column to the right column. Click OK.

    Figure 5-4 Selecting Systems to Add to a Group

    Description of Figure 5-4 follows
    Description of "Figure 5-4 Selecting Systems to Add to a Group"

    If you expand the tag in the navigation tree the selected systems appear beneath it and you can refresh the topology diagram to show the added system.

Modifying an Oracle Database Appliance Group

Modify your group by adding or removing targets at any time.

  1. From the Oracle Enterprise Manager home page, open the Targets menu (target icon), then select Oracle Database Appliance.

    Oracle Enterprise Manager displays the Oracle Database Appliances home page showing all of the available system groups in the navigation tree.

  2. Select the tag in the navigation tree, and click the wrench icon (Modify Systems).

    Figure 5-5 Modifying an Oracle Database Appliance Group

    Description of Figure 5-5 follows
    Description of "Figure 5-5 Modifying an Oracle Database Appliance Group"
  3. In the Modify Systems dialog box, select systems to add or remove from the group by clicking the arrows to move them to the left or to the right. Click OK.

    Figure 5-6 Modify Systems Dialog Box

    Description of Figure 5-6 follows
    Description of "Figure 5-6 Modify Systems Dialog Box"

Deleting an Oracle Database Appliance Group

To delete a group of targets, remove the tag.

  1. From the Oracle Enterprise Manager home page, open the Targets menu (target icon), then select Oracle Database Appliance.

    Oracle Enterprise Manager displays the Oracle Database Appliances page showing all the available system groups in the navigation tree.

  2. Select the group you want to delete, then click the X icon (Remove Tag) above the navigation tree.

    The All ODA tag cannot be deleted because it is the default tag for all of the discovered Oracle Database Appliances.

    Figure 5-7 Deleting a Tag

    Description of Figure 5-7 follows
    Description of "Figure 5-7 Deleting a Tag"
  3. In the Remove Tag dialog box, select the check box next to the group you want to delete and click OK.

    Figure 5-8 Remove Tag Dialog Box

    Description of Figure 5-8 follows
    Description of "Figure 5-8 Remove Tag Dialog Box"

    Removing the tag from the navigation tree does not remove any Oracle Database Appliance targets from Oracle Enterprise Manager.

Related Topics

Monitoring Individual Oracle Database Appliance Targets

Use this procedure to set up monitoring Oracle Database Appliance on Oracle Enterprise Manager Cloud Control.

Oracle Enterprise Manager Cloud Control uses URL links to display the names of the Oracle Database Appliance systems. Click a link for an Oracle Database Appliance system to open the page for monitoring that individual system.

  1. From the Oracle Enterprise Manager home page, open the Targets menu (target icon), and then select Oracle Database Appliance.

    Oracle Enterprise Manager displays the Oracle Database Appliances page showing all the available targets.

  2. Select All ODA in the navigation tree on the left side of the page.

    The systems are listed under the expanded All ODA group.

  3. Select the link corresponding to the system you want to monitor.

    The target page opens. For example:

    Figure 5-9 Monitoring Individual Oracle Database Appliance Targets

    Description of Figure 5-9 follows
    Description of "Figure 5-9 Monitoring Individual Oracle Database Appliance Targets"

Available Data for an Individual Oracle Database Appliance Target

You can monitor all components of the Oracle Database Appliance, including hosts, databases, virtualization, Oracle ASM, and more.

After you select an individual Oracle Database Appliance in Oracle Enterprise Manager, the left pane lists the Oracle Database Appliance components. These components are Appliance Manager, ASM, Host, Hypervisor, ILOM, Oracle Databases, and the virtualization components. The data appears in tabs.

Topics:

Oracle Database Appliance System General Tab

View the General tab for general system information.

The General tab has the following sections:

Availability

The Availability section lists the name, type, status, and availability for the last 24 hours of all of the components in the Oracle Database Appliance. The links in the Name column redirect the page to the home page of the component selected.

Configuration

The Configuration section displays the platform, hardware type, software version, and tags configured for the Oracle Database Appliance.

Click a tag to display the Oracle Database Appliance home page with data pertinent to the group of systems for the selected tag.

CPU

The CPU chart shows the CPU utilization percentage of hosts for the last 24 hours.

Hardware

The Hardware table shows the status of power supply, enclosure, cooling, and memory of each oak target. Statuses include online, offline, pending, and unknown.

Move your mouse to the status icon to see a popup of the detailed status for each category. The Oak Name links redirect the page to the OakHome page.

System Status

The System Status is an illustration of the back panel of the Oracle Database Appliance. A green light indicates that a node is online; a red light means either the system is offline or the status is unknown. Hover your mouse over each of the disks to see a popup displaying the status for each disk.

Memory

The Memory chart shows the memory utilization percentage of hosts for the last 24 hours.

Incidents

The Incidents table lists the incidents for the selected Oracle Database Appliance. Click a Summary link to open a page with details about the selected incident.

Adjust the columns and order of the table using the options in the View menu.

Filter the incidents by category using the Category drop-down list.

Oracle Database Appliance Target Virtual Machine Tab

View the Virtual Machine tab for monitoring information about virtual machine and resources.

The Virtual Machine tab lists information in the following six categories: Virtual Machine, Repository, Network, Vdisk, VM Template, and CPU Pool. This tab only appears in Oracle Database Appliance targets configured with Virtualized Platform environments. It does not appear in Oracle Database Appliance targets configured with Bare Metal environments.

The Virtual Machine tab has several groupings of sections. Use the list of links on the left side of the Virtual Machine tab to view each section.

Virtual Machine

When Virtual Machine is selected, the tab displays a summary, a list of virtual machines, and further details about virtual machine metrics.

The Virtual Machine list shows summary information for all the virtual machines created by users in the Oracle Database Appliance, including virtual machine name, memory, CPU, repository, node number, and state. Select a virtual machine name to display the detailed information in the Details section to the right.

Repository

The Repository category displays a summary of all the repositories created by the Oracle Database Appliance users, including repository name, free space, node number, and state. Use the grey arrow to display the node number and state for a selected repository. Select a repository name to display detailed information in the Details section at the right of the page.

Network

When Network is selected, the tab displays a list of VLANs and related summary information, including name, interface, node number, and ID.

Select a VLAN name to display the list of virtual machines attached to the VLAN in the Details section to the right.

Vdisk

When Vdisk is selected, the tab displays summary information about vdisks created by users, including the repository, name, size, and type. You can select a vdisk name to display detailed information in the Details section to the right.

VM Template

When VM Template is selected, the tab displays summary information for all the virtual machine templates created by users in the Oracle Database Appliance, including template name, memory, CPU, and repository. You can select a template name to display detailed information in the Details section to the right.

CPU Pool

When CPU Pool is selected, the tab displays all of the CPU pools for node 1 and node 2 in the Oracle Database Appliance. Click a pool name to display details about the Node1 and Node2 CPUs in the Details section to the right.

Oracle Database Appliance Target Storage Tab

View the Storage tab to view physical disk and ASM disk information.

On the left, the pie charts and lists show the number of disks and their statuses. Select a disk name to display detailed information for an individual disk in the Details section to the right.

Oracle Database Appliance Target Version Tab

View the Version tab display a list of the component versions on the Oracle Database Appliance target.

Oracle Database Appliance Target Topology Tab

View the Topology tab to display the topology of the individual target.

The individual targets define one physical Oracle Database Appliance that consists of several components including hosts, databases, virtual machines, and more.

Viewing Oracle Database Appliance Topology

Use the Topology Viewer to view the relationships between the components within Oracle Database Appliance.

You can zoom, pan, see selection details and summary information, and evaluate aggregate components. Unique icons are used for each object type, and standardized visual indicators are used across all applications.

Select the Topology tab of the Oracle Database Appliance home page or system page to view the topology of the system by group or individual target. Groups are a collection of Oracle Database Appliance systems. The individual targets define one physical Oracle Database Appliance that consists of several components including hosts, databases, virtual machines, and more.

To view the topology of an existing Oracle Database Appliance target:

  1. From the Oracle Enterprise Manager home page, open the Targets menu (target icon), then select Oracle Database Appliance.

    Oracle Enterprise Manager displays the Oracle Database Appliances page showing all the available targets.

  2. From the Oracle Database Appliance page, select the Oracle Database Appliance target (group or individual system) whose topology you want to view.
  3. Select the Topology tab.
  4. Click an element in the Topology and view data associated with the element.

    Each Oracle Database Appliance system tree node has three children: Hosts, Databases, and Virtualization. Click the system tree node to open a popup which contains information about the system, including system name, availability, and a list of components and their statuses.

Figure 5-10 Oracle Database Appliance Topology Page

Description of Figure 5-10 follows
Description of "Figure 5-10 Oracle Database Appliance Topology Page"