References > Aliases > Monitoring an Oracle Database on an Existing Node

Monitoring an Oracle Database on an Existing Node

If an Oracle database server is already being monitored by SAM as a node, perform the following steps to configure the node:

  1. In the SAM web console, navigate to Settings > SAM Settings > Manage Templates
  1. Search for the Oracle Database Template, select it by checking the box next to the name.
  2. Click Assign to Node.
  1. Next, search for Oracle.
  2. Once found, check the nodes you want to add.
  3. Click the green arrow to add it to the Selected Nodes column.
  1. The Oracle node will be moved to the Selected Nodes column.
  1. Click Next.
  2. Select the credentials to be used and then click Assign Application Monitors.
    Note:
    Do not test the application now. This application is not properly configured. There are settings specific to the Oracle server which will be set later.
  1. Click Edit to go to the Edit Application page.
  1. Expand each monitor by clicking [+]to the left of each component monitor in the list.
  1. The correct settings for the fields Destination Point Type and Destination Point Name (highlighted above) should be provided by the administrator of the Oracle server. This example is testing against the Oracle 10g Express Edition, which is configured to have the name "XE."
  1. Repeat steps 11-12 for each monitor in this template. Use the following table for reference:

 

Oracle Driver Type setting in Web UI

Oracle Client package

Microsoft .NET Data Provider
(MS_ORACLECLIENT)

Oracle Data Provider for .NET (ODP.NET)

Full Oracle Data Provider for .NET (ODP.Net

Works

Works

Basic Lite Oracle Client (from SolarWinds Customer Portal)

Works

Does not work