Configuring the Streams database adapter for Oracle

This procedure is necessary only if you plan to use an Oracle database.

Before you begin

Ensure that the following prerequisites are met.

The Oracle 12c client is installed on the machine where the Streams server is installed.
Use UnixODBC 2.3.2

Procedure

On the machine where the Streams server is installed, edit the Streamsadmin user's /home/streamsadmin/.bashrc file to add the following environment variable commands.

Example commands:

export ORACLE_HOME=/data/DatabaseServer/Oracle12C/product/12.1.0/dbhome_1
export LD_LIBRARY_PATH=/data/DatabaseServer/Oracle12C/product/12.1.0/dbhome_1
/lib:/data/DatabaseServer/Oracle12C/product/12.1.0/dbhome_1/lib64:/usr/local
/lib:/usr/local/lib64
export ODBCINI=/home/streamsadmin/ODBCINI/odbc.ini
export STREAMS_ADAPTERS_ODBC_ORACLE=true
export STREAMS_ADAPTERS_ODBC_INCPATH=/usr/local/include
export STREAMS_ADAPTERS_ODBC_LIBPATH=/usr/local/lib

Table 1. Environment variables for Oracle on Streams
Environment variable	Example value
Variables for compiling Streams adapters with Oracle
STREAMS_ADAPTERS_ODBC_ORACLE	True
STREAMS_ADAPTERS_ODBC_INCPATH	/mydir/unixodbc/include
STREAMS_ADAPTERS_ODBC_LIBPATH	/mydir/unixodbc/lib
Variables for running Streams adapters with Oracle
ODBCINI	/mydir/odbc.ini
ORACLE_HOME	/home/oracle/oracle/112client/oracle/product/11.2.0/client_1
LD_LIBRARY_PATH	If you use static linking: /home/oracle/oracle/112client/oracle/product/11.2.0/client_1/lib If you do not use static linking: /home/oracle/oracle/112client/oracle/product/11.2.0/client_1/lib:/mydir/unixodbc/lib

Configure UNIX ODBC as follows.

Untar UnixODBC and execute following commands.
```
./configure
make
make install
```

Create a file named odbc.ini under /home/streamsadmin/ODBCINI with the following content. Use the host, port, and Oracle instance name appropriate for your environment.

[Your_Oracle_instance_name]
Driver = /data/DatabaseServer/Oracle12C/product/12.1.0/dbhome_1
/lib/libsqora.so.12.1
description = test
ServerName = IP:port/Oracle_instance_name
server = IP
port = Port No
Longs = F

To test your configuration, run the following command as the streamsadmin user.

Use the Oracle instance name, user name, and password appropriate for your environment.

isql Oracle_instance_name user_name password

If the test fails, check your execution of the preceding steps. Remember that names are case-sensitive.