When running command line utilities for TIBCO iProcess Engine (iPE) on Windows, you may encounter "oci.dll is not found" and "SQLlib80.dll is not found" warning messages.

When running command line utilities for TIBCO iProcess Engine (iPE) on Windows, you may encounter "oci.dll is not found" and "SQLlib80.dll is not found" warning messages.

book

Article ID: KB0094508

calendar_today

Updated On:

Products Versions
TIBCO iProcess Engine (Oracle) -
Not Applicable -

Description

Description:
After installing Windows updates and restarting the iProcess Engine, you may receive warning messages when using command line utilities in iPE stating that the state oci.dll and SQLlib80.dll files are not found.

Symptoms:
When running commands such as swutil, swadm, swsvrmgr and sweaireg, you may see entries like the following added to the normal command output.

LoadLibraryFromPath: FQ Dll C:\Windows\system32\oci.dll is not found, error: 0x7e
LoadLibraryFromPath: FQ Dll C:\Windows\system32\SQLLib80.dll is not found, error: 0x7e

Cause:
Microsoft Security Update 3126587 (https://support.microsoft.com/en-us/kb/3126587) triggers these added warnings about missing .dll files. The iPE command line binaries do not call these .dll files directly, so the entries can be ignored. The added warnings are displayed by iPE binaries that issue COM+ events that utilize MSDTC. 

Issue/Introduction

When running command line utilities for TIBCO iProcess Engine (iPE) on Windows, you may encounter "oci.dll is not found" and "SQLlib80.dll is not found" warning messages.

Resolution

Microsoft has issued a fix for this issue via KB 3147071 (https://support.microsoft.com/en-us/kb/3147071).  You should apply KB 3147071 rather than performing any of the below steps.  

***************************************************************************************************************
Deprecated workaround steps. Apply KB 3147071 rather than performing any of the steps below.
***************************************************************************************************************

1). The messages can be ignored as they do not cause any functionality problems.

2). When using the Windows (Oracle) version of iPE, navigate to the following registry key using regedit.

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\MSDTC\MTxOCI

Modify the OracleSqlLib and the OracleXaLib keys to be valid .dll files for your Oracle client.  As of this writing, all supported iPEs are using 11g Oracle clients, so the value for OracleSqlLib would be orasql11.dll and the value for OracleXaLib would be oraclient11.dll. After making these modifications, the warning messages should no longer be displayed.
 
3). When using a Windows (SQL) version of iPE that will not have an Oracle client installed, navigate to the following key.

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\MSDTC\MTxOCI

Delete the value for the OracleOciLib key (originally oci.dll). After making this change, the warning messages should not be seen.

4). Security Update 3126587 can be uninstalled but removing security updates is not advised by TIBCO Support at this time.

Additional Information

https://support.microsoft.com/en-us/kb/3126587
https://support.microsoft.com/en-us/kb/3147071