Configure Oracle Native Driver for Linux - Configure Oracle Native Driver for Linux - To configure the Oracle native driver for Linux, complete the following steps. - Perceptive Content - Perceptive Content Database Driver Installation and Setup Guide - Perceptive-Content/Perceptive-Content-Database-Driver-Installation-and-Setup-Guide/Foundation-26.1/Perceptive-Content-Database-Driver-Installation-and-Setup-Guide/Appendix-A-ODBC-database-driver-configuration-examples/Configure-Oracle-Native-Driver-for-Linux - Foundation 26.1 - Foundation 26.1

To configure the Oracle native driver for Linux, complete the following steps.

1. Download the 64-bit instantclient-basic package.
2. Download the 64-bit instantclient-odbc package.
3. Extract the packages into the same directory. Set the extracted directory as the current $ORACLE_HOME environment variable
4. Once the system extracts the files, execute the odbc_update_init.sh from the Instant Client directory. For more information, see the table in the odbc_update_ini.sh arguments section below. odbc_update_ini.sh usage:

   ./odbc_update_ini.sh <ODBCDM_Home> [<Install_Location> <Driver_Name> <DSN>
   <ODBCINI>]

   odbc_udpate_ini.sh example:

   ./odbc_update_ini.sh / `pwd` instant_client_21_1 inow_ora /etc/odbc.ini

5. After the system installs the drivers, you must configure the TNSNAMES file. The default location for the file is in the $ORACLE_HOME/network/admin directory.
   If the directory does not exist, you can create it. This file should contain the service description for each datasource. The following is an example tnsnames.ora file; however, we strongly recommend to consult with your system DBA to ensure the correct configuration for your environment.

   INOWTNS =
   (DESCRIPTION =
    (ADDRESS =
    (PROTOCOL = TCP)
    (HOST = <HostName/IP>)
    (PORT = 1521)
    )
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = INOW)
    )
   )

6. Update the inow_ora datasource configuration in the /etc/odbc.ini file.
   For example, /etc/odbc.ini file contents for odbc_update_ini.sh and TNSNAMES examples above.

   [inow_ora]
   Description=
   Driver=instantclient_21_1
   ServerName=INOWTNS

7. Update the Perceptive Content environment.ini file's IMAGENOW_LD_LIBRARY_PATH value to include the location of the Oracle Instant Client shared libraries.

   IMAGENOW_LD_LIBRARY_PATH=/lib64:/opt/instantClientInstallDir