Alternative process to change Applications Manager password

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

There is a simpler alternative way of changing the Applications Manager Oracle password compared to what is written in the documentation. Below is the process for this.

Environment

Release : 9.3

Component :

Resolution

1. Stop all processes with 'stopso all' command in Unix/Linux or stop watchworx service in Windows.

2. Change the password in Oracle. This generally requires the DBA to log into Oracle and run the sql "Alter user <USER> identified by <pw>; ". However please refer to DBA for this step.

3. Sqlplus into Oracle with the new password

4. Run the below sql:
update so_ids set so_encrypted = 'N' where so_login = '<AM Oracle user>';
commit;

5. Update the password with below sql and commit:
update so_ids set so_passwd = '<new_DB_password>' where so_login = '<AM Oracle user>';

6. Exit Sqlplus and make a backup of the Masters.properties file

7. Run awinstall until ONLY AFTER you enter in the new password. Then you can go ahead and quit. You will see below that a new Masters.properties file is created.

If needed, please refer to Article 92389 which details how to run awinstall.

8. Restart all processes with 'startso all' comand in Unix/Linux or start the AM watchworx service in Windows

9. Run the command 'awexe id_recrypt' to re-encrypt password that was unencrypted in step 4.

Password change complete