Tuesday, 5 August 2014



ORA-28040: No matching authentication protocol

==============================================

Cause: 

 

 In Oracle database 12.1, the default value for the SQLNET.ALLOWED_LOGON_VERSION parameter has been updated to 11. This means that database clients using pre-11g JDBC thin drivers cannot authenticate to 12.1 database servers unless theSQLNET.ALLOWED_LOGON_VERSION parameter is set to the old default of 8.This will cause a Client Softwares (like SQL Developer) to fail with the ORA-28040: No matching authentication protocol error while connecting 12.1 Oracle Database

Solution: 

 Workaround: 

Set SQLNET.ALLOWED_LOGON_VERSION=8 in the $ORACLE_HOME/network/admin/sqlnet.ora file