ORA-28002 The password will expire within 7 days. Cannot logon to the database
The error “ORA-28002 The password will expire within 7 days. Cannot logon to the database” can be encountered when you run any process/job on the process scheduler. Many a times, the error is not limited to while running a job/process on the scheduler – it may show even for a portion of the application that needs to login to the database will face a similar error. For example, starting the Process Scheduler or Application Server or logging into the client workstation to use AppDesigner or nVision.
Such an error is usually reported because the PeopleSoft ‘ConnectID’ account and the ‘Sysadm’ account as defined in the Oracle database table, DBA_USERS table have expired. Prior to 11g, this issue never showed up because the accounts would never expire. From Oracle 11g onwards, they are hardcoded with an expiry date of 180 days.
How to Resolve “ORA-28002 The password will expire within 7 days. Cannot logon to the database”
Follow the steps mentioned below to resolve the issue:
- Logon to the product database as the SYSTEM user (not the application administration user).
- Find the profile.
SQL> select account_status, profile from dba_users where username=’the PeopleSoft ConnectID’;
SQL> select account_status, profile from dba_users where username=’sysadm’;
- Alter the profiles with the following SQL:
SQL>ALTER PROFILE <Profile value from step 2> LIMIT PASSWORD_LIFE_TIME UNLIMITED;
- Connect to the database via SqlPlus and change the schema password with the command
SQL>ALTER USER <PeopleSoft ConnectID> IDENTIFIED BY <current ConnectID password>;
SQL>ALTER USER SYSADM IDENTIFIED BY <current SYSADM password>;