'ora-28040 no matching authentication protocol from Oracle client 12C to Oracle Database 19c
We recently migrated our database to 19c. Have a few .net applications which connect to Oracle db using system.data.oracleclient. The version of Oracle client installed is 12C. After the database upgrade, .net applications are unable to connect to the database due to the ORA-28040 No matching authentication protocol error.
Solution 1:[1]
Your Oracle client is not compatible by default with the upgraded database; it isn't hashing your password to the latest, most secure standard. You either need to upgrade your client to 12cR2 or later, or add the following lines to sqlnet.ora on your database server to force it to accept older (less secure) password hashes:
sqlnet.allowed_logon_version_server=12
sqlnet.allowed_logon_version_client=12
If that still doesn't work, you can try setting the values to "11", but don't go any lower than that for security reasons.
Note you have to create the user you want to use after applying those configuration else it will not work.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Steve Ruben |