Oracle OCI Driver Setup

1. Download the Instant Client for Microsoft Windows (x64) 64-bit. Choose the latest version of the Base package, either Basic or Basic Light.

2. In File Explorer, create an installation directory - C:\OracleClient

3. Unzip and extract the downloaded drivers into the C:\OracleClient directory.

Open

Add the OCI drivers directory to the windows Path system variable so that Iguana can find the Oracle drivers automatically.

1. In Windows, search for “Environment” and choose Edit the system environment variables to open the System Properties window. Click the Environment Variables button near the bottom of the page:

Open

2. Highlight the System Path variable and click Edit.

3. In the Edit environment variable window, add the location of your oci.dll file on the next line, and click OK to save your changes:

In the System Variables, the TNS_ADMIN variable must point to the directory containing tnsnames.ora — typically <instantclient install>/network/admin.

1. If TNS_ADMIN does not exist then click New to create it, or click Edit if it already exists.

2. Enter the path to the directory containing tnsnames.ora — typically <instantclient install>/network/admin, and click OK. If you are using an existing driver install then use the path that your DBA (database administrator) advises you to use.

3. Restart your computer so that the Environment Variables changes take effect.

In IguanaX, Settings > Database confirm the Oracle OCI library has been detected and loaded correctly.

If not, click Edit to manually add the Oracle OCI shared library path. If you don’t know the location, you can search for the oci.dll

1. Download the Instant Client for Linux x86-64 (64-bit). Choose the latest version of the Base package, either Basic or Basic Light.

2. Unzip the package in the /usr/lib directory:

   • Note: change <version> to match your downloaded version

     cd /usr/lib sudo unzip ~/Downloads/instantclient-basic-linux.x64-<version>.zip

3. Confirm that the /usr/lib/instantclient_X_Y was created:

   ls -d in*

4. Check the contents of the instant client directory:

   ls instantclient*

5. Create a symbolic link in the /usr/lib directory:

   • Note: replace “<_X_Y>” with the version numbers to match the directory name for the downloaded version. If you are upgrading to a new version of OCI you will need to delete the old symbolic link and recreate it to point to the new version of OCI.

6. Confirm that the symbolic link was created: