E-PRCS: ORA-28002 - The Password Will Expire In N Days, Cannot Logon To The Database (Doc ID 1282214.1)

Last updated on DECEMBER 21, 2015

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.49 and later
Information in this document applies to any platform.
This error affects any portion of the application that has a need to access the database. For example, the Process Scheduler, Application Server, 2 and 3 tier client connections to AppDesigner, nVision etc.


***Checked for relevance on 21-Dec-2015***

Symptoms

Environment Info
----------------
Oracle 11g

Errors
------
When any process is run to the Scheduler, it fails with the message: "ORA-28002 The password will expire within 7 days.  Cannot logon to the database."

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to PeopleTools - Process Scheduler - System Process Requests.
2. Choose any run control id and submit it to the Scheduler.
3. Observe the process errors out with the above error message.

Similarly, any 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.

Changes

The database had been upgraded to 11g roughly 6 months prior.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms