Submit a ticketCall us

WebinarUpcoming Webinar: Know What’s Changed – with NEW Server Configuration Monitor

Change management in IT is critical. But, even with a good change management process, changes are too often not correctly tracked, if at all. The configuration of your servers and applications is a key factor in their performance, availability, and security. Many incidents can be tracked back to an authorized (and sometimes unauthorized) configuration change, whether to a system file, configuration file, or Windows® Registry entry. Join SolarWinds VP of product management Brandon Shopp to discover how the new SolarWinds® Server Configuration Monitor is designed to help you.

Register now.

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

Overview

Updated April 24, 2018

This article describes how to configure the SAM Oracle Database template to monitor Oracle database servers, which involves installing one of the following drivers to support polling by SAM and other SolarWinds products:

Environment

  • SAM 6.2 or later

Steps

Prepare for Installation

Before installing a driver, follow these steps:

  1. Verify the server uses one of the following Oracle databases: 
  2. Use 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 Oracle Data Provider for .NET (ODP.Net) driver

Oracle registration is required to download the ODP.Net driver, but it is free. If you opt not to register with Oracle, then you can download the Basic Lite Client instead, as described in option 2.

  1. 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. 

  2. Uninstall any version of the Oracle Client, including the SolarWinds Basic Lite Oracle Client.
  3. Verify that the following directory is empty if it exists. If it is not empty, stop all Orion services and remove the directory before continuing.

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 SolarWinds Customer Portal.
  2. Click Downloads > Download Product to access the Product Downloads section.
  3. Select Server & Application Monitor > any license > Additional Downloads > Oracle Client, and then click Download.
  4. Select a Basic Lite Client version to match the current polling method. See Change between 32-bit and 64-bit polling methods.
    Note: Using AppInsight applications with 32-bit polling on 64-bit computers via an agent may prevent certain performance counters from collecting information and should be changed to 64-bit polling. 
  5. Run the executable to install it.
  6. Verify that files were installed in C:\Program Files\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 (APEs).

 

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