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.
1 comment:
A question ... do you have any tip to solve the runtime issues with Forms 6i againts 12 R2?
Post a Comment