"ORA-28001: the password has expired" (Doc ID 1377730.1)

Last updated on JANUARY 18, 2017

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]
Information in this document applies to any platform.

Symptoms

Symptom #1:

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

ERROR
-----------------
"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:

ERROR
-----------------
"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:

    ERROR
    ----------------
    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:

ERROR
----------------
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:

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

 

 

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