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) > Change the DPA password globally for Oracle

Change the DPA password globally for Oracle


For companies that have policies to change passwords often, this document will walk through a process developed to change DPA monitoring passwords for Oracle instances through a combination of scripts and the DPA interface.

Note: This document does not apply to changing the DPA repository password. That process is covered in this KB article.

Get a list of instances where the DPA monitor is running

If an instance is not currently being monitored, this process does not make any modifications to it in case there are connection issues. Any instance not being monitored can have the password changed manually via the process outlined in this KB article.

Note: The SQL statements in this document can be run from the Database Query Tool in DPA or SQL*Plus.

The following SQL statement is used to get a list of databases that are currently being monitored and save to a temporary table. Run this from the DPA repository:


create table ignite_running as
select id, name, username, password, status, command
from cond where status = 'STARTED' and db_type = 'Oracle';

Stop all running monitors to modify passwords

Run the following from the DPA repository:


update cond set command='STOP'
where id in (select id from ignite_running);
commit; -- only needed if running from SQL*Plus

At this point all DPA monitors are now currently stopped and ready for the password change.

Update the DPA user password on each monitored instance in DPA

This step uses a DPA alert to change the DPA user password on each monitored instance. This alert will fail, but the alter user command will execute successfully and change the DPA password on each instance. The alert should be marked as inactive so it does not run automatically. Use the Test Alert button to execute the alert and change the password on all instances.

Change an instance password in DPA

This step is needed to get the encrypted version of the new password used in step 2. Click Options > Update Connection Info, and follow the wizard to change the password for one instance.

Get the encrypted version of the new password from the DPA repository

select id, name, password from cond where lower(name) like lower('%&InstanceName%')

Update all passwords in the DPA repository and start the monitors

update cond set password = '&NewEncryptedPassword', command='START'
where id in (select id from ignite_running);

Remove the IGNITE_RUNNING table

drop table ignite_running
Last modified