autosys db password over 20 characters
Article ID: 130897
Updated On:
Products
CA Workload Automation AE - Business Agents (AutoSys)
CA Workload Automation AE - Scheduler (AutoSys)
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.
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
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.
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.
Feedback
Yes
No
Powered by
