问题描述
我正在尝试将我的 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: 没有匹配的身份验证协议异常的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！