Fix ORA-28011: the account will expire soon; change your password now

Fix ORA-28011: the account will expire soon; change your password now

1. check  user profile 

SQL>select USERNAME,ACCOUNT_STATUS,PROFILE from  dba_users where USERNAME = <USERACCOUNT>;

2. view Profile setting and change expire parameter to unlimit

SQL>select * from dba_profiles where profile = <USER_PROFILE>;

SQL>alter profile <USER_PROFILE> LIMIT PASSWORD_LIFE_TIME UNLIMITED;

3. change password and commit

SQL> alter user <username> identified by <passwd>;

SQL> commit;