ORA-28000: the account is locked error getting frequently

oracle oracle11g oracle10g
Thush picture Thush · Nov 11, 2014 · Viewed 205.2k times · Source

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?

Answer

Varun Jain picture Varun Jain · Nov 11, 2014

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.

Related questions

Oracle PL/SQL string compare issue

I have the following Oracle PL/SQL codes that may be rusty from you guys perspective: DECLARE str1 varchar2(4000); str2 varchar2(4000); BEGIN str1:=''; str2:='sdd'; IF(str1<>str2) THEN dbms_output.put_line('The two strings is …

Read More
When should I use 'for update nowait' in cursors?

In which case do we need to use for update nowait in cursors.

Read More
BETWEEN clause versus <= AND >=

Is there a performance difference between using a BETWEEN clause or using <= AND >= comparisons? i.e. these two queries: SELECT * FROM table WHERE year BETWEEN '2005' AND '2010'; ...and SELECT * FROM table WHERE year >= '2005…

Read More