Home > Success Center > Database Performance Analyzer (DPA) > Change the DPA password globally for Oracle

Change the DPA password globally for Oracle

Introduction

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
Viewing 2 of 2 comments: view all
Interspire author is Mindy Guinn
Posted 19:11, 26 Jun 2015
Interspire author is Mindy Guinn
Posted 19:38, 14 Aug 2015
Viewing 2 of 2 comments: view all
You must to post a comment.
Last modified
01:07, 23 Jun 2016

Tags

Classifications

Public