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. Former Oracle ACE, Computer Scientist, MSc in Data Science, over ten years of experience in companies such as IBM, Epico Tech, and Playtech based in three different countries (Brazil, Hungary, and Sweden) and joined projects remotely in many others. I am super excited to show you my interest in Databases, Cloud, Data Science, Data Engineering, Bigdata, AI, Programming, Software Engineering, and data in general.
(Continue reading)