Tuesday, January 15, 2019

ORA-28040: No matching authentication protocol after Oracle 12c upgrade.

After Oracle 12c upgrade users started seeing below errors

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

7 comments:

  1. It is nice to see an article dedicated to this important topic. Thank you for sharing. seo service in gurgaon

    ReplyDelete
  2. It is nice to see an article dedicated to this important topic. Thank you for sharing @ Packers And Movers Mumbai

    ReplyDelete
  3. Packers 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.@
    Packers And Movers in Bangalore

    ReplyDelete
  4. 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

    ReplyDelete
  5. RTCP control bundles are intermittently communicated by every member in a RTP meeting to any remaining members. https://onohosting.com/

    ReplyDelete
  6. SDP, representing Session Description Protocol, used to portray mixed media meetings in an arrangement comprehended by the members over an organization. https://hostinglelo.in/

    ReplyDelete
  7. KVS 11th Class Syllabus 2023
    Kendriya 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.

    ReplyDelete