Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

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

Tags

Classifications

Public