I'm trying to reset my password using the alter user command, but am getting ‘ORA-28008: invalid old password’. I have confirmed the old password is typed correctly (copied it, logged out, pasted the value when logging in. I suspect the fact that my current password ends with $.
I have tried the 4 variants below. Is there anything else I can try?
alter user username identified by newpass replace oldpass$ ;
alter user username identified by newpass replace "oldpass$";
alter user username identified by newpass replace oldpass\$;
alter user username identified by newpass replace "oldpass\$";
If it's relevant, I'm using SQL Developer 23.1.1.345 on Mac OS Sequoia. Database is Oracle 19c.