Submit a ticketCall us

Announcing NCM 7.7
With NCM 7.7, you can examine the rules that make up an access control list for a Cisco ASA device. Then you can apply filters to display only rules that meet the specified criteria, order the rules by line number or by the hit count, and much more.
See new features and improvements.

Home > Success Center > Database Performance Analyzer (DPA) > DPA 11.0 Administrator Guide > Register a database instance for monitoring > Register an Oracle database

Register an Oracle database

Created by Anthony.Rinaldi_ret, last modified by Anthony.Rinaldi_ret on Sep 15, 2016

Views: 134 Votes: 0 Revisions: 3

To register an Oracle database for DPA to monitor:

  1. On the DPA home page, click Register DB Instance for Monitoring.
  2. Under Self-Managed, click Oracle.
  3. Click Next.

Enter connection information

Oracle database instances have three connection options:

  • Direct Connect
  • Transparent Network Substrate (TNS) Connect Descriptor
  • Lightweight Directory Access Protocol (LDAP) or TNS Name

SolarWinds DPA will monitor all databases within the instance. If more than one instance exists on the server, you must register each instance separately in DPA.

Connection options

Direct Connect

Enter the Service Name or System Identifier (SID), host name or IP address, and port. The default port is 1521.

TNS Connect Descriptor

The Connect Descriptor value contains everything after NAME= in the tnsnames.ora file. The beginning (DESCRIPTION= is necessary. For example:

(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = demo.confio.com)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = demo)))

LDAP or TNS Name

To use this option, Oracle Name Resolution must be configured. For instructions, see Connect to Oracle using name resolution.

After you configure Oracle Name Resolution, you can use the LDAP/TNS Name when registering additional monitored database instances.

SolarWinds DPA uses the Oracle network configuration .ora files to connect to the database instance.

If connection information other than the name has changed, update the .ora files. SolarWinds DPA detects changes to these files automatically. You do not have to update the connection information through this wizard.

If the name has changed, update the .ora files. Then select the check box next to LDAP/TNS Name, and update the value.

RAC instances

If this is an Oracle Real Application Clusters (RAC) instance, there may be listener configuration changes needed if you are not listening on the physical IP address. SolarWinds recommends:

  • If you are registering pluggable databases (PDBs) on a RAC instance, consider registering with the physical IP address of the host.
  • If you are registering a non-PDB RAC instance, consider registering with the SID.
  • If you are using the Service Name, consider using the physical IP address of the host. Do not use the virtual IP address (VIP) or the Oracle Single Client Access Name (SCAN) IP address.

DBA user

Enter DBA credentials for SolarWinds DPA to register the database instance.

Enter the monitoring user

SolarWinds DPA gathers information through this user from the monitored instance.

You can create a monitoring user through SolarWinds DPA, or use an existing user.

Allow DPA to create the user

SolarWinds recommends this method because SolarWinds DPA requires special permissions that existing users may not have.

  1. Next to Create Monitoring User, click Yes.
  2. Enter the user name and password.
  3. Select a Tablespace and Temp Tablespace on the monitored database. This is primarily used for gathering Explain Plan data for monitored queries.

Create the user manually

If you create the user manually, SolarWinds DPA uses the default Tablespaces for that user.

  1. Next to Create Monitoring User, click No.
  2. Enter the user name and password.

If you are registering multiple Oracle Real Application Clusters (RAC) nodes, you may receive an error that the user already exists. You can create a different monitoring user or clear the Create a New Monitoring User check box and continue.

Oracle monitoring information

Is the Oracle E-Business Suite enabled?

If the monitored instance contains the Oracle E-Business Suite, SolarWinds DPA can collect additional information about the suite.

SolarWinds DPA can capture Oracle E-Business data to identify the screens, modules, and users generating the database requests. This gives you increased visibility into the causes of performance problems in the Oracle E-Business Suite, Oracle Enterprise Resource Planning (ERP), and Oracle Applications environments.

The SYS password

The SYS password is requested only if remote login as SYS is enabled on the monitored Oracle instance. This option is not available for Amazon RDS instances.

If you do not have remote SYS access to the computer, click the link to open the Manual Steps for Monitored Database Instance Registration.

Register the monitored database instance manually

This window contains a script to run on the monitored instance. This script installs a utility package for SolarWinds DPA that grants Execute permissions for that package to the monitoring user.

  1. Click Select All, copy the script, and paste it into a text file.
  2. As an Oracle Administrator, log in as SYS to the database instance to be monitored.
  3. Access the text file.
  4. Execute the script.

Oracle repository tablespace

If your repository database is not Oracle, the wizard skips this step.

Choose the tablespace in the repository database to store DPA performance data for this monitored instance.

By default, the performance data is stored in the default tablespace of the repository user. However, data for monitored instances can be stored in separate tablespaces.

Select the Alert Groups

If you have no Alert Groups set up, or if this new database instance does not match the database type of the Alert Group, the wizard skips this step.

Alert Groups simplify alert configuration and help make alerting more consistent across the monitored database instances.

Select the Alert Groups you want the new database instance to join.

Summary

  1. Confirm the registration information, and click Register Database Instance.
  2. Click Finish to go to the DPA home page, or click Register Another Database Instance to continue registering.
Last modified
14:05, 15 Sep 2016

Tags

Classifications

Public