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:

   [Oracle11gDriver]
   Description = Oracle ODBC driver for Oracle 11g
   Driver = $DRIVER/libsqora.so.11.1
   Setup =
   FileUsage =
   CPTimeout =
   CPReuse =

   2. .odbc.ini gets updated with:

   [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