SQLNET.ALLOWED_LOGON_VERSION (Doc ID 755605.1)

wuweilong發表於2013-11-12
Error "ORA-28040: No matching authentication protocol" When Using SQLNET.ALLOWED_LOGON_VERSION (Doc ID 755605.1) To BottomTo Bottom

Modified:10-Jul-2012Type:PROBLEM
Rate this document Email link to this document Open document in new window Printable Page

In this Document



APPLIES TO:

JDBC - Version 10.1.0 to 10.2.0.5
Information in this document applies to any platform.

SYMPTOMS

When using the property "SQLNET.ALLOWED_LOGON_VERSION=10" set in the file sqlnet.ora on the server side, a 10g JDBC thin driver connecting to this 10g oracle database, fails with following errors:

The Network Adapter could not establish the connection 
.... 
ORA-28040: No matching authentication protocol





.

CHANGES

Configuring SQLNET.ORA on the server side.

CAUSE

 - ORA-28040: WHEN LISTENER USES SQLNET.ALLOWED_LOGON_VERSION

A 10.2 thin jdbc driver is identifying itself as 8.1.5 client and hence the connection is failing with error ORA-28040: No matching authentication protocol

SOLUTION

To resolve the above issue you may implement any one of the following :- 

- Change the entry in sqlnet.ora file on the server machine: 
from: 
SQLNET.ALLOWED_LOGON_VERSION=10 

to: 
SQLNET.ALLOWED_LOGON_VERSION=8 

OR 

- Use the OCI driver instead of the THIN driver. The OCI driver identifies itself correctly as a 10.2 client and thus the connection succeeds. 

OR 

- If you are using 10.2.0.4 version of the driver then, you may download  from My Oracle Support. 

OR 

- If you are using 10.1.0.5.0 version of the driver then, you may download  from My Oracle Support. 

OR 

- Use JDBC 11g THIN driver.

REFERENCES

 - ORA-28040: WHEN LISTENER USES SQLNET.ALLOWED_LOGON_VERSION

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/20674423/viewspace-776433/,如需轉載,請註明出處,否則將追究法律責任。

相關文章