Tuesday, July 6, 2010

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

One of our Primavera user tried to login to Project Management it is coming up with , and the user select to configure the database connection, but in the end, it gave the following error message:
"Bad public user name or password. Database Server Error: ORA-28001: the password has expired;"

I helped them to fix by the steps below:

1. Open a DOS Prompt, and type the command below:
sqlplus /as sysdba

2. After you see the SQL prompt, type the SQL statement below:

CREATE PROFILE Primavera_Profile LIMIT PASSWORD_LIFE_TIME UNLIMITED;

alter user pubuser PROFILE Primavera_Profile;
alter user privuser PROFILE Primavera_Profile;

NOTE: the user above may need to be changed if pubuser1 or privuser1 is used.
3. Try to launch your PM6 again.

No comments:

Post a Comment