Oracle Passwrod Reset - ORA-28221: Replace not specified

Oracle Passwrod Reset - ORA-28221: Replace not specified

Error,

ORA-28221: Replace not specified


Root Cause:

When a user name has a profile that has a password verify function set and the user tries to change the password using “ALTER USER” without the REPLACE clause, and also the user doesn’t have ALTER USER privilege Oracle will generate the “ORA-28221: REPLACE not specified” error message. So the user needs to include the “REPLACE” clause.


Solution:

Please navigate to <PMP installation directory>/conf and add open system_properties.conf and add a new property oraclePwdReset.localAccount=true and save the file. Now restart PMP service and then try Password reset.



          • Related Articles

          • Oracle Password Reset

            ORA-00972: identifier is too long  If you get the above error code in a log while performing Password reset for oracle devices it means you are using oracle version less than 12.2 ​ Root Cause: Oracle version prior to 12.2, the password should not be ...
          • Reset Personal Tab.

            Please follow the below mentioned steps in order to reset the personal tab. All old passwords stored under the Personal Tab will be lost.  Login to PMP with the login user name and password for which the personal tab needs to reset. Modify the PMP ...
          • Can we add more than two Password Manager Pro servers in high availability solution?

            No. it is not possible to have more than two PMP servers for HA solution. To elaborate more, High availability and cluster are two different replication mechanism we support. So, for replication with SQL database, PMP comes with below features. High ...