How to Change the DPA repository password and Web Console Admin Password

11/21/2018 5:45 PM

3/2/2026 5:21 PM

If you have forgotten the repository password or need to change it, complete the following steps to change the password.

The Repo DB user name and password in the repo.properties files is the same as the DPA Web Console Admin user name and password.

Database Performance Analyzer

1. Determine the location of the repository and the DPA login name. This information is displayed on the DPA login page above the User and Password fields next to the Repository label.
2. Using SQL Server Management Studio, Oracle Enterprise Manager or another tool, reset the password for the DPA login (from step 1)
3. Determine where the DPA Server resides. This information is located in your URL. For example, if your URL to access DPA is http://yourDPAserver1:8123/iwc/login.iwc then the DPA Server is named your 'DPAserver'.
   • Note: In this example, the DPA repository database and DPA Server can both located on 'yourDPAserver' but they can reside on physically different machines.
4. Log on to the DPA server operating system and open the repo.properties file in a text editor:
   • Windows: The default location of this file is in the {DPA_home} \iwc\tomcat\ignite_config\idc directory
   • Linux or Unix: The default location of this file is in the {DPA_home} /iwc/tomcat/ignite_config/idc directory 
     where {DPA_home} is the top level directory where Ignite/DPA was installed.
5. STOP DPA.
6. In the repo.properties file, modify the repo.password line to reflect the same password you used in Step 2. Type the password in clear text. Later on, DPA will encrypt the password for you.
7. After saving the file, restart DPA.

Note: Please avoid '@' sign in your password (e.g P@ssword) as it may affect the connection