April 2017

Configuring unixODBC on Linux, can be  a general requirement for Peoplesoft or many Application to connect to Oracle database.

Check whether all required RPMs present or Not…as follows.

 

[root@SAMOEL47UAT2 unixODBC-2.2.14]# rpm -q unixODBC
unixODBC-2.2.11-1.0.1.RHEL4.1
[root@SAMOEL47UAT2 unixODBC-2.2.14]# rpm -q qt
qt-3.3.3-13.RHEL4
[root@SAMOEL47UAT2 unixODBC-2.2.14]# rpm -q unixODBC-kde
unixODBC-kde-2.2.11-1.0.1.RHEL4.1
Output of following command should be /usr

[root@SAMOEL47UAT2 unixODBC-2.2.14]# odbc_config --prefix

Result of above ccommand on Oracle Enterprise Linux is:
/usr
Now copy the unixODBC-2.2.14.tar to /u01

then extract it using tar -xvf unixODBC-2.2.14.tar which will create a folder called unixODBC-2.2.14

Now go to that folder execute the following commands in the appropriate order

cd unixODBC-2.2.14
./configure --prefix=/u01/unixODBC-2.2.14/ --exec-prefix=/u01/unixODBC-2.2.14/ --enable-gui=no
make
make install

 Continue reading...