After upgraded an Oracle database from 11.2.0.4 to 12.2.0.1 I receive the error “ORA-28040: No matching authentication protocol exception” during one of our applications tried to connect to this database. This is due to the fact that in version 11G the parameter SQLNET.ALLOWED_LOGON_VERSION_SERVER had the default value 8 while in version 12c it is 11. Knowing this, after changing the value of the parameter in the sqlnet.ora file the problem has been solved.
Portuguse / Português
Depois de atualizar um banco de dados Oracle 11.2.0.4 para 12.2.0.1 eu recebir o erro “ORA-28040: No matching authentication protocol exception” durante uma de nossas aplicações tentou se conectar a esta base dados. Isto se deve ao fato de na versão 11G o parâmetro SQLNET.ALLOWED_LOGON_VERSION_SERVER tinha o valor padrão 8 enquanto que na versao 12c é 11. Sabendo disso, após a alteração do valor do parâmetro no arquivo sqlnet.ora o problema foi resolvido.
Hi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across three different countries (Brazil, Hungary, and Sweden), and I have joined projects remotely in many others. I am super excited to share my interests in Databases, Cybersecurity, Cloud, Data Science, Data Engineering, Big Data, AI, Programming, Software Engineering, and data in general.
(Continue reading)