ORA-28000: the account is locked

ORA-28000: the account is locked

ORA-28000: the account is locked

Login to SQL Plus client on the oracle database machine.

enter user-name: system

enter password: password [Only if, if you have not changed your default password while DB installation default password blank or SYSTEM]

Press enter. after which, you will be seeing the connection status.

Now,

SQL> ALTER USER [USER_NAME] ACCOUNT UNLOCK;

Press enter.

you will be seeing message: user altered.

Now try login with the user name on db client[sqldeveloper/dbeaver].

Comments