[Fix]-ERROR ORA-28000 the account is locked
ORA-28000: the account is locked
Scenario:
The following command is used to login into the DB server: sqlplus admin/admin@tstdb1. It was working fine the previous day, but now error occurs as ORA-28000: the account is locked.
Fix:
Unlock the account with the below steps:
- Open SQL Plus
- Login as SYSDBA as shown below:
- SQL> conn /as sysdba
- Unlock the account with below command:
- SQL> ALTER USER username ACCOUNT UNLOCK;
- Alternatively to lock the account use below command:
- SQL> ALTER USER username ACCOUNT LOCK;