Connecting Oracle Developer 10g to 11G database takes long time

We migrated to 11G R2 ( for our Oracle Applications R12 few years back, yes few years back (2017) & lived with one of the worst experiences…

Connecting Oracle Developer 10g (Forms/Reports) suite to 11G database.

I have scavenged through community articles for long time before giving up. I hardly came across a single fix for the connection time that used to hang up the Developer suite at times…

Today, I decided to find a solution for the nagging SSH connection issues from Windows 11 to our LINUX application servers and realized that we didn’t update the DNS settings for them once after we decommissioned a domain controller. Once the SSH issues were rectified and addressed, my next attempt was to find a solution for “frmcmp_batch” taking long time to start compiling modules & I landed on the below post.

Credit: Oracle Applications DBA: Form Compilation Against a 11g Database Hangs or Takes a Very Long Time [ID 880660.1] (

As we are already on 11G R2, patching was not required. All I needed was to alter the hidden parameter “_FIX_CONTROL” as mentioned in the article.


(Use scope=spfile to make this change permanent. This will require you to restart the database.)

I opted to go without spfile for testing & as soon as applied, the “frmcmp_batch” started compiling the modules instantly, against the usual delay that ran into many minutes other times.

Out of curiosity, I tried to connect to the database from Developer 10g & the connection was instant! within a fraction of a second.

So DNS being one of the most important elements establishing successful connections, patches and fixes also play crucial role in providing stable connections. Were you stuck with the same issue? give the solution a try and let us know whether it helped you also.

Windows 10 | Install Oracle Products

I’m sure you guys didn’t hear much from us for a long time. Actually we were been too busy testing Windows 10 to make sure that we can safely migrate our existing domain joined computers. Almost everything works as they were working on Windows 8.x and we confirm the following to you:

  1. You can install Oracle developer Suite 10g in Windows 10 Professional edition, following the same hacks provided as provided with the following post
  2. You can install Toad 10.x without any issues over Windows 10 without any specific hacks
  3. You can install 11g client 32Bit without any issues, by ignoring the only one warning at the installation startup
  4. You can get over with the Oracle VirtualBox NIC related issues by installing the test build 5.0 (download from VirtualBox test builds)


We are yet to test the developer suite 6i, once completed we will update this thread.

So, we hope you would be more than happy to know that, almost all legacy Oracle products are installable over Microsoft’s latest OS!!



for Windows7bugs