ora 28040 no matching authentication protocol exception

ora 28040 no matching authentication protocol exception  using -'oracle,grails,oracle12c'

I am trying to connect my grails project to Oracle databse(Oracle 12c) in windows(8) system. However, whenever i run my application i get following exception :

Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (ORA-28040: No matching authentication protocol


Caused by: java.sql.SQLException: ORA-28040: No matching authentication protocol

According to internet suggestion i also tried editing my  *.ora file but it is not working.

I added following snippet in sqlnet.ora file :


Here i tried assigning (10,11,12) but neither of them is working.

Can anyone please help me with this ?

asked Sep 14, 2015 by Fin1467
0 votes

1 Answer

0 votes

Here is some text I found at experts-exchange:

Bug 14575666

In 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 Oracle RAC database creation using DBCA to fail with the ORA-28040: No matching authentication protocol error in 12.1 Oracle ASM and Oracle Grid Infrastructure environments.

Workaround: Set SQLNET.ALLOWED_LOGON_VERSION=8 in the oracle/network/admin/sqlnet.ora file.

answered Sep 14, 2015 by CarlPalladin