Database Password change activity for Autosys and WCC

Products

• CA Workload Automation AE - Scheduler (AutoSys)

Issue/Introduction

We have to perform password change activity for autosys r12 application, EEM, wcc  & DB . The autosys and WCC is using Oracle database

Environment

Release : 12.X, 24.X

Component : CA Workload Automation AE (AutoSys), WebUI(WCC)

Resolution

The main difference is that the autosys services needs to be stopped during this process whereas WCC the services needs to be running as we need to use the batch interface to change the password

 

Database password change for Autosys

Changing the password for 'aedbadmin'

After your DBA has updated the password for 'aedbadmin', there is nothing else you need to do with this user.

Changing the password for 'autosys'
For standalone single server install we can use "change database password" option 3 of the autosys_secure command, the local configuration file is automatically updated.

For a HADS you can generate DBAccess parameter password in AES encrypted format using the autosys_secure command (using option 6 and then option 1)

We need to update the encrypted password in all the config files in the 3 schedulers in HADS

DBAccess

 

 

Database password change for WCC

Your DBA can change the database password in sqlplus

Then rather than following the wcc_config command right away, follow the steps indicated in this article How to change database user credentials in WebUI/WCC?  

Note: wcc_config command needs to be run with a -u  option where, the value for that is a WCC user with Commander privileges.