Reason: In Oracle 11g, by default, there are a few changes to security and password management. This is one of them. The default profile now has a more strict password grace time. We can view DBA_PROFILES to find out the current value for the password_grace_time, among others.
Solution:
ALTER PROFILE LIMIT password_grace_time UNLIMITED;
ALTER PROFILE DEFAULT LIMIT password_grace_time UNLIMITED;
If you want to disable this on a specific user without changing the users password then issue this command:
alter profile limit password_verify_function null;
This will set the verification for this user to null. If you want to do this for every user in your system you can use below command (this is applied to the DEFAULT profile):
alter profile DEFAULT limit password_verify_function null;
There after we can reset the password
Solution:
ALTER PROFILE LIMIT password_grace_time UNLIMITED;
ALTER PROFILE DEFAULT LIMIT password_grace_time UNLIMITED;
If you want to disable this on a specific user without changing the users password then issue this command:
alter profile limit password_verify_function null;
This will set the verification for this user to null. If you want to do this for every user in your system you can use below command (this is applied to the DEFAULT profile):
alter profile DEFAULT limit password_verify_function null;
There after we can reset the password
Comments
Post a Comment