ORA-28040: 没有匹配的身份验证协议异常

问题描述

我正在尝试将我的 grails 项目连接到 windows(8) 系统中的 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 文件并使用了 ojdbc6.jar 相反，它对我有用

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

这篇关于ORA-28040: 没有匹配的身份验证协议异常的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！