Submit a ticketCall us

Don’t fall victim to a ransomware attack
Backups are helpful, but sometimes that’s not enough to protect your business against ransomware. At our live webcast we will discuss how to protect against ransomware attacks with SolarWinds® Patch Manager and how to leverage log data to detect ransomware. Register now for our live webcast.

Home > Success Center > Database Performance Analyzer (DPA) > Monitor an Oracle database in an Amazon RDS environment

Monitor an Oracle database in an Amazon RDS environment

Table of contents

Overview

DPA 9.1 and later versions contain native support for Amazon RDS instances. If you are unable to upgrade to DPA 9.1, these instructions help you configure your earlier version of DPA to monitor SQL Server databases running in the Amazon RDS environment.

Environment

This article applies to DPA 9.0, Ignite 8.x

Steps

  1. Register another local instance temporarily. DPA versions 9.0 and earlier cannot register an Amazon RDS instance directly because higher level privileges are required than available. To do this, step through the registration wizard normally and register an instance on your desktop or some other test instance.
  2. Stop the new monitor immediately. This can be done by clicking the green arrow next to the instance on the DPA Home page or by using the Action dropdown.
  3. Create X$ views in the Amazon RDS instance owner's schema.
  4. Repoint DPA from the temporary local/test instance to the RDS instance.
    • Click Options > Update Connect Info.
    • Choose this new instance and click Next.
    • On the next screen, update all fields to point to the RDS instance and click Next.
    • The instance owner should be specified because DPA needs access to a handful of DBA and V$ views that cannot be granted to anothe user.
  5. Start the monitor for the RDS instance and Ignite should now be able to monitor the RDS instance.
Last modified
13:16, 13 Nov 2015

Tags

Classifications

Public