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

Document ID : KB000113561
Last Modified Date : 11/09/2018
Show Technical Document Details
Issue:
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 

 
Cause:
Specific user logins has an expired password.
Resolution:
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.