Home » RDBMS Server » Server Administration » Help required with ORA - 28000 Error
Help required with ORA - 28000 Error [message #242641] Mon, 04 June 2007 09:02 Go to next message
suranjita_hajra_7
Messages: 20
Registered: November 2006
Location: Pittsburgh, USA
Junior Member

Hello all,

I have an user who is getting ORA - 28000 Error, while connecting to an instance, she has connected to this instance successfully several times earlier. Myself and several other users are able to connect to the same instance.
How to resolve this issue and help the user to get connected to that instance successfully, please advise me.

Thanks a lot for cooperation in advance.

Regards,
Suranjita
Re: Help required with ORA - 28000 Error [message #242650 is a reply to message #242641] Mon, 04 June 2007 09:38 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please learn how to lookup error codes.

28000, 00000, "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
Re: Help required with ORA - 28000 Error [message #242654 is a reply to message #242650] Mon, 04 June 2007 10:01 Go to previous message
suranjita_hajra_7
Messages: 20
Registered: November 2006
Location: Pittsburgh, USA
Junior Member

No that was not the reason, I know what ORA-28000 means....I just discovered the cause of the error, it is not as straight forward as just the user failed to put correct password for those number of times as specified in falied_login_attempts. This is because her tnsnames.ora got corrupted....I corrected the entry in tnsnames.ora file and she is fine with her connection.
Previous Topic: 2 profiles for oracle user on solaris
Next Topic: LOG PARALLELISM
Goto Forum:
  


Current Time: Fri Sep 20 09:31:44 CDT 2024