Submit a ticketCall us

AnnouncementsSystem Monitoring for Dummies

Tired of monitoring failures disrupting the system, application, and service? Learn the key monitoring concepts needed to help you create sophisticated monitoring and alerting strategies that can help you save time and money. Read the eBook.

Get your free eBook.

Home > Success Center > Server & Application Monitor (SAM) > SAM - Knowledgebase Articles > Configure SAM to monitor an Oracle Database Server

Configure SAM to monitor an Oracle Database Server

Updated November 13, 2018

Overview

This article describes how to add an Oracle client to the Orion server so you can monitor Oracle database servers with SAM templates. 

Environment

  • SAM 6.2 or later

Steps

Prepare for Installation

Verify that you have an Oracle name and password with read access to the following Oracle views:

  • dba_free_space
  • v$sysstat
  • v$rowcache
  • v$librarycache
  • v$sgastat
  • v$session

Option 1: Install an ODP.Net driver

Oracle registration is required to download the Oracle Data Provider for .NET (ODP.Net) driver, but it is free. If you opt not to register with Oracle, then you can download the Basic Lite Client from the SolarWinds Customer Portal, as described in option 2.

  1. Log into the Orion server.
  2. Download the 32-bit version of ODP.Net driver (© 1995-2018 Oracle, available at http://www.oracle.com/technetwork, obtained on February 11, 2016)

    Download the 32-bit version of ODP.Net, even if SAM is installed on a 64-bit version of Windows. 

  3. Uninstall any version of the Oracle Client, including the SolarWinds Basic Lite Oracle Client.
  4. Verify that the following directory is empty if it exists: C:\Program Files (x86)\Solarwinds\Orion\APM\OracleClient\

    If the directory is not empty, stop all Orion services and remove the directory before continuing.

  5. Run the downloaded file to install the ODP.NET driver.

  6. Verify that files were installed in C:\Program Files (x86)\Solarwinds\Orion\APM\OracleClient.

Option 2: Install a Basic Lite Client

If you do not want to register with Oracle, you can download the Basic Lite Client from the SolarWinds Customer Portal.

  1. Log into the Orion server.
  2. In a browser, log into the SolarWinds Customer Portal.
  3. Click Downloads > Download Product to access the Product Downloads section.
  4. Select Server & Application Monitor and then select any license.
  5. In the Additional Downloads section of the page, click Additional Components > Oracle Client > Download.
  6. Open the downloaded ZIP file and run OracleClientInstaller.exe. 
  7. Verify that files were installed in C:\Program Files (x86)\Solarwinds\Orion\APM\OracleClient.

Notes:

  • The account under which Orion services run must have Full Control privileges for files in the OracleClient directory.
  • You cannot use Oracle credentials with limited permissions to run the SQL statements defined in the Oracle User Experience monitor. This will produce an error similar to the following: Table or view doesn't exist.
  • If you have multiple polling engines, the Oracle client software must be installed on Additional Polling Engines.
  • Additional .NET downloads for Oracle Data Access Components are available here. (© 2018 Oracle, available at http://www.oracle.com/technetwork/topics/dotnet/downloads, obtained on November 15, 2018.) 

Learn more

Additional resources about Oracle databases include::

 

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment.  You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.

Last modified

Tags

Classifications

Public