Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

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

Register an Amazon RDS for Oracle database

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

Views: 41 Votes: 0 Revisions: 4

Updated: November 62017

To register an Amazon RDS for Oracle database for DPA to monitor:

  1. On the DPA homepage, click Register DB Instance for Monitoring.
  2. Under Amazon RDS, click Amazon RDS for Oracle.
  3. Click Next.
  4. Complete the wizard panels as described in the following table.

If registration fails because your DPA server cannot connect to the instance's server, see DPA database registration failure when attempting to register a database on an external network.

Panel Instructions
Enter Monitored Database Instance Connection Information

Amazon Relational Database Service (RDS) for Oracle database instances have three connection options:

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

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.

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

Create or specify the account that DPA will use to gather information. To ensure that the account has the required permissions, SolarWinds recommends creating a new account.

To create a new account:

  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.

To specify an existing account:

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

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

Oracle Monitoring Information

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 option is not available for Amazon RDS instances.

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 Review the information and click Register Database Instance.
Database Instance Registration Complete Click Finish to return to the DPA homepage.
Last modified

Tags

Classifications

Public