blocks|key|2952922|text|我删除了ojdbc14.jar文件，转而使用ojdbc6.jar，这对我很有效|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2952923|entityMap^0|4|B|M|A|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|M|8|@]|D|@]|E|$]]]|G|$]]

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

blocks|key|153969|text|这是我在experts-exchange上找到的一些文本|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|153970|153971|错误14575666|blockquote|153972|153973|在12.1中，SQLNET.ALLOWED_LOGON_VERSION参数的默认值已更新为11。这意味着，除非将theSQLNET.ALLOWED_LOGON_VERSION参数设置为旧的默认值8，否则使用11g之前版本的JDBC瘦驱动程序的数据库客户机无法向12.1数据库服务器进行身份验证。|153974|这将导致在12.1Oracle+ASM和Oracle+Grid+Infrastructure环境中使用DBCA创建10.2.0.5+Oracle+RAC数据库失败，并显示ORA-28040:没有匹配的验证协议错误。|153975|解决方法:在oracle/network/admin/sqlnet.ora文件中设置SQLNET.ALLOWED_LOGON_VERSION=8。|153976|entityMap|0|LINK|mutability|MUTABLE|url|http://www.experts-exchange.com/Database/Oracle/Q_28387999.html^0|4|G|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@$A|X|B|Y|1|Z]]|C|$]]|$1|D|3|-4|5|6|7|10|8|@]|9|@]|C|$]]|$1|E|3|F|5|G|7|11|8|@]|9|@]|C|$]]|$1|H|3|-4|5|6|7|12|8|@]|9|@]|C|$]]|$1|I|3|J|5|6|7|13|8|@]|9|@]|C|$]]|$1|K|3|L|5|6|7|14|8|@]|9|@]|C|$]]|$1|M|3|N|5|6|7|15|8|@]|9|@]|C|$]]|$1|O|3|-4|5|6|7|16|8|@]|9|@]|C|$]]]|P|$Q|$5|R|S|T|C|$U|V]]]]

Here is some text I found at <a href="http://www.experts-exchange.com/Database/Oracle/Q_28387999.html" rel="noreferrer">experts-exchange</a>:

<blockquote>
 Bug 14575666
 
 In 12.1, the default value for the SQLNET.ALLOWED_LOGON_VERSION
 parameter has been updated to 11. This means that database clients
 using pre-11g JDBC thin drivers cannot authenticate to 12.1 database
 servers unless theSQLNET.ALLOWED_LOGON_VERSION parameter is set to the
 old default of 8.
 
 This will cause a 10.2.0.5 Oracle RAC database creation using DBCA to
 fail with the ORA-28040: No matching authentication protocol error in
 12.1 Oracle ASM and Oracle Grid Infrastructure environments.
 
 Workaround: Set SQLNET.ALLOWED_LOGON_VERSION=8 in the
 oracle/network/admin/sqlnet.ora file.
</blockquote>

blocks|key|154005|text|除了将以下内容添加到sqlnet.ora之外|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|154006|SQLNET.ALLOWED_LOGON_VERSION_CLIENT+=+8
SQLNET.ALLOWED_LOGON_VERSION_SERVER+=+8|code-block|syntax|javascript|154007|我还向客户端和服务器添加了以下内容，这解决了我的问题|154008|SQLNET.AUTHENTICATION_SERVICES+=+(NONE)|154009|另请参阅post+ORA-28040:+No+matching+authentication+protocol|154010|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/34398101/ora-28040-no-matching-authentication-protocol/43362249#43362249^0|A|A|0|0|0|0|9|1A|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@$9|Z|A|10|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|11|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|12|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|13|8|@]|D|@]|E|$I|J]]|$1|O|3|P|5|6|7|14|8|@]|D|@$9|15|A|16|1|17]]|E|$]]|$1|Q|3|-4|5|6|7|18|8|@]|D|@]|E|$]]]|R|$S|$5|T|U|V|E|$W|X]]]]

Except for adding the following to sqlnet.ora

<pre><code>SQLNET.ALLOWED_LOGON_VERSION_CLIENT = 8
SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8
</code></pre>

