This error ORA-28040 is also raised when the client is authenticating to a user account which was created without a verifier suitable for the client software version. The administrator should set the values of the SQLNET.ALLOWED_LOGON_VERSION_SERVER and SQLNET.ALLOWED_LOGON_VERSION_CLIENT parameters, on both the client and on the server, to values that match the minimum version software supported in the system. There was no acceptable authentication protocol for either client or server. ORA-28040: No matching authentication protocol I'll talk more about Oracle JDBC driver with ORA-28040 later in the post. Same error may occur while you're using old Oracle JDBC drivers, say ojdbc14.jar or below, to connect a 12c or 18c database. But I didn't expect ORA-28040 to show up.įor those users who want to use Oracle client 11g to connect to database 19c, but failed with ORA-28040, I'll talk about it in the last section. I knew there could be some interoperability problems between versions, especially when the version gap is big like this case, Oracle 9i client connect to 12c, 18c or 19c database. If you already have an understanding on SQL and other computer programming language, then it will be an added advantage to proceed.When I tried to connect to a 12.1 database from an Oracle client 9.2, it failed with ORA-28040: No matching authentication protocol. Prerequisitesīefore proceeding with this tutorial, you should have a basic understanding of software basic concepts like what is database, source code, text editor and execution of programs, etc. This tutorial will give you great understanding on PL/SQL Programming concepts, and after completing this tutorial, you will be at an intermediate level of expertise from where you can take yourself to a higher level of expertise. This tutorial is designed for Software Professionals, who are willing to learn PL/SQL Programming Language in simple and easy steps. This tutorial will give you great understanding on PL/SQL to proceed with Oracle database and other advanced RDBMS concepts.
PL/SQL is one of three key programming languages embedded in the Oracle Database, along with SQL itself and Java. It was developed by Oracle Corporation in the early 90's to enhance the capabilities of SQL. PL/SQL is a combination of SQL along with the procedural features of programming languages. PDF Version Quick Guide Resources Job Search Discussion
0 kommentar(er)
