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:
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:
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
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.
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.
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.
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.
Use tags to organize your Oracle Database Appliance systems into different monitoring groups.
Topics:
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.
Create a tag and add your Oracle Database Appliance targets to the tag to create a group for monitoring.
Modify your group by adding or removing targets at any time.
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.
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:
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.
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.
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.
View the Version tab display a list of the component versions on the Oracle Database Appliance target.
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:
Figure 5-10 Oracle Database Appliance Topology Page