ORA-28000 and I didnt change anything 1

[dreampolice]

I have a JSP web page that has worked with Oracle 9i for a couple years. Now lately I have this message coming up:
ORA-28000 which says my account it locked.

Please advise because I have not changed my password or login on this web page for several years.

ORA-28000 meaning from Google:

ORA-28000 
ORA-28000: the account is locked 
Cause: The user has entered wrong password consequently for maximum number of times specified by the user's profile parameter FAILED_LOGIN_ATTEMPTS, or the DBA has locked the account 
Action: Wait for PASSWORD_LOCK_TIME or contact DBA

 

[SantaMufasa]

Dream,

Yours is not a password problem...Someone with DBA privileges has locked your Oracle username from logging in. Here is the code they used, followed by the code they can use to unlock it:

SQL> alter user person account lock;

User altered.

SQL> alter user person account unlock;

User altered.

Contact your DBA, and have a conversation such as:

I received an error that my Oracle account is locked. Are you aware that it is locked? If so, is there a situation of which I should be aware? Can you please unlock it for me?

Let us know how things go.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[dreampolice]

Thanks!