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

ORA-28040: No matching authentication protocol exception(ORA-28040: 没有匹配的身份验证协议异常)
本文介绍了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: 没有匹配的身份验证协议异常的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!

本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除!

相关文档推荐

SQL to Generate Periodic Snapshots from Transactions Table(用于从事务表生成定期快照的SQL)
MyBatis support for multiple databases(MyBatis支持多个数据库)
Oracle 12c SQL: Missing column Headers in result(Oracle 12c SQL:结果中缺少列标题)
SQL query to find the number of customers who shopped for 3 consecutive days in month of January 2020(查询2020年1月连续购物3天的客户数量)
How to get top 10 data weekly (This week, Previous week, Last month, 2 months ago, 3 month ago)(如何每周获取前十大数据(本周、前一周、上个月、2个月前、3个月前))
Select the latest record for an Id per day - Oracle pl sql(选择每天ID的最新记录-Oracle pl SQL)