Oracle Enterprise manager Grid control, is hands down the best monitoring and management tool, for the oracle exadata database machine. It comes with plugins to monitor all the hardware components of the database machine, and sensible, preset thresholds for proactive monitoring.
Update (Nov 2011) : Enterprise manager 12c is now available, and Certified to be used with exadata. The master MOS note 1110675.1 covers the installation and configuration details.
Some key points
- You should use 11gR1 enterprise manager grid control for monitoring.
- You should use 11gR1 enterprise manager agents, to monitor the targets on the database machine.
- If you use enterprise wide monitoring tools like tivoli, openview or netcool, use snmp traps from oracle enterprise manager, to notify these monitoring tools (ie dont try to directly use snmp to monitor the exadata components. You could do this but it will be too time consuming).
- You could potentially use 10.2.0.5 Oem, with 11g agents to monitor the dbmachine, but this is not recommended as a stable/long term solution.
- The following components (And more) can be monitored using Enterprise Manager
- Databases hosts
- Exadata Cells
- Cisco switch
- KVM (Keyboard, Video, Mouse)
- ILOM Monitoring
- Infiniband switch
- Power distribution unit (PDU)
You have 3 possible options to configure enterprise manager
- If you have an existing 11gR1 enterprise manager grid control envrionment, you can patch it with the recommended patches and use that for monitoring the dbmachine targets.
- You can setup and configure a brand new 11gR1 enterprise manager grid control environment (On a separate server) and configure it to monitor the dbmachine targets.
- Download the required software
- Weblogic server 10.3.2 (MOS Note 1106105.1, 1063112.1)
- Jdk 64 bit (Mos Note 1063587.1)
- 11gR1 Oms from download.oracle.com
- Install Java and Web Logic Server (Wls)
- MOS Note 1063762.1
- Patch Web Logic Server
- MOS Note 1072763.1
- Install 11gR1 Enterprise manager Oracle Management Server (OMS)
- Install/Create a 11gR2 database to serve as the Enterprise Manager Repository
- Database pre-reqs for 220.127.116.11 repository (Mos Note 1064441.1)
- Install/Configure Oms (Mos Notes 1130958.1, 1059516.1)
- Patch OMS with the required patches to enable database machine monitoring
- Mos Note 1323298.1
- You can use an easy install option to setup and configure an enterprise manager environment and configure the plugins.
- The easy install is delivered as a patch 11852882 (EMGC setup automation kit)
- The configuration worksheet has to be filled out properly (Before the installation) and the em.param file has to be generated.
- Follow the instructions in the readme to do a quick install of a fully configured 11gR1 Enterprise manager installation.
- This method helps you install/patch and configure the full 11gR1 oms in just an few steps and is a huge time saver.
Download the required plugins to monitor the following components
Install and Configure the Agent and the Plugins
- Follow MOS Note 1110675.1 to install the agents and configure the exadata cell plugin
- Oracle Exadata Avocent MergePoint Unity Switch
- Oracle Exadata Cisco Switch
- Oracle Exadata ILOM
- Oracle Exadata Infiniband Switch
- Oracle Exadata Power Distribution Unit
- Oracle Exadata Storage Server
- Monitor Exadata Database Machine: Agent Installation and Configuration
- Monitor Exadata Database Machine: Configuring ASM and Database Targets
- Monitor Exadata Database Machine: Configuring the Exadata Storage Server Plug-in
- Monitor Exadata Database Machine: Configuring the ILOM Plug-in
- Monitor Exadata Database Machine: Configuring the InfiniBand Switch Plug-in
- Monitor Exadata Database Machine: Configuring the Cisco Ethernet Switch Plug-in
- Monitor Exadata Database Machine: Configuring the Avocent KVM Switch Plug-in
- Monitor Exadata Database Machine: Configuring User Defined Metrics for Additional Network Monitoring
- Monitor Exadata Database Machine: Configuring Plug-ins for High Availability
- Monitor Exadata Database Machine: Creating a Dashboard for Database Machine
Sending SNMP traps to 3rd party monitoring tools.
- Get the Mib (Management Information Base) file from your enterprise manager management server and send it to the 3rd party tool administrator (eg: openview or netcool). Follow MOS note 389585.1, to get this MIB file.
- Then configure your notification methods and rules to send the required snmp traps to the 3rd party tool.