ORA-28040：没有匹配的认证协议例外 [英] ORA-28040: No matching authentication protocol exception

问题描述

我试图在Windows（8）系统中将我的grails项目连接到Oracle数据库（ Oracle 12c ）。然而，每当我运行我的应用程序，我得到以下异常：

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

根据互联网提示，我也尝试编辑我的 *。ora 文件，但它不起作用。

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

我在 sqlnet.ora 文件中添加了以下代码段：

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

10,11,12）但他们都没有工作。

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

任何人都可以请帮我一下吗？

Can anyone please help me with this ?

推荐答案

我删除了 ojdbc14.jar em> 文件，并使用 ojdbc6.jar 替代它并且适用于我

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

从@JamesTobin ：
变为 ojdbc6.jar 或 ojdbc7.jar 仍然失败，因为我一直在不断设置： oracle.jdbc.thinLogonCapability=o3对付oracle 12c

From @JamesTobin : changing to ojdbc6.jar or ojdbc7.jar still failed because I had been constantly setting: oracle.jdbc.thinLogonCapability"="o3" which you no longer have to do against oracle 12c

这篇关于ORA-28040：没有匹配的认证协议例外的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！