ORA-28040: No matching authentication protocol Oracle 19c

Use Oracle client 11g instantclient-basic-nt-11.2.0.4.0.zip  to connect to database 19c,but failed with ORA-28040。

ORA-28040: No matching authentication protocol.

Solution

The solution to ORA-28040 in PL/SQL developer is to replace the old OCI with a newer one. First of all, you have to download an Oracle instant client which contains corresponding OCI library. The proper version should be at least 11g.

In our case, I downloaded and unzipped a basic package of Oracle instant client for windows 32-bit to C:\oracle, the filename is instantclient-basic-nt-11.2.0.4.0.zip for instance.

Please make sure that at least Microsoft Visual Studio 2005 Redistributable has been installed in your machine before using Oracle instant client 11.2.

Step 1: Open Preferences Dialog

Click on the function menu and search for Tools -> Preferences to open the dialog.

Step 2: Go to "Connection" Section

Click on Oracle -> Connection to check current Oracle Home.

Step 3: Change OCI Library

Point to new unzipped instant client's OCI. Please note that, you have to provide the whole absolute path including the filename, not just only the directory.

Step 4: Test the Connection

Restart PL/SQL developer and logon an Oracle 19c database.