oracledllspotlightquest

Quest Spotlight oci.dll


My Quest Spotlight Trial does not connect to DB. When I run the user wizard it always comes:

Cannot load OCI DLL: oci.dll

It is a 64-bit Windows Server / 64 bit Oracle server.

I've already installed the 32 bit Oracle client and added the dict to path, but nothing worked.

Does someone have a tip for me?


Solution

  • According to Spotlight requirements:

    Note: Spotlight will run on 64-bit versions of the client operating system with the use of a 32-bit Oracle client.

    If you have 64-bit server and 32-bit client installed on the same computer it's possible that Spotlight looks for oci.dll at wrong Oracle Home.

    Examine order of Oracle home directories from Universal Installer and place 32-bit home first:

    1. Run Oracle Universal Installer
    2. Click "Installed Products" button
    3. Switch to "Environment" tab
    4. Reorder Oracle Homes with arrows on right side and click "Apply"