I also added the following to both the Client and Server, which resolved my issue

<pre><code>SQLNET.AUTHENTICATION_SERVICES = (NONE)
</code></pre>

Also see post
<a href="https://stackoverflow.com/questions/34398101/ora-28040-no-matching-authentication-protocol/43362249#43362249">ORA-28040: No matching authentication protocol</a>

blocks|key|156604|text|添加|type|unstyled|depth|inlineStyleRanges|entityRanges|data|156605|SQLNET.ALLOWED_LOGON_VERSION_SERVER+=+8|code-block|syntax|javascript|156606|是sql.ora+directory+..\product\12.1.0\dbhome_1\NETWORK\ADMIN的完美解决方案|156607|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Adding 

<pre><code>SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8
</code></pre>

is the perfect solution
sql.ora directory 
..\product\12.1.0\dbhome_1\NETWORK\ADMIN

blocks|key|156609|text|我在使用eclipse，在尝试了所有其他答案后，它对我不起作用。最后，对我来说起作用的是将ojdb7.jar移到构建路径的顶部。当多个jars具有冲突的相同类时，就会发生这种情况。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|156610|156611|blockquote|156612|156613|在Project+Explorer|156614|Right中选择选择项目，单击Project+->+Build+Path+->+Configure+Build+Path|unordered-list-item|156615|
|156616|Go+to+Order+and+Export选项卡，然后选择|156617|+TOP，将其移至顶层|ordered-list-item|156618|156619|156620|entityMap^0|19|9|0|0|0|0|1|G|0|F|19|0|0|6|G|0|1|3|0|0|0^^$0|@$1|2|3|4|5|6|7|Z|8|@$9|10|A|11|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|12|8|@]|D|@]|E|$]]|$1|G|3|-4|5|H|7|13|8|@]|D|@]|E|$]]|$1|I|3|-4|5|6|7|14|8|@]|D|@]|E|$]]|$1|J|3|K|5|6|7|15|8|@$9|16|A|17|B|C]]|D|@]|E|$]]|$1|L|3|M|5|N|7|18|8|@$9|19|A|1A|B|C]]|D|@]|E|$]]|$1|O|3|P|5|6|7|1B|8|@]|D|@]|E|$]]|$1|Q|3|R|5|N|7|1C|8|@$9|1D|A|1E|B|C]]|D|@]|E|$]]|$1|S|3|T|5|U|7|1F|8|@$9|1G|A|1H|B|C]]|D|@]|E|$]]|$1|V|3|-4|5|6|7|1I|8|@]|D|@]|E|$]]|$1|W|3|-4|5|6|7|1J|8|@]|D|@]|E|$]]|$1|X|3|-4|5|6|7|1K|8|@]|D|@]|E|$]]]|Y|$]]

I was using eclipse and after trying all the other answers it didn't work for me. 
In the end, what worked for me was moving the <code>ojdb7.jar</code> to top in the Build Path. This occurs when multiple jars have conflicting same classes.

<blockquote>
 <ol>
 <li>Select project in <code>Project Explorer</code></li>
 <li>Right click on <code>Project -&gt; Build Path -&gt; Configure Build Path</code></li>
 <li>Go to <code>Order and Export</code> tab and select <code>ojdbc.jar</code></li>
 <li>Click button <code>TOP</code> to move it to top</li>
 </ol>
</blockquote>

blocks|key|156649|text|我使用ojdbc8.jar解决了这个问题。Oracle+12c与ojdbc8.jar兼容|type|unstyled|depth|inlineStyleRanges|entityRanges|data|156650|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I resolved this issue by using ojdbc8.jar. 
Oracle 12c is compatible with ojdbc8.jar

blocks|key|2740303|text|只需安装ojdbc-full，它包含12.1.0.1版本。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2740304|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

just install ojdbc-full, That contains the 12.1.0.1 release.

