Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

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

Tags

Classifications

Public