Cause : ORA-28221 error occurs when an user tries to reset his own password without specifying the REPLACE keyword, provided the user does not have ALTER USER privilege and the user is having a profile with password verify function.
Solution : Provide the current password along with the REPLACE clause in the ALTER USER statement.
SQL> conn test/test_pwd12
SQL> alter user test identified by test_pwd11;
alter user test identified by test_pwd11
ERROR at line 1:
ORA-28221: REPLACE not specified
SQL> alter user test identified by test_pwd11 replace test_pwd12;
SQL> conn test/test_pwd11
Article by : Anju