How To Change the Autosys database password
search cancel

How To Change the Autosys database password

book

Article ID: 229434

calendar_today

Updated On:

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.