The on-premises database was 12.1, the Cloud 12.2. It seems that in database version 12.2 some extra checks where build in SQL*Net (Bug 26092744) causing that older clients can’t connect any more to the database: įirst I ignored this “notification”, but later I found that IFRUN60.EXE got the same message and stopped. ORA-03137: malformed TTC packet from client rejected: Testing again with SQL*Plus became funky:

To connect with an older client to database with a higher version, you have to allow this in the sqlnet.ora on the serverside. WE8ISO8859P1 Step 3: Allowed versie of the database TNS-12203: TNS:unable to connect to destinationĪfter some research I found out that the characterset of the database was the culprit, so we provisioned a cloud database with the same characterset as the old on-premises database Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.0.6.0.0 – Production TNS for 32-bit Windows: Version 8.0.6.0.0 – Production Testing, again with SQL*Plus, the executable crashed big time with a General Protection Fault.

Step 2: Correcting the characterset of the database SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT=(SHA1) SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER=(SHA1) u01/app/oracle/product/****/dbhome_1/network/admin/sqlnet.ora On this database database server secure SQL*Net is enabled by We are not using an Autonomous database, so we still have a “server” we can connect to in OCI. ORA-12660: Encryption or crypto-checksumming parameters incompatibleĪ standard OCI Database installation enables secure SQL*Net.

This is the road I traveled: Step 1: Disable SQL*Netįirst I tried making a connection with SQL*Plus from the same Oracle-home as Forms to the new database: We could rebuild/redesign the old application to Oracle Apex, but that would be an entire project by itself.īut first we investigated if it was possible to connect this software from 1995 to the 21th century. We are talking Oracle Forms 6i client/server on Windows, 100% generated with Oracle Designer.

But one of these databases had an Oracle Forms C/S frontend. My customer started to move all of his Oracle Databases to the Oracle Cloud Infrastructure (OCI). But the world of enterprise IT isn’t like that. Everybody wants to work with the latest tools, the latest feautures.

Oracle forms developer 6i