Introduction

Download this manual as a PDF file

This section describes how to configure SL1 to monitor Oracle Database instances.

What is Oracle Database?

Oracle Database is a multi-model database management system used for running online transaction processing, data warehousing, and mixed database workloads.

What Does the Oracle: Database PowerPack Monitor?

The Oracle: Database PowerPack includes Dynamic Applications that can monitor performance metrics and collect configuration data for Oracle databases and their instances.

In addition to Dynamic Applications, the PowerPack includes the following features:

  • Dynamic Applications to discover, model, and monitor performance metrics and collect configuration data for Oracle Database instances
  • Event Policies and corresponding alerts that are triggered when Oracle devices meet certain status criteria

  • Device Classes for each of the Oracle devices monitored
  • Sample Credentials for discovering Oracle devices
  • A Device Dashboard to display summary information about an Oracle Database instance

What Operating Systems Does the Oracle: Database PowerPack Monitor?

The Oracle: Database PowerPack supports operating system discovery for a variety of operating systems. The following operating systems can be monitored by the Oracle: Database PowerPack:

  • AIX
  • CentOS
  • HP-UX
  • Oracle Linux
  • Red Hat Enterprise Linux
  • Solaris
  • SUSE Linux
  • Ubuntu
  • Windows

Installing the Oracle: Database PowerPack

Before completing the steps in this section, you must import and install the latest version of the Oracle: Database PowerPack.

If you have the SLPS: Oracle DB PowerPack or the Oracle DB PowerPack installed, you must remove them from your SL1 system.

You must also remove any pre-existing discovered Oracle Database device trees and all Oracle device classes before installing.

If you are upgrading from an earlier version of the PowerPack, see the Release Notes for the version you are installing for upgrade instructions.

By default, installing a new version of a PowerPack overwrites all content from a previous version of that PowerPack that has already been installed on the target system. You can use the Enable Selective PowerPack Field Protection setting in the Behavior Settings page (System > Settings > Behavior) to prevent new PowerPacks from overwriting local changes for some commonly customized fields. (For more information, see the section on Global Settings.)

The minimum required MySQL version is 5.6.0.

To download and install the PowerPack:

  1. Search for and download the PowerPack from the PowerPacks page (Product Downloads > PowerPacks & SyncPacks) at the ScienceLogic Support Site.
  2. In SL1, go to the PowerPacks page (System > Manage > PowerPacks).
  3. Click the Actions button and choose Import PowerPack. The Import PowerPack dialog box appears.
  4. Click [Browse] and navigate to the PowerPack file from step 1.
  5. Select the PowerPack file and click Import. The PowerPack Installer modal displays a list of the PowerPack contents.
  6. Click Install. The PowerPack is added to the PowerPacks page.

If you exit the PowerPack Installer modal without installing the imported PowerPack, the imported PowerPack will not appear in the PowerPacks page. However, the imported PowerPack will appear in the Imported PowerPacks modal. This page appears when you click the Actions menu and select Install PowerPack.