Versions Compared

Old Version 1

changes.mady.by.user Aryn Wiebe

Saved on

compared with

New Version Current

changes.mady.by.user Aryn Wiebe

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleSTEP 1: Install the latest Oracle OCI instant client drivers

  1. Download the https://www.oracle.com/technetwork/topics/winx64soft-089540.html. Choose the latest version of the Base package, either Basic or Basic Light.

Info

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.

  1. In File Explorer, create an installation directory - C:\Oracle is the “standard” location recommended by Oracle.OracleClient

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

  3. Open the instantclient-basic-windows.x6 folder, locate your instantclient_X_Y drivers directory and move this to the C:\Oracle directory.

delete empty zip folderImage Removed

  1. Delete the empty folder the zip was originally unpacked into. There should now be a single folder in C:\Oracle containing the OCI drivers.

Image Added
Expand
titleSTEP 2: Add the OCI drivers directory to the windows Path system variable

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:

system properties advancedImage RemovedImage Added

  1. Highlight the System Path variable and click Edit.

highlight system pathImage RemovedImage Added

  1. 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:

oci system variable pathImage RemovedImage Added
Expand
titleSTEP 3: Create or ensure TNS_NAMES ADMIN variable points to the directory containing tnsnames.ora

In the System Variables, the TNS_NAMES ADMIN 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.

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

add or edit TNS_NAMESImage Removed

  1. .

  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.

TNS_ADMIN update pathImage RemovedImage Added

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

Expand
titleSTEP 4: Confirm IguanaX has detected the Oracle OCI library in Settings > Database

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

Image Added

 

Linux:

Expand
titleSTEP 1: Install the latest Oracle OCI instant client drivers

  1. 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.

Info

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.

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

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

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

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

    Code Block
    ls -d in*
confirm install

  1. Check the contents of the instant client directory:

    Code Block
    ls instantclient*
instan client driver files

  1. 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.

      Code Block
      sudo ln -s /usr/lib/instantclient<_X_Y>/libclntsh.so /usr/lib/

  2. Confirm that the symbolic link was created:

    Code Block
    ls -l libclntsh.so
link to OCI
Expand
titleSTEP 2: Update the runtime link path for dynamic libraries

This tells the instantclient software where to look for dynamic library dependencies.

Only do this if the instantclient is the only Oracle software you are installing! Do not do this if you are installing the Oracle database server on the same machine, instead discuss it with your DBA.

Update the instant client configuration file:

Code Block
sudo sh -c "echo /opt/oracle/instantclient_18X_3Y > \ /etc/ld.so.conf.d/oracle-instantclient.conf" 
sudo ldconfig
Expand
titleSTEP 3: Install the libaio (or libaio1) package

You will need to use different (package installer) commands depending on the version of Linux you are using. For Ubuntu (Debian based) use apt, for CentOS (RHEL based) use yum.

Ubuntu or other Debian based Linux:

  1. Get the latest package info:

    Code Block
    sudo apt update

  2. Install libaio/libaio1:

    Code Block
    sudo apt install libaio1

CentOS or other Red Hat based Linux:

  1. Get the latest package info:

    Code Block
    yum check-update

  2. Install libaio/libaio1:

    Code Block
    sudo yum install libaio

  3. Delete the zip package (or keep a copy if you prefer).

Expand
titleSTEP 4: Confirm IguanaX has detected the Oracle OCI library in Settings > Database

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 within your instantclient directory for the latest version.

Image Added