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
SQLNET.ALLOWED_LOGON_VERSION_CLIENT = 8
SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8
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
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
ReplyDeleteHire Best Packers And Movers Mumbai for hassle-free Household Shifting, ***Office Relocation, ###Car Transporation, Loading Unloading, packing Unpacking at affordable ✔✔✔ Price Quotation. Top Rated, Safe and Secure Service Providers who can help you with 24x7 and make sure a Untroubled Relocation Services at Cheapest/Lowest Rate
ReplyDeletePackers And Movers Mumbai
Packers and Movers Pune Provide High Quality ***Household Shifting, Home/Office Relocation, Insurance, Packing, Loading, ###Car Transportation Service Pune and High experiences, Top Rated, Safe and Reliable, Best and Secure Packers and Movers Pune Team List. Get ✔✔✔ Affordable Rate Charts and Compare Quotation and Save Money and Time .
ReplyDeletePackers And Movers Pune