search cancel

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

book

Article ID: 113561

calendar_today

Updated On:

Products

CA Automic Applications Manager (AM)

Issue/Introduction

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 

 

Environment

Release:
Component: APPMGR

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.