Documentation forHybrid Cloud Observability Essentialsand Server & Application Monitor

Configure SAM to monitor Oracle database servers

The following templates use the Oracle User Experience Monitor to assess the status and performance of Oracle databases:

The Oracle User Experience Monitor does not support polling via SolarWinds Platform Remote Collectors.

To support the Oracle User Experience Monitor, install one of the following drivers on the SolarWinds Platform server and any Additional Polling Engines (APEs) in your environment:

Note the following details about these drivers:

Install the Oracle Client on SolarWinds Platform server and APEs

SolarWinds provides updated Oracle database client connectivity libraries in a file that replaces the legacy Basic Lite Client.

  1. Log in to the SolarWinds Platform server.
  2. Check for a legacy Oracle Client and remove it, if necessary.
  3. Download the Oracle Client Installer and extract compressed files.
  4. In File Explorer, run OracleClientInstaller.exe.
  5. When installation is complete, verify that files were added to the following default folder:
    C:\Program Files (x86)\Solarwinds\Orion\APM\OracleClient.
  6. Repeat these steps to install the Oracle Client on APEs, if necessary.
  7. Configure accounts and permissions, as described next.

To learn more about monitoring Oracle servers with SAM, see:

Configure accounts and permissions

Account requirements to monitor Oracle database servers with SAM include:

  • The SolarWinds Platform account running SolarWinds Platform services has Full Control privileges for files in the following default folder:
    C:\Program Files (x86)\Solarwinds\Orion\APM\OracleClient.
  • Oracle server credentials have Read access to the following Oracle views:
    • dba_free_space
    • v$sysstat
    • v$rowcache
    • v$librarycache
    • v$sgastat
    • v$session

Individual SAM templates may have additional account requirements, as described in:

If messages such as: Table or view doesn't exist appear, check permissions for Oracle accounts used to run SQL statements, as defined in the Oracle User Experience Monitor.

Remove the legacy Basic Lite Client

If your environment includes existing installations of the legacy Basic Lite Client provided by SolarWinds for earlier versions of SAM (for example, SAM 6.3), follow these steps to remove them before installing the latest Oracle drivers.

  1. Log in to the SolarWinds Platform server.
  2. Use the SolarWinds Platform Service Manager to stop SolarWinds Platform services.
  3. In File Explorer, navigate to the default installation folder:

    C:\Program Files (x86)\Solarwinds\Orion\APM\OracleClient.

  4. Delete SolarWinds Platform Client files.
  5. Repeat these steps for each APE in your environment.