Return
-
Title
Error creating connection: "Can't initialize OCI. Error -1" -
Description
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
-
Cause
Spotlight somehow does not work with Oracle 10.2.0.1 instant client
-
Resolution
WORKAROUND 1
Using the Oracle 10.2.0.1 client installer, choose the Runtime client option instead of the Instant client.
WORKAROUND 2
Install Oracle 11.2 instant client instead.