Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

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
19:07, 22 Jun 2016