search cancel

"ORA-20122: Login password has expired" error thrown during awinstall


Article ID: 113561


Updated On:


CA Automic Applications Manager (AM)


When running awinstall, the execution of the aw_post_checks script the fails with the following error:
Starting at 09/11/18 07:56:06 script aw_post_checks 
Finished at 09/11/18 07:56:10 Elapsed Time 00:00:04 script aw_post_checks 
errors=ORA-20122: Login password has expired ORA-06512: at "APPWORX.AWAPI2", line 473 ORA-06512: at "APPWORX.AWAPI", line 428 ORA-06512: at "APPWORX.ADD_OS_USER", line 35 ORA-06512: at line 37 
Fatal error trying to execute script aw_post_checks 

Fatal error trying to execute script aw_post_checks 
Fatal Error occurred - check the log /opt/am/install/aw_install.log 



Component: APPMGR


Specific user logins has an expired password.


Run the following sql to determine which users' passwords are set to expire while logged into sqlplus as the Applications Manager Oracle User:

SQL> select so_user_name from so_user_table where so_force_pw_change='Y';

This will give a list of users that will need to have the password expiration internal reset via Java Web Client.

Log into the Application Manager database and run the following sql:

SQL> update so_user_table set so_force_pw_change ='N' where 
SQL> so_force_pw_change ='Y';
SQL> commit; 

Once this is complete run through awinstall with option 1.