Discussions
Categories
- 196.9K All Categories
- 2.2K Data
- 239 Big Data Appliance
- 1.9K Data Science
- 450.3K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 545 SQLcl
- 4K SQL Developer Data Modeler
- 187K SQL & PL/SQL
- 21.3K SQL Developer
- 295.9K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.6K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 440 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
SQLNET.ALLOWED_LOGON_VERSION

user20050
Member Posts: 44
If i set this parameter in the sqlnet.ora file, do i need to set a corresponding value via jdbc similar to "oracle.net..." similar to encryption?
sqlnet.ora entry
SQLNET.ALLOWED_LOGON_VERSION = 10
I'm running 10gR1 on Linux and trying to connect via jdbc (ojdbc14.jar) and its failing with
ORA-28040: No matching authentication protocol
If SQLNET.ALLOWED_LOGON_VERSION is set only in the sqlnet.ora with no property in jdbc i get
ORA-28040: No matching authentication protocol
If SQLNET.ALLOWED_LOGON_VERSION is set in sqlnet.ora and in the jdbc prop (oracle.net.allowed_logon_version=10) file I still get
ORA-28040: No matching authentication protocol
It says to set it on both the client and server -- how do you set it on the client?
Any guidance is appreciated
Thanks,
sqlnet.ora entry
SQLNET.ALLOWED_LOGON_VERSION = 10
I'm running 10gR1 on Linux and trying to connect via jdbc (ojdbc14.jar) and its failing with
ORA-28040: No matching authentication protocol
If SQLNET.ALLOWED_LOGON_VERSION is set only in the sqlnet.ora with no property in jdbc i get
ORA-28040: No matching authentication protocol
If SQLNET.ALLOWED_LOGON_VERSION is set in sqlnet.ora and in the jdbc prop (oracle.net.allowed_logon_version=10) file I still get
ORA-28040: No matching authentication protocol
It says to set it on both the client and server -- how do you set it on the client?
Any guidance is appreciated
Thanks,
Answers
-
You are hitting bug 6051243,details on metalink:
Error "ORA-28040: No matching authentication protocol" When Using SQLNET.ALLOWED_LOGON_VERSION Doc ID: 755605.1
Werner -
Hi..
From metalink:-
>
Error: ORA-28040 (ORA-28040)
Text: No matching authentication protocol
---------------------------------------------------------------------------
Cause: No acceptible authentication protocol for both client and server
Action: Administrator should set SQLNET_ALLOWED_LOGON_VERSION parameter
on both client and servers to values that matches the minimum
version supported in the system.
>
HTH
Anand -
Ebar,
This is a reported bug in 10.1.0.2, which proceeds with authentication failure and would require you to do the following:
*01 -* Set the DB_ALLOWED_LOGON_VERSION parameter in init.ora/SIDinita.ora as follows:
db_allowed_logon_version=10
*02 -* Specify matching authentication protocols for the client/database. To achieve this, make the following adjustments in SQLNET.ora file:
SQLNET_ALLOWED_LOGON_VERSIONS=(10,9,8,7)
Note: 10,9,8,are 7 the only values allowed. Details can be found in Oracle Net Services Guide at http://www.cis.unisa.edu.au/oracle/network.101/b10776/sqlnet.htm
Hope this helps.
Regards,
Naveed. -
Thanks everyone.
-
Anand... wrote:Better check your user agreement with MetaLink. You are not supposed to expose Metalink content to non-authorized users.
Hi..
From metalink:-
>
Error: ORA-28040 (ORA-28040)
Text: No matching authentication protocol
---------------------------------------------------------------------------
Cause: No acceptible authentication protocol for both client and server
Action: Administrator should set SQLNET_ALLOWED_LOGON_VERSION parameter
on both client and servers to values that matches the minimum
version supported in the system.
>
HTH
Anand
Though in this particular case, the exposed content is available from other sources.
This discussion has been closed.