Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

 

 

 

Home > Success Center > Server & Application Monitor (SAM) > Orion APM Oracle User Experience monitors cannot connect to Oracle databases

Orion APM Oracle User Experience monitors cannot connect to Oracle databases

Table of contents

Overview

This article describe how to use the Oracle Database template and Oracle User Experience monitor without the ODBC connection to connect to Oracle databases.

Environment

Orion APM 3.5 and later

Steps

  1. Download the Oracle Install Client software from the following locations, depending on whether Orion APM is installed on a Windows 64-bit or 32-bit server:

    Note: You will be required to accept the end-user license agreement and sign in to the Oracle website before you can download the software. 
  1. Extract the content of the downloaded zip archive to your local folder.
  2. Copy the extracted content to the directory where APM's Oracle driver is installed, for example:

    Program Files (x86)\Solarwinds\Orion\APM\OracleClient
    -or-
    Program Files\Solarwinds\Orion\APM\OracleClient

    and ensure that you overwrite the existing files.
  3. Ensure that the account under which Orion services run has Full Control privileges over the files in the OracleClient directory.

 

Notes:

  • 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
20:54, 30 Nov 2016

Tags

Classifications

Public