Hi.
In Oracle 12.2.0.1.0, I can CONNECT / AS SYSDBA in SQL*Plus and say
ALTER USERĀ FOO IDENTIFIED BY FUBAR;
and it tells me "user altered", but when I try
CONN FOO/FUBAR
i get the error message "ORA-01017: invalid username/password; logon denied".
I used all capital letters in all the commands, and I've done
ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGIN=FALSE SCOPE=BOTH
anyway.
I get the same problem with other users (including newly created users), longer and more complicated passwords, and whether or not I explicitly use @SID.
What am I doing wrong?