Ok, this is a common issue, once it’s like the default behavior of oracle for DEFAULT profile, used as DEFAULT to new users. But it’s really easy to solve. 🙂
Before expiring you should be received some:
ORA-28002: the password will expire within x days
Ok then, but what if you are facing errors to reuse the same password, don’t know the password and yet, how to never let it happen again?
An unexpected error, right?
SQL> CREATE PROFILE TEST_PROF LIMIT
CREATE PROFILE TEST_PROF LIMIT
ERROR at line 1:
ORA-28004: invalid argument for function specified in PASSWORD_VERIFY_FUNCTION FNC_VALIDATION
That is a simple need. You have to use 3 parameters on function: username varchar2, password varchar2, old_password varchar2.