How To Install and Configure the Lite Edition ODBC Drivers for Oracle (Linux)

Pre-Installation Guide

  1. You must be able to establish a connection with your target Oracle Database using existing Oracle Client Software. If you encounter problems making a connection to your target database, please check the following settings:
    • Oracle SID: Specify the Oracle System Identifier (SID) of your database.
    • Oracle TCP Port: Provide the TCP port number used for communication with the Oracle database.
    • Oracle SQL*Net or Net Service Name: Specify the SQL*Net or Net Service Name for your Oracle database.
    • Hostname or IP address of Oracle database server: Provide the hostname or IP address of the server where your Oracle database is located.

Installation Guide

  1. The installation files ship as an installation shell script, a driver and admin .taz file, and a license .lic file. The installation shell script should be ftp'd in ascii. The rest of the files should be ftp'd in binary, where applicable.
  2. Downloads these documents, and place them in your desired installation folder.
  3. Start the installation process by opening the installation directory using cd, and running sh install.sh.
  4. You must choose a TCP port on which to run your HTTP-based iODBC Data Sources Administrator. The default is 8000. You will need to know this port number and your local machine's IP address or hostname to access your Admistrator in a Web browser. This is how you call it: http://machine:portnumber
  5. Log File? enables you to rename and relocate your Administrative Assistant's log file. It is best to go with the default.
  6. You can choose to log all requests. This is not diagnostic-level odbc tracing or connection logging. The default is no.
  7. You can change the iODBC Data Source Administrator's default username from "admin." This is the name that you will need to login to OpenLink's HTTP-based iODBC Data Sources Administrator.
  8. You can change the iODBC Data Source Administrator's default password from "admin."
  9. The installation is complete.

Configuration Guide

  1. Prerequisites:
    • You MUST be proficient in using a Unix shell.
    • You MUST be proficient in using a Unix editor such as vi.
    • You MUST be in possession of relevant database connectivity details such as Database name, Username, password, etc.
    • You MUST have installed and available either a full installation of Oracle, Oracle Client, or Oracle Instant Client (release 6.x only).
  2. Open the file <OPENLINK_INSTALL>/openlink.sh with a suitable text editor such as vi.
  3. Locate the section that deals with the location of shared libraries pertaining to your system (LD_LIBRARY_PATH, LIBPATH, or SHLIB_PATH) and add to it the location of your Informix lib and lib/esql directories: 
          LD_LIBRARY_PATH="<OPENLINK_INSTALL>/lib:/oracle/lib:$LD_LIBRARY_PATH"
  4. Open the file <OPENLINK_INSTALL>/openlink.ini with a suitable text editor such as vi.
  5. Locate the [Environment Oracle xxx] section that deals with the driver specific Oracle configuration and edit to reflect your Oracle installation: 
          [Environment Oracle 10.x]
      ORACLE_HOME        = /oracle/
      ;ORACLE_SID         = ORCL
      ;ORACLE_SERVER      = T
      ;TWO_TASK           = P:
      ;ODBC_CATALOGS      = Y     ; Uncomment after loading odbccat10.sql
      ;MULTIPLEX_LDA      = 5     ; Allow 5 OpenLink clients on a single lda
      ;OPL_USR_TBLS_FIRST = Y     ; Sort SQLTables starting with user tables
      SHOW_REMARKS        = N     ; Retrieve SQLColumns REMARKS field
      CURSOR_SENSITIVITY  = LOW   ; Set to HIGH after loading odbccat10.sql
      ;OCI_PREFETCH_ROWS  = 100   ; Number of rows to prefetch
      ;OCI_PREFETCH_MEMORY = 65535 ; Amount of memory to use for prefetching
      ;NLS_LANG           = AMERICAN_AMERICA.UTF8 ; Unicode connection
  6. Open the file <OPENLINK_INSTALL>/bin/odbc.ini with a suitable text editor such as vi.
  7. Locate and edit the sample OpenLink Oracle ODBC data source (DSN) created during the installation process and edit as follows: 
          [oracle]
      Driver            = <OPENLINK_INSTALL>/lib/ora100_mt_lt.so
      ServerType        = Oracle 10.x
      Options           = <TNSName>
      Username          = <scott>
      Password          = <**********>
      FetchBufferSize   = 99
      ReadOnly          =
      DeferLongFetch    =
      JetFix            = No
      Description       = Sample Oracle 10.x Lite Connection
  8. Use the iodbctest tool which is packaged with the HTTP-based OpenLink ODBC Administrator as follows: 
          # cd <OPENLINK_INSTALL>
      # . ./openLink.sh
      # iodbctest oracle
    iODBC Demonstration program
    This program shows an interactive SQL processor
    Driver Manager: 03.52.0507.0105
    Driver: 06.02.1217 OpenLink Generic ODBC Driver (ora100_mt_lt.so)

    SQL>
  9. You should now be able to issue SQL statements directly against the target database.

Additional Information:
The bitness of the ODBC Driver for MySQL is determined by the bitness of your ODBC client application.
That is, if your ODBC client application is 32-bit then the Generic ODBC Driver component MUST also be 32-bit.