How to connect to Oracle database 12c from Developer 2000, Forms and Reports.

A major problem is faced by the developer who are still working on Developer 2000 as their domain, but migrated to Oracle 12c as per requirement. Problem is "No matching authentication protocol".

That is they are unable to connect to Oracle 12c database. Problem is Oracle 12c itself rejects connection from Developer 6i.

It can be solved. Just need to make one changes in database server end.

I will be guiding for the methods for both linux and windows environment.

Simply open sqlnet.ora file on database server end.

In linux we assume you installed Oracle database in /u01 directory and using version 12.1.0

/u01/app/oracle/product/12.1.0/dbhome_1/network/admin/sqlnet.ora

In windows we assume you installed Oracle database in c:\ drive and using version 12.1.0

C:\app\oracle\product\12.1.0\dbhome_1\network\admin\sqlnet.ora

add this line to the end of the file

SQLNET.ALLOWED_LOGON_VERSION=8

This will surely solve connectivity problem from Developer 2000 to Oracle 12c database.

You can also watch this tutorial in YouTube with the following link : https://www.youtube.com/watch?v=pgswMkMJx1w

 Press like if you like the video and you can also subscribe to my channel : https://www.youtube.com/subhro190776