How to configure TIBCO ActiveMatrix Adapter 6.3.0 to work with Oracle Non-Wired protocol on a Linux platform.

How to configure TIBCO ActiveMatrix Adapter 6.3.0 to work with Oracle Non-Wired protocol on a Linux platform.

book

Article ID: KB0093745

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Database -
Not Applicable -

Description

Description:
How to configure TIBCO ActiveMatrix Adapter 6.3.0 to work with Oracle Non-Wired protocol on a Linux platform.

Resolution

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

2).  Run: file <ADB_HOME>/odbc/lib/TIor826.so to get non-wired driver lib 32- bit file.

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

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

5). Run: ldd <ADB_HOME>/odbc/lib/ tior826.so to make sure files are linked normally.

6). Make sure the current TIBCO ActiveMatrix Adapter user has read and executed permission to the linked files: libclntsh.so and libclntsh.so.11.1. If not, ask an Admin to assign.

7). Edit odbc.ini to include:
    [oraclenonwireddsn]
    Driver=<ADB_HOME>/odbc/lib/ tior826.so
    ServerName=servername(defined in tnsnames.ora) TNSNamesFile=/db/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora

8). Add <ORACLE_HOME>/lib32 into tibco.env.CUSTOM_LIB_PATH in tra file, for example:
    tibco.env.CUSTOM_LIB_PATH /db/oracle/product/11.2.0/db_1/lib32:/adapters/spadb/tibco/adapter/adadb/6.3/odbc/

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

Issue/Introduction

How to configure TIBCO ActiveMatrix Adapter 6.3.0 to work with Oracle Non-Wired protocol on a Linux platform.
Powered by Wolken Software