Unable to successfully install SharePlex 7.5 on Windows 2003 64 bit due to message saying it is unable to find "oci.dll"
When Installing SharePlex on Windows 2003 64 bit, it requires a Oracle 32 bit client which path is missing in the PATH environment variable and missing registry entry for OCIDLL pointing to oracle client\ bin where the oci.dll resides under HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Quest Software\SharePlex\{port}
1. Export proper enviroment variables:
- ORACLE_HOME: pointing to the actual ORACLE_HOME
- PATH : must point to {oracle client\bin} and ORACLE_HOME\bin
3. Backup the registry
3.1 Under HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Quest Software\SharePlex\2100
- Add new key and string value: OCIDLL ={PATH to Oracle client\bin}
Example:
1. Go to Start menu | run and type regedit
2. Click File - export and give it a name
3. Go to [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Quest Software\SharePlex\2100, and create a new string value called " OCIDLL" with value: E:\ora_client\product\11.2.0\client_1\bin
The ORACLE_HOME must either be set as environment variable or as a as key and string value in the registry under ORACLE, NOT both.
