"ORA-28001: the password has expired"

(Doc ID 1377730.1)

Last updated on JANUARY 11, 2018

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 7.0 and later
Siebel CRM - Version 16.6 [IP2016] to 16.6 [IP2016] [Release V16]
Primavera P6 Professional Project Management - Version to [Release 16.2]
Information in this document applies to any platform.


Symptom #1:

When attempting to log into P6 Project Management, the following error is received:

"Unable to connect to database. Would you like to configure the connection now?"

When selecting 'Yes' to configure the database connection, the following error is received:

"Bad public user name or password. Database Server Error: ORA-28001: the password has expired"


Symptom #2:

When using the P6 Administration Application, receive the following error at login with the privileged username:

    Unable to resolve privileged username and password ORA-28001: the password has expired"


Symptom #3:

The following error is received when starting P6 from Weblogic:

Caused By: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: ORA-28001: the password has expired


Symptom #4:

The following error occurs when running databaselogins.bat:

"Unable to create connection from connect string privuser/*****@oracle:host:port:sid:SQLException (ORA-28001: the password has expired)"




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