An error has occurred while loading the Oracle Call Interface (OCI). (4267582)

After installing Spotlight, when trying to run it, the user receives the following error:

An error has occurred while loading the Oracle Call Interface (OCI). The OCIDLL parameter may be incorrect,
or there may be a corruption in TNSNAMES.ORA or an OCI-related DLL.

The following error has been reported:

Initialization error
Could not locate OCI dll

Oracle Homekey:SOFTWARE\ORACLE\KEY_Oracle10g

OracleHomeDir:C:\Oracle\Product\10.2.0\client_1

Please contact Quest support for more information if the error persists.

1: Possible that user does not have Oracle client software installed.

2: Spotlight not being able to locate the OCI.dll.

3. 32 bit Oracle client is required.

RESOLUTION 1:

Spotlight on Oracle and Spotlight on RAC require Oracle client software to be installed on the pc where Spotlight is installed. Oracle client software can be obtained from Oracle.

RESOLUTION 2:
Add "c:\oracle\Ora102\instantclient_10_2\db_1\bin" into the PATH.

Alternatively Spotlight has a command option to point to a specific location for OCI.DLL. For example, modifying the Target field

in the desktop icon to something like:

"C:\Program Files\Quest Software\Spotlight\Console\Spotlight.exe" OCIDLL =C:\oracle\product\10.2.0\client_1\BIN\OCI.DLL

RESOLUTION 3:
Uninstall the Oracle client 64 bit and install the Oracle client 32 bit version. This requirement based on the Spotlight release notes.

RESOLUTION 4:
Check value of system variable ORACLE_HOME.