blocks|key|2740332|text|除了将以下内容添加到sqlnet.ora之外|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2740333|SQLNET.ALLOWED_LOGON_VERSION_CLIENT+=+8
SQLNET.ALLOWED_LOGON_VERSION_SERVER+=+8|code-block|syntax|javascript|2740334|如果你得到"ORA-01017:无效的用户名/密码；登录被拒绝“错误，那么你需要重新创建你的密码。|2740335|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

This except for adding the following to sqlnet.ora

<pre><code>SQLNET.ALLOWED_LOGON_VERSION_CLIENT = 8
SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8
</code></pre>

If you get "ORA-01017: invalid username/password; logon denied" error, then you need to re-create your password.

blocks|key|2740349|text|我的初始错误是:+ORA-28040:没有匹配的身份验证协议异常|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2740350|我的数据库版本是12.2+(Solaris)，客户端版本是11.2+(+windows)。我在服务器和客户端sqlnet.ora中都添加了以下内容|2740351|SQLNET.ALLOWED_LOGON_VERSION_CLIENT+=8+SQLNET.ALLOWED_LOGON_VERSION_SERVER+=8|2740352|在连接时，我得到了无效的用户名和密码，因此我在数据库中重新创建了密码(相同的密码)，这解决了我的问题。|2740353|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

My Initial error is : ORA-28040: No matching authentication protocol exception

My DB version is 12.2 (Solaris) and client version is 11.2 ( windows). I have added below in both server and client sqlnet.ora

SQLNET.ALLOWED_LOGON_VERSION_CLIENT = 8
SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8

while connecting, I have got invalid username and password hence I have recreated the password ( same password ) in database which is resolved my issue.

blocks|key|2740377|text|虽然对于大多数情况，替换ojdbc驱动程序jar将是解决方案，但我的情况有所不同。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2740378|如果您确定您使用的是正确的ojdbc驱动程序。如果你真的连接到你认为的数据库，请仔细检查。在我的例子中，jdbc配置(在Tomcat/conf中)指向具有不同Oracle版本的不同数据库。|2740379|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

While for most cases replacing ojdbc driver jar will be the solution, my case was different. 

If you are certain you are using correct ojdbc driver. Double check if you are actually connecting to the database you are thinking you are. In my case jdbc configuration (in Tomcat/conf) was pointing to different database that had different Oracle version.

blocks|key|154084|text|非常老的问题，但提供一些额外的信息，可能会对其他人有帮助。我也遇到了同样的错误，我将ojdbc14.jar与Oracle数据库12.1.0.2一起使用。在Oracle官方网页上，列出了哪些版本支持哪些数据库驱动程序。Here+is+the+link，看起来Oracle12c和Java7或8的正确版本是ojdbc7.jar。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|154085|在ojdbc6.jar中是针对11.2.0.4的。|154086|entityMap|0|LINK|mutability|MUTABLE|url|https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html^0|30|G|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

Very old question but providing some additional information which may help someone else. I also encountered same error and I was using ojdbc14.jar with 12.1.0.2 Oracle Database. On Oracle official web page this information is listed that which version supports which database drivers. <a href="https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html" rel="nofollow noreferrer">Here is the link</a> and it appears that with Oracle 12c and Java 7 or 8 the correct version is ojdbc7.jar.
In the ojdbc6.jar is for 11.2.0.4.

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 :

<pre><code>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
</code></pre>

According to internet suggestion I also tried editing my <code>*.ora</code> file but it is not working.

I added following snippet in <code>sqlnet.ora</code> file :

<pre><code>SQLNET.ALLOWED_LOGON_VERSION=10
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=10
SQLNET.ALLOWED_LOGON_VERSION_SERVER=10
</code></pre>

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

Can anyone please help me with this ?

ORA-28040: No matching authentication protocol exception

Oracle数据库

身份验证

数据库

服务器

Solaris

我正在尝试将我的grails项目连接到windows(8)系统中的Oracle数据库(Oracle12c)。然而，每当我运行我的应用程序时，我都会得到以下异常：Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableCon...

问ORA-28040:无匹配的身份验证协议异常
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问ORA-28040:无匹配的身份验证协议异常EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问ORA-28040:无匹配的身份验证协议异常
EN