Oracle Database Discussions

hi,
when i am trying to change the password, I am getting the following error.
alter user KESDLMS111 identified by lms;
ORA-28007: the password cannot be reused
but i want to reuse the password,

SQL> ALTER PROFILE KESDLMS LIMIT
2 PASSWORD_LIFE_TIME UNLIMITED
3 PASSWORD_GRACE_TIME 10
4 PASSWORD_REUSE_TIME 300
5 PASSWORD_REUSE_MAX UNLIMITED
6 FAILED_LOGIN_ATTEMPTS 3
7 PASSWORD_VERIFY_FUNCTION NULL ;

this is wat the profile i defined and assigned to the user kesdlms111.similarly i altered the DEFAULT profile with same settings and assigned to other user.

even then i am unable to reuse the password.
u see i hav set the password_max_reuse to unlimited.

here i hav listed resources name in the profile and users assigned to that profiles

here i hav doubt on "lock_profile" i dont know wat is that....... do it creates any problem?

let me know can any one plz help me in this issue to reuse password.

SQL> select profile,resource_name,limit from dba_profiles;

PROFILE RESOURCE_NAME LIMIT
------------------------------ -------------------------------- ----------------
------------------------
DEFAULT COMPOSITE_LIMIT UNLIMITED
LOCK_PROFILE COMPOSITE_LIMIT DEFAULT
KESDLMS COMPOSITE_LIMIT DEFAULT
DEFAULT FAILED_LOGIN_ATTEMPTS 3
LOCK_PROFILE FAILED_LOGIN_ATTEMPTS DEFAULT
KESDLMS FAILED_LOGIN_ATTEMPTS 3
DEFAULT SESSIONS_PER_USER UNLIMITED
LOCK_PROFILE SESSIONS_PER_USER DEFAULT
KESDLMS SESSIONS_PER_USER DEFAULT
DEFAULT PASSWORD_LIFE_TIME UNLIMITED
LOCK_PROFILE PASSWORD_LIFE_TIME DEFAULT

PROFILE RESOURCE_NAME LIMIT
------------------------------ -------------------------------- ----------------
------------------------
KESDLMS PASSWORD_LIFE_TIME UNLIMITED
DEFAULT CPU_PER_SESSION UNLIMITED
KESDLMS CPU_PER_SESSION DEFAULT
LOCK_PROFILE CPU_PER_SESSION DEFAULT
DEFAULT PASSWORD_REUSE_TIME 300
LOCK_PROFILE PASSWORD_REUSE_TIME DEFAULT
KESDLMS PASSWORD_REUSE_TIME 300
DEFAULT CPU_PER_CALL UNLIMITED
LOCK_PROFILE CPU_PER_CALL DEFAULT
KESDLMS CPU_PER_CALL DEFAULT
DEFAULT PASSWORD_REUSE_MAX UNLIMITED

PROFILE RESOURCE_NAME LIMIT
------------------------------ -------------------------------- ----------------
------------------------
LOCK_PROFILE PASSWORD_REUSE_MAX DEFAULT
KESDLMS PASSWORD_REUSE_MAX UNLIMITED
DEFAULT LOGICAL_READS_PER_SESSION UNLIMITED
KESDLMS LOGICAL_READS_PER_SESSION DEFAULT
LOCK_PROFILE LOGICAL_READS_PER_SESSION DEFAULT
DEFAULT PASSWORD_VERIFY_FUNCTION UNLIMITED
LOCK_PROFILE PASSWORD_VERIFY_FUNCTION DEFAULT
KESDLMS PASSWORD_VERIFY_FUNCTION UNLIMITED
DEFAULT LOGICAL_READS_PER_CALL UNLIMITED
KESDLMS LOGICAL_READS_PER_CALL DEFAULT
LOCK_PROFILE LOGICAL_READS_PER_CALL DEFAULT

PROFILE RESOURCE_NAME LIMIT
------------------------------ -------------------------------- ----------------
------------------------
DEFAULT PASSWORD_LOCK_TIME .0006
KESDLMS PASSWORD_LOCK_TIME DEFAULT
LOCK_PROFILE PASSWORD_LOCK_TIME 60
DEFAULT IDLE_TIME UNLIMITED
LOCK_PROFILE IDLE_TIME DEFAULT
KESDLMS IDLE_TIME DEFAULT
DEFAULT PASSWORD_GRACE_TIME 10
LOCK_PROFILE PASSWORD_GRACE_TIME DEFAULT
KESDLMS PASSWORD_GRACE_TIME 10
DEFAULT CONNECT_TIME UNLIMITED
LOCK_PROFILE CONNECT_TIME DEFAULT

PROFILE RESOURCE_NAME LIMIT
------------------------------ -------------------------------- ----------------
------------------------
KESDLMS CONNECT_TIME DEFAULT
DEFAULT PRIVATE_SGA UNLIMITED
LOCK_PROFILE PRIVATE_SGA DEFAULT
KESDLMS PRIVATE_SGA DEFAULT

48 rows selected.

SQL> select username,profile from dba_users;

USERNAME PROFILE
------------------------------ ------------------------------
SYSTEM DEFAULT
OUTLN DEFAULT
TRACESVR DEFAULT
BLAKE DEFAULT
ADAMS DEFAULT
RCAT DEFAULT
SIVA DEFAULT
PERFSTAT DEFAULT
DEVTEST DEFAULT
SCOTT DEFAULT
JONES DEFAULT

USERNAME PROFILE
------------------------------ ------------------------------
PRA1 DEFAULT
CBT DEFAULT
LMS DEFAULT
HEMU1 DEFAULT
KALYAN DEFAULT
FGB DEFAULT
BTT DEFAULT
TMS DEFAULT
TEST DEFAULT
KESDEE DEFAULT
TMS1 DEFAULT

USERNAME PROFILE
------------------------------ ------------------------------
SYS DEFAULT
DBSNMP DEFAULT
IPLANET DEFAULT
RMAN_TG DEFAULT
CLARK DEFAULT
GFTT DEFAULT
KLMS DEFAULT
KESDLMS111 KESDLMS
KESDLMS222 KESDLMS

31 rows selected.