Submit a ticketCall us

Systems Monitoring for Dummies
Our new eBook will teach you the fundamentals and help you create monitors and alerts that are effective, meaningful, and actionable. Monitoring is more than a checkbox on your to-do list. This free eBook will give you practical advice to help you succeed in all aspects of monitoring – discovery, alerting, remediation, and troubleshooting. Don’t miss out on this indispensable resource for newbies, experienced IT pros, and everyone in between. Register Now.

Home > Success Center > Server & Application Monitor (SAM) > Use the SAM Oracle Database template and Oracle User Experience monitor without ODBC

Use the SAM Oracle Database template and Oracle User Experience monitor without ODBC

Table of contents

Updated: November 22, 2017

Overview

This article describe how to use the SAM Oracle Database template and Oracle User Experience monitor without an Open Database Connection (ODBC) to Oracle databases.

Environment

SolarWinds APM/SAM 3.5 and later

Note: The SAM product was previously known as the Application Performance Monitor (APM) product.

Steps

  1. Download the Oracle Install Client software from the following locations, depending on whether SAM is installed on a Windows 64-bit or 32-bit server. Note that you must accept the end-user license agreement and sign into the Oracle website before downloading the software.
  1. Extract the contents of the downloaded file to your local folder.
  2. Copy the extracted content to the directory where the SAM Oracle driver is installed. The path name may vary as shown in the following examples.

    Program Files (x86)\Solarwinds\Orion\APM\OracleClient
    -or-
    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 your additional pollers.

 

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