Applications Systems

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

This article describes how to download and install Oracle software to use the SAM Oracle Database template and Oracle User Experience monitor without the ODBC connection to connect to Oracle databases. Monitor Oracle on Windows Orion Agent. Windows Agent server.

First published date

10/10/2018 4:10 PM

Last published date

9/18/2025 9:35 PM

Overview

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

To learn more about monitoring Oracle database servers with SAM, see Configure SAM to monitor Oracle database servers in the SAM Administrator Guide.

Product section

Server Application Monitor

Resolution

Log into http://www.oracle.com.
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.

For 64-bit systems: http://www.oracle.com/technetwork/topics/winx64soft-089540.html
For 32-bit systems: http://www.oracle.com/technetwork/topics/winsoft-085727.html

Extract the contents of the downloaded file to a local folder.
Copy the extracted content to the directory where the SAM Oracle driver is installed on the SolarWinds Platform server. The client will be located on the SolarWinds Platform Agent if the node is polled via the SolarWinds Platform Agent and the application is set to Agent polling.

Server Type	Directory
Polling Engine	`C:\Program Files (x86)\Solarwinds\Orion\APM\OracleClient`
Orion Agent*	`C:\Program Files (x86)\Solarwinds\Agent\Plugins\APM\OracleClient\`

*Note for agent: this directory will not exist, you need to create it.

For SolarWinds Platform Agents

For Orion agent servers, proceed to copy the extracted content to the agent installation directory

Now, update your environment path variable. Start > search: environment variables > Environment Variables > Edit 'path' > enter your Oracle Basic Client path.
You can verify your update with cmd command:

echo %PATH%

If you have Additional Polling Engines (APEs) and have or plan to have Oracle monitors polled by those engines, you will want to repeat step 4 install the Oracle client software on those machines as well.

Notes:

Based on the client bit-type you installed in step 2, you will want to select the correct Platform to run polling job on in the Application Template.
- 32-bit client = x86
- 64-bit client = x64

The account under which SolarWinds Platform 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.

To learn more, see:

Oracle Database (online help)
ODBC User Experience monitor (online help)
Monitor Open Database Connectivity (ODBC) connection between Oracle and another server
Oracle User Experience Monitor Component (SolarWinds Lab Bits video)
Monitoring Those Hard to Reach Places: Linux, MySQL, Oracle, Java and More (THWACK Camp)

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.