/etc/odbcinst.ini where DM-HOME is the data manager home (locate odbcinst) * and ~/.odbc.ini === Drivers === Example * odbcinst.ini cat /usr/local/etc/odbcinst.ini 
[Oracle 11g ODBC driver]Description     = Oracle ODBC driver for Oracle 11gDriver          = /u01/app/oracle/instantclient_11_2/libsqora.so.11.1Setup           =FileUsage       =CPTimeout       =CPReuse         =
=== DSN === * odbc.ini cat ~/.odbc.ini * Minimal parameters 
[Dsn]Driver = /u01/app/oracle/instantclient_12_1/libsqora.so.12.1ServerName = TNS_NAME
* Complete: 
[OracleODBC-11g]Application Attributes = TAttributes = WBatchAutocommitMode = IfAllSuccessfulBindAsFLOAT = FCloseCursor = FDisableDPM = FDisableMTS = TDriver = Oracle 11g ODBC driverDSN = OracleODBC-11gEXECSchemaOpt =EXECSyntax = TFailover = TFailoverDelay = 10FailoverRetryCount = 10FetchBufferSize = 64000ForceWCHAR = FLobs = TLongs = TMaxLargeData = 0MetadataIdDefault = FQueryTimeout = TResultSets = TServerName =SQLGetData extensions = FTranslation DLL =Translation Option = 0DisableRULEHint = TUserID =StatementCache=FCacheBufferSize=20UseOCIDescribeAny=F
==== Test it ==== with unixODBC - isql isql -v OracleODBC-11g ===== Support ===== ==== undefined symbol: SQLGetPrivateProfileStringW ==== You may get the following: 
isql: symbol lookup error: /u01/app/oracle/instantclient_11_2/libsqora.so.11.1: undefined symbol: SQLGetPrivateProfileStringW
This is normally because the driver manager (unixODBC) version is not compatible with the ODBC driver. Verify the #driver manager version needed for the oracle ODBC database version.


See below how to search for a symbol: * Symbol lookup nm -A /u01/app/oracle/instantclient_11_2/libsqora.so.11.1 | grep SQLGetPrivateProfileStringW 
/u01/app/oracle/instantclient_11_2/libsqora.so.11.1:                U SQLGetPrivateProfileStringW
SQLGetPrivateProfileStringW is defined in the last libodbc.so and libodbcinst.so. nm -A /usr/lib/libodbcinst.so | grep SQLGetPrivateProfileStringW 
Blank
===== Documentation / Reference ===== * Installation Guide * mkleehammer/pyodbc/wiki/Connecting-to-Oracle-from-RHEL-or-Centos * http://stackoverflow.com/questions/13922415/how-do-i-setup-oracle-odbc-drivers-on-rhel-6-linux