Joe Huang, March 13, 2017 - 3:11 am UTC
Thanks Connor,
that's of great help!
Found another issue
Nikhil Mehta, April 12, 2018 - 6:47 pm UTC
Thanks Tom and Team for the help.
Just to add more point.
Today, we migrated a Database from AIX(11.2.0.4) to Unix(12.2.0.1). User was facing same issue ORA-28040: No matching authentication protocol and later invalid username/password after setting the SQLNET.ALLOWED_LOGON_VERSION=8.
Interesting thing was when passing the password in UPPERCASE, user was able to connect.
I fired alter user username password "same_password" account unlock and things started working.
The only things which I find relevant from oracle doc is
"The server has been configured with SEC_CASE_SENSITIVE_LOGON set to FALSE, so that it can only authenticate users who have a 10G case-insensitive password version."