When adding an Oracle connection in Spotlight on Oracle using Oracle 10.2 instant client, the following error is thrown:
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:
Can't initialize OCI. Error -1
Spotlight somehow does not work with Oracle 10.2.0.1 instant client
Using the Oracle 10.2.0.1 client installer, choose the Runtime client option instead of the Instant client.
Install Oracle 11.2 instant client instead.