Jump to: navigation, search

Configure unixODBC for Oracle on AIX 64

  1. Go to the $DRIVER directory.
  2. Run
    ./odbc_update_ini.sh $UNIXODBC $DRIVER Oracle11gDriver ORAIX64
    1. As a result, odbcinst.ini gets updated with:
    2. [Oracle11gDriver]
      Description = Oracle ODBC driver for Oracle 11g
      Driver = $DRIVER/libsqora.so.11.1
      Setup =
      FileUsage =
      CPTimeout =
      CPReuse =

    3. .odbc.ini gets updated with:
    4. [ORAIX64]
      Application Attributes = T
      Attributes = W
      BatchAutocommitMode = IfAllSuccessful
      BindAsFLOAT = F
      CloseCursor = F
      DisableDPM = F
      DisableMTS = T
      Driver = Oracle11gDriver
      DSN = ORAIX64
      EXECSchemaOpt =
      EXECSyntax = T
      Failover = T
      FailoverDelay = 10
      FailoverRetryCount = 10
      FetchBufferSize = 64000
      ForceWCHAR = F
      Lobs = T
      Longs = T
      MaxLargeData = 0
      MetadataIdDefault = F
      QueryTimeout = T
      ResultSets = T
      ServerName =
      SQLGetData extensions = F
      Translation DLL =
      Translation Option = 0
      DisableRULEHint = T
      UserID =
      StatementCache=F
      CacheBufferSize=20
      UseOCIDescribeAny=F

  3. Replace the following line in odbcinst.ini:
    Driver= $DRIVER/libsqora.so.11.1
    with
    Driver= $DRIVER/libsqora.so
    which is the reference to the driver file. Verify the existence of this file, which is delivered during the unpacking of the ORACLE drivers.
  4. Create a new Network Configuration file named $HOMEDIR/.tnsnames.ora with the following:
     MY_ORAQ =
      (DESCRIPTION =
        (ADDRESS_LIST =
          (ADDRESS = (PROTOCOL = TCP)(HOST = oraclehost)(PORT = 1521))
        )
        (CONNECT_DATA =
          (SERVICE_NAME = my_oraq)
        )
      )
    
  5. In the .odbc.ini file, change ServerName to be the same as SERVICE_NAME in the .tnsnames.ora file, and set UserID to SCOTT and set Password=tiger.
  6. Set variables:
    export LIBPATH=$UNIXODBC/lib/:$DRIVER/:
    export ORACLE_HOME=$DRIVER/
  7. Test the connection:
    ./isql -v ORAIX64
This page was last edited on June 19, 2020, at 14:27.
Comments or questions about this documentation? Contact us for support!