ORA-28040: No matching authentication protocol

You are getting ORA-28040  (ORA-28040):  No matching authentication protocol.

Oracle database version: 12.1.0.1

Oracle client version: 11.2.0.3

Solution:

Append the following entry to the sqlnet.ora file on the database server:

SQLNET.ALLOWED_LOGON_VERSION = 8

Explanation:

SQLNET.ALLOWED_LOGON_VERSION - is used to set the minimum authentication protocol allowed when connecting to Oracle Database instances. The term VERSION in the parameter name refers to the version of the authentication protocol, not the Oracle Database release.

A setting of 8 permits most password versions, and allows any combination of the DBA_USERS.PASSWORD_VERSIONS values 10G, and 11G.

For more information see:

http://docs.oracle.com/cd/B28359_01/network.111/b28317/sqlnet.htm#BIIEAFHA

I hope this helps.

Please feel free to leave your questions or suggest improvements to this section.