FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals / Oracle Forum / ORA - Oracle Database Error Codes - Search via specific error codes. / ORA-20000 Through ORA-29968 / ORA-28000: the account is locked ora error / Latest Posts

RE: ORA-28000: the account is locked ora error

Admin — Tue, 22 Jun 2010 13:15:42 GMT

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

ORA 28000

ORA-28000: the account is locked ora error

Admin — Fri, 11 Jun 2010 11:20:00 GMT

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

When you get this ora error and, if you want to unlock account called SCOTT follow these steps.

From your command prompt, type
sqlplus "/ as sysdba"

Once logged in as SYSDBA, you need to unlock the SCOTT account

SQL> alter user scott account unlock;