ORA-28040: No matching authentication protocol

Exception occurred: java.sql.SQLException: ORA-28040: No matching authentication protocol

Issue:

Unable to connect to database, getting below error:

Exception occurred: java.sql.SQLException: ORA-28040: No matching authentication protocol

Cause:

DB Connectivity Issue after upgrading to Oracle Database 12c.

The issue is caused by the default setting for allowed logon version in the Oracle 12c database.

Note that the SQLNET.ALLOWED_LOGON_VERSION parameter has been deprecated in 12c.

The parameter has been replaced with:

SQLNET.ALLOWED_LOGON_VERSION_SERVER

Solution:

To resolve the database connectivity issue, perform the following steps :

1. Review the sqlnet_ifile.ora or sqlnet.ora file and confirm the following entries are present:

  SQLNET.ALLOWED_LOGON_VERSION_SERVER

2. Update the sqlnet_ifile.ora or sqlnet.ora settings for the above parameters to the lowest version level 

that is required in your environment. 

For example:

a) If the initialization parameter SEC_CASE_SENSITIVE_LOGON is set to FALSE:

  SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8

b) If SEC_CASE_SENSITIVE_LOGON is set to TRUE

  SQLNET.ALLOWED_LOGON_VERSION_SERVER = 10

After this Database connectivity issue should be resolved.