Posted 6/11/2010 11:20:00 AM
|
|
|
|
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;
|
|
Posted 6/22/2010 1:15:42 PM
|
|
|
|
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 |
|
|
|
|