How To Change the Autosys database password

Products

• Autosys Workload Automation

Issue/Introduction

This document provides a comprehensive guide for updating the Autosys database password, covering all necessary steps to ensure a smooth and secure transition.

Environment

Component: CA Workload Automation AE (AutoSys)
Release: All releases

Cause

Error:

CAUAJM_E_18401 Function <Olog> invoked from <openProc> failed <232> CAUAJM_E_18402 ORA-01017: invalid username/password; logon denied 

Resolution

1. Check if the encrypted password in the config file is the same as the current password of the autosys user in database.
   $AUTOUSER/config.$AUTOSERV

#+---------
#
# Keyword: DBAccess=username/password
#
# Defines the user name and password (in encrypted format) used by
# the scheduler and application server to connect to the database.
# The database user name and password is defined during the CA
# Workload Automation AE installation.
# DBAccess=autosys/################################



2. Find the encrypted password of the current autosys user by using the autosys_secure command
   
   $ autosys_secure

   

   CA WAAE Security Utility 

Please select from the following options:

   [1] Activate CA EEM instance security.
[2] Manage EDIT/EXEC superusers.
[3] Change database password.
[4] Change remote authentication method.
[5] Manage user@host or user@domain users.
[6] Get encrypted password.
[0] Exit CA WAAE Security Utility.
>  6
 
Get encrypted password
 
Please select from the following options:
[1] Encrypt password for instance configuration (using AES).
[2] Encrypt password for legacy agents and adapters (using DES).
[9] Exit from "Get encrypted password" menu.
[0] Exit CA WAAE Security Utility.
>  1
 
Enter password:  ******
 
Enter confirmation password: ******
 
CAUAJM_I_60062 Password= ################################

   

3. If these passwords do not match then copy this encrypted password to the $AUTOUSER/config.$AUTOSERV file and restart the CA WAAE services
   
   Note: After updating the password in the configuration file and restarting WAAE services, to update the encrypted password for autosys in AEDB table, use autosys_secure as follows:
   

   $ autosys_secure


CA WAAE Security Utility

   
   Please select from the following options:
[1] Revert to NATIVE instance security.
[2] Manage CA EEM security settings.
[3] Change database password.
[4] Change remote authentication method.
[5] Manage users.
[6] Get encrypted password.
[0] Exit CA WAAE Security Utility.
>  3

   Enter current password:

   Enter new password:

   Enter new password again:

   CAUAJM_I_60059 Password change successful.