Submit a ticketCall us

Announcing NPM 12.2
With NPM 12.2 you can monitor your Cisco ASA firewalls, to monitor VPN tunnels for basic visibility and troubleshooting tunnels. NPM 12.2 also uses the SolarWinds Orion Installer so you can easily install and upgrade one or more Orion Platform products simultaneously.
See new features and improvements.

Home > Success Center > Server & Application Monitor (SAM) > Monitor Open Database Connectivity (ODBC) connection between Oracle and another server

Monitor Open Database Connectivity (ODBC) connection between Oracle and another server

Table of contents

Overview

This article provides steps to monitor Oracle connection errors within Windows Event logs.  

There is no true way to monitor an ODBC connection between an Oracle system and another server.  However, there is a way to monitor for Oracle connection errors within the Windows Event logs.

Environment

  • All SAM versions 
  • All Windows versions

Steps

The following steps describe how to assign the Errors in Application Event Log template to the system with the target Event Logs:

 

1. Go to Settings > SAM > SAM Settings > Manage Templates.
2. Search for Event log.
3. Select the following template and assign it to the Node: Errors in Application Event Log
4. Go to Settings > SAM > SAM Settings > Manage Applications.
5. Find the Errors in Application Event Log, select it and click Edit.
6. Open the Windows Event Log Monitor settings and set it as follows:

  • Match Definition: Custom
  • EventID: Match only specific IDs and enter '10' as the value
  • Include events: With Keywords below and enter value "SQL Error: [[Oracle][ODBC][Ora]"


7. Leave everything else as is and click Submit.

For more information on the Windows Event Log, see Windows Event Log Monitor 

 

 

Last modified
17:52, 23 Nov 2016

Tags

Classifications

Public