Unable to use autosys_secure to change the autosys database users password. CAUAJM_E_18402 ORA-28221: REPLACE not specified.

Document ID : KB000048284
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

When using autosys_secure to try to change the autosys database password the following error is generated:

CAUAJM_E_18416 SQL Query <ALTER USER autosys IDENTIFIED BY "password#"> failed
CAUAJM_E_18402 ORA-28221: REPLACE not specified

Solution:

This error is due to the Oracle "verify password function" being active. The verify password function needs to be turned off while using autosys_secure to change the password because at this time the autosys_secure utility does not allow the current password to be transmitted. Once the password is changed using autosys_secure, one may re-enable the "verify password function"