This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
Remedy AR System Server
AR system server version 8.x, 9.x and higher version
If a new password is set in the Server Information > Database will it change in database?
If the password is changed in the database, how to change it in Remedy?
Question: If a new password is set in the Server Information > Database (tab) will it change in database?
Answer: No, the database password needs to be reset in the database side first and then you can reference the new password in Remedy.
Question: If the password is changed in the database, how do you change it in Remedy?
--- Note ---
Changing the password for the user ARADMIN (default) in the database it is something under the DBA team's scope.
The following can be done in the Database to change the password for the ARADmin database user
Oracle database, issue the following SQL statement when logged in as user system:
ALTER USER "ARADMIN" IDENTIFIED BY "AR#Admin#"
MSSQL database, issue the following SQL statement when logged into Query Analyser as sa:
sp_password 'oldpassword', 'AR#Admin#', 'ARAdmin'
(please check with the DBA Team to perform the above to be sure it is done correctly).
A) If ARSystem is already running after having changed the Database password by the DBA team, follow these steps:
1- Login into Remedy and go to Applications > AR System Administration > AR System Administration Console > System > General > Server information
2- Open the Database tab:
3- Enter the new Database password in the Database Password field which is blank.
4- Click Apply. Once the password is applied the field again becomes blank.
5- Restart ARSystem to take this into effect.
B) If ARSystem is NOT running after having changed the Database password by the DBA team, follow these steps:
1- Open the ar.cfg/ar.conf file and remove the encrypted password of the parameter Db-password:
2- Type the new password in plain text on this parameter.
For this example we will use the default password: AR#Admin#
3- Start ARSystem.
4- Once ARSystem is up and running the new password set in the previous step needs to be encrypted.
To do so, follow these steps:
a) Backup the ar.cfg/ar.conf file.
b) Login into Remedy and go to Applications > AR System Administration > AR System Administration Console > System > General > Server information
c) Open the Database tab.
d) Enter the new password in the Database Password field which will be blank.
e) Click Apply. Once the password is applied the field again becomes blank.
f) Restart ARSystem and the application will encrypt the password.
This can be checked by looking at the current ar.cfg/ar.conf file ( Db-password ).
Remedy - Server - Error:"ORA-28000: the account is locked" after changing the password to the database for the Oracle Account ARAdmin and AR Server is not starting up
Remedy - Server - ARSystem 9.1.03 installer throws the error: "ORA-01017: invalid username/password; logon denied"