Configure unixODBC for Oracle on Linux 64

1. Go to the $DRIVER directory.
2. Run the command:

./odbc_update_ini.sh $UNIXODBC $DRIVER Oracle11gDriver ORAONLIN64

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:

[ORAONLIN64]
Application Attributes = T
Attributes = W
BatchAutocommitMode = IfAllSuccessful
BindAsFLOAT = F
CloseCursor = F
DisableDPM = F
DisableMTS = T
Driver = Oracle11gDriver
DSN = ORAONLIN64
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. 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)
    )
  )

4. 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.
5. Set variables:

export ORACLE_HOME=$DRIVER/
export LD_LIBRARY_PATH=$UNIXODBC/lib/:$DRIVER/:

6. Test the DSN connection:
   ./isql -v ORAONLIN64