ORA-28000 the account is locked error getting frequently

Question

I am getting the error     ORA-28000  the account is locked    Is this a DB Issue  When I unlock user account using the command ALTER USER username ACCOUNT UNLOCK temporarily it will be OK  Then after some time the same account lock happens again   The database using is oracle XE  Does anybody else have the same issue

User · Accepted Answer

One of the reasons of your problem could be the password policy you are using.

And if there is no such policy of yours then check your settings for the password properties in the DEFAULT profile with the following query:

SELECT resource_name, limit
FROM dba_profiles 
WHERE profile = 'DEFAULT'
AND resource_type = 'PASSWORD';

And If required, you just need to change the PASSWORD_LIFE_TIME to unlimited with the following query:

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

And this Link might be helpful for your problem.

User · Answer

I have faced this similar issue and resolved it by using following steps     Open windows command prompt  Login using the command sqlplus    as sysdba  Then executed the command alter user HR identified by password account unlock   Please note  the password is the password that I have used   By using above steps you can connect to Oracle Database as user HR with the password password

User · Answer

Check the PASSWORD LOCK TIME parameter  If it is set to 1 then you won t be able to unlock the password for 1 day even after you issue the alter user unlock command

User · Answer

Way to unlock the user      sqlplus   nolog SQL  gt  conn sys as sysdba SQL  gt  ALTER USER USER NAME ACCOUNT UNLOCK    and open new terminal   SQL  gt  sqlplus   as sysdba connected SQL  gt  conn username password    which username u gave before unlock    it will ask new password password it will ask re-type password password press enter u will get loggedin

User · Answer

Here other solution to only unlock the blocked user  From your command prompt log as SYSDBA   sqlplus    as sysdba    Then type the following command   alter user  lt your username gt  account unlock

User · Answer

Solution 01  Account Unlock by using below query    SQL gt  select USERNAME ACCOUNT STATUS from dba users where username  ABCD DEV       USERNAME             ACCOUNT STATUS -------------------- -------------------------------- ABCD DEV       LOCKED  SQL gt  alter user ABCD DEV account unlock      User altered   SQL gt  select USERNAME ACCOUNT STATUS from dba users where username  ABCD DEV       USERNAME             ACCOUNT STATUS -------------------- -------------------------------- ABCD DEV       OPEN   Solution 02  Check PASSWORD LIFE TIME parameter by using below query    SELECT resource name  limit FROM dba profiles WHERE profile    DEFAULT  AND resource type    PASSWORD    RESOURCE NAME                    LIMIT -------------------------------- ------------------------------ FAILED LOGIN ATTEMPTS            10 PASSWORD LIFE TIME               10 PASSWORD REUSE TIME              10 PASSWORD REUSE MAX               UNLIMITED PASSWORD VERIFY FUNCTION         NULL PASSWORD LOCK TIME               1 PASSWORD GRACE TIME              7 INACTIVE ACCOUNT TIME            UNLIMITED   Change the parameter using below query  ALTER PROFILE DEFAULT LIMIT PASSWORD LIFE TIME UNLIMITED

User · Answer

Login to SQL Plus client on the oracle database server machine   enter user-name  system  enter password  password  Only if  if you have not changed your default password while DB installation   press enter  after which  you will be seeing the connection status   Now   SQL gt  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

[oracle] ORA-28000: the account is locked error getting frequently

Examples related to oracle

Examples related to oracle11g

Examples related to oracle10g