Organizational Research By

Surprising Reserch Topic

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 :

SQLNET.ALLOWED_LOGON_VERSION=10
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=10
SQLNET.ALLOWED_LOGON_VERSION_SERVER=10


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
191 views



Related Hot Questions

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 10.2.0.5 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

...