autosys db password over 20 characters

book

Article ID: 130897

calendar_today

Updated On:

Products

CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) CA Workload Automation Agent

Issue/Introduction

When trying to update the 'autosys' db user password via autosys_secure, it gives the following message if the password is over 20 characters long:

CAUAJM_E_60076 Password exceeds 20 characters in length. 
CAUAJM_I_60074 Please try again. 

Oracle 12c R2 has a limit of 30 characters for a db user by default (consult your DBA for info on extending the identifiers to more than 30 characters).
Some government regulations require passwords of at least 28 characters in length for compliance.

Environment

Workload Automation AE (Autosys) 11.3.6 SP7 and SP8
Oracle 12c R2

Resolution

To configure an 'autosys' db user password of over 20 characters in length:

1.- Run 'autosys_secure'
2.- Select option 6 : '[6] Get encrypted password.'
3.- Select option 1 : [1] Encrypt password for instance configuration (using AES).
4.- Enter the password and confirm the password to get the encrypted value
5. Add the encrypted value to the $AUTOUSER/config.$AUTOSERV file manually in the DBAccess parameter:
DBAccess=autosys/<encrypted_value>

Example:
DBAccess=autosys/2B4A60C0D84591E4E3FF7452033F9D3C

6. Stop all Schedulers and Application Servers present in the autosys instance
7. Update the 'autosys' db user password (identifier) directly in Oracle. Do this on both dbs if running DUAL Server mode.
8. Start the Schedulers and Application Servers

This will allow AutoSys to use a password over 20 characters in length for the 'autosys' db user.