ORA-28040: No matching authentication protocol exception

oracle oracle12c
Aman Adhikari picture Aman Adhikari · Jun 7, 2014 · Viewed 461.2k times · Source

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 ?

Answer

Aman Adhikari picture Aman Adhikari · Oct 28, 2014

I deleted the ojdbc14.jar file and used ojdbc6.jar instead and it worked for me

Related questions

error: ORA-65096: invalid common user or role name in oracle

I just installed Oracle, and it was missing the Scott schema. So i am trying to generate it myself. I got the sql script of Scott schema, but when i try to run the query: create user Scott identified by …

Read More
Return results of a sql query as JSON in oracle 12c

Background I need to fetch a few thousands rows from Oracle and convert them to JSON for use in SlickGrid. Currently I am fetching the rows in PHP, converting it from ISO to UTF-8 with iconv and exporting to json …

Read More
ORA-00119: invalid specification ORA-00132: syntax error

Below are outputs from my SQLPLUS startup , LSNRCTRL SERVICES, LSNRCTRL STATUS and TNSPING. Also included are my LISTENER.ORA file, TNSNAMES.ORA and my PFILE. As you can see from the SQLPLUS startup output the database will not startup because …

Read More