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 · 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> 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].

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

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

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

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

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

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

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

Examples related to oracle

Examples related to oracle11g

Examples related to oracle10g