Resolution:
Description:
= = = = = = =
There are some aspects which need attention when configuring a non-wired protocol driver on UNIX such as the Oracle lib type and DSN configuration in odbc.ini.

Environment:
= = = = = = =
TIBCO Adapter(TM) for ActiveDatabase
UNIX
Oracle db server or client

Resolution:
= = = = = =
1).  Make sure the Oracle client or server is installed.

2).  Run: file /tibco/adapter/adadb/5.3/odbc/lib/TIor822.so to get non-wired driver lib 32- bitfile.      Note: for adb 6.0 it is TIor823.so

3).  Edit adbagent_env.sh:
     Add Oracle lib32 path like "LD_LIBRARY_PATH=/db/oracle/product/10.2.0/db_1/lib32" in the first position after "if" and "then";
     Add ORACLE_HOME like:     ORACLE_HOME=/db/oracle/product/10.2.0/db_1
                export ORACLE_HOME

4). Source the adbagent_env.sh: ". ./adbagent_env.sh"

5). Run: ldd tibco/adapter/adadb/5.3/odbc/lib/TIor822.so to make sure files are linked normally.

6). Make sure the current Tibco adapter user has read and executed permission to the linked files: libclntsh.so and libclntsh.so.10.1. If not, ask admin to

assign.

7). Edit odbc.ini to include:
    [oraclenonwireddsn]
    Driver=/adapters/spadb/tibco/adapter/adadb/5.3/odbc/lib/TIor822.so
    ServerName=servername(defined in tnsnames.ora) TNSNamesFile=/db/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora

8). Add &ltORACLE_HOME>/lib32 into tibco.env.CUSTOM_LIB_PATH in tra file, for example:
    tibco.env.CUSTOM_LIB_PATH /db/oracle/product/10.2.0/db_1/lib32:/adapters/spadb/tibco/adapter/adadb/5.3/odbc/

9). Run dbtest to confirm the configuration of the non-wired DSN :
    ./dbtest user/password@nonwierddsnname

How to configure TIBCO Adapter(TM) for ActiveDatabase to use non-wired driver on UNIX for the Oracle database?