AutoSys services failed to start; Error - Logon denied
Article ID: 18986
Updated On:
Products
Issue/Introduction
The scheduler and the application server fails to start with the following error messages after the database user 'autosys' password change on the database directly.
CAUAJM_E_18401 Function <Olog> invoked from <openProc> failed <232> CAUAJM_E_18402 ORA-01017: invalid username/password; logon denied
Environment
Release: Autosys Workload Automation 11.3.6 and later
Component:
Cause
The problem appeared due to the non-standard procedures to change the database user autosys password.
Resolution
Verify 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/2B4A60C0D02773E4E3FF7452033F9D3C
The encrypted string for autosys database user password can be created by using the autosys_secure command
$ autosys_secure
CA WAAE Security Utility
[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= 9AS7D8FT9E3E4E3F6F7452033F9E1Z
If the encrypted string returned by above does not match with encryption in the configuration file, update the encrypted password in the file $AUTOUSER/config.$AUTOSERV (replacing existing one).
Restart the CA WAAE services
Additional Information
autosys_secure utility (Option 3: Change database password) can be used to change the database user 'autosys' password. For more details go through the autosys_secure documentation -
Feedback
