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. Oracle Database supports relational, document, graph, and key-value data models, which improves storage efficiency and can retrieve structured and unstructured data. The system is designed for high performance, scalability, and reliability, and offers features such as ACID-compliant transactions, data security, and high availability. Oracle Database is suitable for a wide range of applications, from small-scale installations to large enterprise environments.

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.

  • Supported "Oracle: Database" PowerPack versions: 18x, 19x, 21x, 23ai
  • Supported connection types: SSH, TCP, TCPS

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
  • Discovery of Container Databases (CDBs) and Pluggable Databases (PDBs)
  • Discovery of Active-Active RAC nodes individually
  • Monitoring of Automatic Storage Management (ASM) instances

What Operating Systems Does the Oracle: Database PowerPack Monitor?

The "Oracle: Database" PowerPack supports operating system discovery for any operating system.

However, ScienceLogic recommends that Linux users still verify compatibility for the following two Dynamic Applications, as they rely on SSH-based data collection and might run operating system-specific commands:

  • Oracle: DB Archived File System Stats
  • Oracle: DB Non-Archived File System Stats

These two Dynamic Applications use SSH credentials and might not operate as expected, depending on the target operating system's shell and available utilities.

The following operating systems are supported 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: Database" PowerPack installed, you must remove them from your SL1 system. You must also remove any pre-existing discovered "Community or Custom Oracle" PowerPack device trees and their device classes before installing this PowerPack.

If you are using an SL1 version that is not at least 12.2.0, you must delete the "Oracle: Database" PowerPack example PowerShell credentials.

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

When upgrading from version 106 or older, be sure the Enable Selective PowerPack Field Protection checkbox is not selected on the Behavior Settings page (System > Settings > Behavior) prior to upgrading. This will result in the PowerPack upgrading improperly, which will cause collection issues. For more information, see the following Knowledge Base article: https://support.sciencelogic.com/s/article/17987

For details on upgrading SL1, see the relevant SL1 Platform Release Notes.

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.