I've kept keep PASSWORD_REUSE_MAX=1 password. but it did not allow me to use the same old pwd after 2nd or 3rd .. attempt. it keep telling me
"ORA 28007 Password can not be changed" can any one suggest what limit do I need to change so old pwd can be used after 1 time
In normal Oracle fashion, the documentation is wrong. If the PASSWORD_REUSE_TIME is set to UNLIMITED while you have the PASSWORD_REUSE_MAX set to an integer value, then the user will never be able to reuse a password.
Therefore, you should actually set the PASSWORD_REUSE_TIME to a low value. For example: