ORA-28040: No matching authentication protocol
The main issue is older versions of drivers will not able to connect 12c server. In Oracle 12.1, the default value for the SQLNET.ALLOWED_LOGON_VERSION parameter is set to 11. This means that database clients using pre-11g drivers cannot authenticate to 12.1 database servers unless the SQLNET.ALLOWED_LOGON_VERSION parameter is set to the old default of 8 in $ORACLE_HOME/network/admin/sqlnet.ora
This can be done by using either :
SQLNET.ALLOWED_LOGON_VERSION_SERVER=8 (JDBC 10g drivers by default support this security version implementation)
OR
SQLNET.ALLOWED_LOGON_VERSION_SERVER=10 (If you had applied the patch 6779501, on JDBC 10.2.0.4 / 10.2.0.5, OR if the jar is bundled with Weblogic Server)
OR
The alternative is to leave the default SQLNET.ALLOWED_LOGON_VERSION_SERVER=11 on the database and upgrade the JDBC clients. You can download the JDBC 11g or 12c from http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html
Note that SQLNET.ALLOWED_LOGON_VERSION has been deprecated in 12c.
Even after updating above values users might receive below error.
ORA-01017: invalid username/password: logon denied
In this case users need to add following parameter to sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES = (NONE)
Also few users received ORA-28040 error when creating older version of databases (for ex: 10g) using DBCA
Reference :
Error "ORA-28040: No matching authentication protocol" When Using SQLNET.ALLOWED_LOGON_VERSION ( Doc ID 755605.1 )
JDBC Version 10.2.0.4 Produces ORA-28040 Connecting To Oracle 12c (12.1.0.2) Database ( Doc ID 2023160.1 ).
Thanks
Satishbabu Gunukula, Oracle ACE
https://oracleracexpert.com
It is nice to see an article dedicated to this important topic. Thank you for sharing. seo service in gurgaon
ReplyDeleteIt is nice to see an article dedicated to this important topic. Thank you for sharing @ Packers And Movers Mumbai
ReplyDeletePackers And Movers Bangalore Local Household Shifting Service, Get Free Best Price Quotes Local Packers and Movers in Bangalore List , Compare Charges, Save Money And Time.@
ReplyDeletePackers And Movers in Bangalore
It's difficult to state precisely how their business tolerating the coins will influence them, yet it is critical to mull over the way that their customers to a great extent incorporate PC specialists and other learned individuals. As it were, it's difficult to turn out badly with tolerating Bitcoin as an innovation organization. bitcoin mixer
ReplyDeleteRTCP control bundles are intermittently communicated by every member in a RTP meeting to any remaining members. https://onohosting.com/
ReplyDeleteSDP, representing Session Description Protocol, used to portray mixed media meetings in an arrangement comprehended by the members over an organization. https://hostinglelo.in/
ReplyDeleteKVS 11th Class Syllabus 2023
ReplyDeleteKendriya Vidyalaya XI Standard 2023 Final Exam Pass Students Join next 11th Standard Academic Year, Kendriya Vidyalaya XI Standard Standard Students Download Regular Reading new Syllabus 2023 for Exam Easy to Pass for the Academic Year 2023, KVS 11th Class Syllabus 2023 Students Download your KVS 11th Curriculum Split Up Syllabus 2023 Online Pdf Format. This year Kendriya Vidyalaya has Announced XI Standard Split Up Syllabus 2023 for the subjects Class 11 – Accountancy , Biology , Business Studies , Chemistry , Computers and Communication Technology , Creative Writing and Translation , Economics , English , Fine Art , Geography , Graphics design , Heritage Crafts , Hindi , History , Home Science , Mathematics , Physics , Political Science , Psychology , Sanskrit , Sociology , Statistics , Urdu etc. have a look at the KVS 11th Exam Pattern and Syllabus 2023.