Submit a ticketCall us

AnnouncementsTHWACKcamp 2018 is here

2018 is the seventh year for THWACKcamp™, and once again we’ll be live October 17 – 18 with packed session tracks covering everything from network monitoring and management, to change control, application management, storage, cloud and DevOps, security, automation, virtualization, mapping, logging, and more.

Register for online sessions.

Home > Success Center > Server & Application Monitor (SAM) > SAM - Knowledgebase Articles > 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 July 12, 2018

Overview

This article describe how to add Oracle Install Client software to the Orion server so you can use the SAM Oracle Database template and Oracle User Experience monitor without an Open Database Connection (ODBC) to Oracle databases.

Environment

SolarWinds 6.2 and later

Steps

 

  1. Log into http://www.oracle.com (© 2018 Oracle, available at https://www.oracle.com, obtained on July 12, 2018).
  2. 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.
  1. Extract the contents of the downloaded file to a local folder.
  2. Copy the extracted content to the directory where the SAM Oracle driver is installed on the Orion server. 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
  3.  If you have Additional Polling Engines (APEs), install the Oracle client software on those machines also.

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: table or view doesn't exist.
  • If you have Additional Polling Engines (APEs), install the Oracle client software on those machines also.


To learn more, see:

 

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