This procedure installs the the Oracle OCI drivers globally, which means that the drivers will be available for all users on the machine.
We recommend installing the Oracle OCI drivers (and other database drivers) in the correct/default global driver directories for your operating system. However it is possible to install drivers locally (for a single user) if you wish to restrict access.
Do not install Instant Client drivers if Oracle and/or the Instant Client drivers are already installed!
To check, use File Explorer to search for the tsnnames.ora file. If this file exists, speak to your DBA (database administrator) to identify the correct course of action.
How to set up the Oracle instant client OCI drivers:
Windows:
Download the https://www.oracle.com/technetwork/topics/winx64soft-089540.html. Choose the latest version of the Base package, either Basic or Basic Light.
Iguana may not always support the very latest version of the ODBC drivers, so you can simply download an earlier version if necessary.
If you need to know which versions of Oracle OCI are supported by the version of Iguana you are using please contact us at support@interfaceware.com.
In File Explorer, create an installation directory - C:\Oracle is the “standard” location recommended by Oracle.
Unzip the downloaded drivers into the C:\Oracle directory.
Open the instantclient-basic-windows.x6 folder, locate your
instantclient_X_Ydrivers directory and move this to the C:\Oracle directory.
Delete the empty folder the zip was originally unpacked into. There should now be a single folder in C:\Oracle containing the OCI drivers.
Add the OCI drivers directory to the windows Path system variable so that Iguana can find the Oracle drivers automatically.
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:
Highlight the System Path variable and click Edit.
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_NAMES variable must point to the directory containing tnsnames.ora — typically <instantclient install>/network/admin.
If TNS_NAMES does not exist, you will need to create it.
If TNS_ADMIN does not exist then click New… to create it, or click Edit if it already exists:
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.
Restart your computer so that the Environment Variables changes take effect.
Linux:
Download the https://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html. Choose the latest version of the Base package, either Basic or Basic Light.
Iguana may not always support the very latest version of the ODBC drivers, so you can simply download an earlier version if necessary.
If you need to know which versions of Oracle OCI are supported by the version of Iguana you are using please contact us at support@interfaceware.com.
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
Confirm that the /usr/lib/instantclient_X_Y was created:
ls -d in*
Check the contents of the instant client directory:
ls instantclient*
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.
sudo ln -s /usr/lib/instantclient<_X_Y>/libclntsh.so /usr/lib/
Confirm that the symbolic link was created:
ls -l libclntsh.so
