[ORACLE] ORA-28002 the password will expire within 7 days. Cannot log on to the system

Error "ORA-28002 the password would expire within 7 days. Cannot logon to the database "This error may be encountered when running the AE program on the process scheduler, and many times this error is not only present in the process scheduler, but may also be used when accessing the database using Plsql developer or Sqlplus.

This error is due to the Connectid account or Sysadm account in the Dba_users table has expired, before the 11g version of the problem has never occurred, because the account settings will never expire, in the later version of 11g, they are hardcoded for the validity of 189 days.

How to fix "ORA-28002 the password would expire within 7 days. Cannot logon to the database "

Follow these steps to resolve the issue:

1. Log in to the database using the SYSTEM account (not Sysadm)

2.

Sql> Select Account_status, profile from Dba_users where Username= ' the PeopleSoft connectid ';
Sql> Select Account_status, profile from dba_users where username= ' sysadm ';

3, modify with the following statement.

Sql>alter profile <profile value from step 2> LIMIT password_life_time UNLIMITED;

4. Log in to the database using Sqlplus and change the password using the following command.

Sql>alter USER <peoplesoft connectid> identified by <current Connectid password>;
Sql>alter USER SYSADM identified by <current SYSADM password>;

If you feel helpful, maybe you'll appreciate that the IOS dedicated channel of appreciation:

[ORACLE] ORA-28002 the password will expire within 7 days. Cannot log on to the system