The issue with 32bit Oracle client you identified, we believe it relates to Oracle 10g client environments where SQL Nav Home selection tries to unload and load Oci.dll and other Oracle dlls on the flight at run time.
In some of 10g client install environment, there are a number of steps need to be done after you install 10g clients in order to have oci.dll unloading correctly. Below is the extract from Oracle doc on the issues:
■ From Client Admin InstallInstead of copying libociei.so or oraociei10.dll from theORACLE_HOME/instantclient directory, copy libociicus.so ororaociic10.dll from the ORACLE_HOME/instantclient/light directory.That is, the Instant Client directory on the LD_LIBRARY_PATH, in UNIX, should contain the Instant Client Light data shared library, libociicus.so, instead of the larger OCI Instant Client data shared library, libociei.so. In MicrosoftWindows, PATH should contain oraociicus10.dll instead oforaociei10.dll.■ From Oracle Universal InstallerIf the Instant Client option is selected from the Oracle Universal Installer, thenlibociei.so (or oraociei10.dll on Microsoft Windows) is installed in thebase directory of the installation which is going to be placed onLD_LIBRARY_PATH. This is so that Instant Client Light is not enabled by default.The Instant Client Light data shared library, libociicus.so (ororaociicus10.dll on Microsoft Windows), is installed in the lightsubdirectory of the base directory. Therefore, to operate in the Instant Client Light mode, the OCI data shared library, libociei.so (or oraociei10.dll onWindows) must be deleted or renamed and the Instant Client Light data sharedlibrary must be copied from the light subdirectory to the base directory of theinstallation.For example, if the Oracle Universal Installer has installed the Instant Client inmy_oraic_10_2 directory on LD_LIBRARY_PATH, then one would need to do the following to operate in the Instant Client Light mode.cd my_oraic_10_2rm libociei.somv light/libociicus.so .
Thanks for bringing this up. We will try to get the info into our release note for 5. 5 release informing our users how to address these issues.
Thanks and regards,