[Fix]-ERROR ORA-28000 the account is locked

Wikitechy | 1439 Views | oracle | 28 May 2016

 

ORA-28000: the account is locked

Scenario:

The following command is used to login into the DB server: sqlplus admin/[email protected]. 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;



Workshop

Bug Bounty
IOT Hackathon
Webinar

Join our Community

Advertise