I have setup Oracle Database 12c on my local machine. It was working fine initially but now I cannot login to users' account except the sys user. I have altered users' passwords and tried logging in using SQLPlus and SQL DEVELOPER.
ALTER USER XYZ IDENTIFIED BY XYZ;
I have also checked the parameter SEC_CASE_SENSITIVE_LOGON which is set to FALSE.
The users, that I am trying to connect are created in pluggable database i.e orclpdb and they do exist in the pluggable database.
I can only login to sys user of pluggable database and root.
The username and passwords are correct, I don't know why the oracle is behaving weirdly.
Best Answer
Why was
SEC_CASE_SENSITIVE_LOGON
set to false? That is deprecated in 12c. This is a known issue that I encountered many times.Case-Insensitive Passwords and ORA-1017 Invalid Username or Password