Problem: ORA-28000: the account is locked
Cause: This happens for reasons galore. Some of them being as follows:
SQL> alter user scott identified by tiger account unlock;
For more explanation on this read Oracle DBA Tips or even better take deep dive by buying the coolest book Oracle Database 10g: The Complete Reference (Osborne ORACLE Press Series)![](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_se3Q7cSkv3obF2zwLXpFkPjeltUzonYdgZU9Tv5LZXaeI_4_PeifYb3cJBaI3M89pURtFLt4ZfkUUmMfbsffKw5_PaktYtTOoDN4ZkOtWC-VJsPjiiAaT4Z1odz-lQRUJBZX2b31q2xpw5wIhpg5URVs-ZO8aqQXSOXJi01w40_NQ=s0-d)
Cause: This happens for reasons galore. Some of them being as follows:
- if bad password is provided more than the permissible number of times, then the account gets locked
- the DBA has locked the specific account for some reason
SQL> alter user scott identified by tiger account unlock;
For more explanation on this read Oracle DBA Tips or even better take deep dive by buying the coolest book Oracle Database 10g: The Complete Reference (Osborne ORACLE Press Series)