[unixODBC-support] Unable to get isql working on AIX 7.1

Sundar Mahadevan sundarmahadevan82 at gmail.com
Thu Jan 21 20:51:24 GMT 2016


Hi All,
I am trying to setup oracle database to connect to db2 to pull data using
dblink using oracle dg4odbc that comes as part of enterprise edition. My
oracle database is on 11gR204 hosted on AIX 7.1 while DB2 is on version
10.5 hosted on RHEL 5.11. I am an oracle dba with limited systems
administration knowledge looking for assistance in getting my setup
working. I installed db2 client which comes with odbc driver and i also
installed unix odbc driver manager (both of them installed as OS user
dbclient). When i try to execute isql, i am getting the error below. Any
help is greatly appreciated.

dbclient at omsa4103:SUPCON(/u13/app/DBCLIENT)> ls -ld
/home/oracle/bin/UnixOdbcDriverManager
drwxrwxr-x    7 oracle   dba             256 Jan 21 14:01
/home/oracle/bin/UnixOdbcDriverManager

I have the following in my .profile.

export LIBPATH=$LIBPATH:/home/oracle/bin/UnixOdbcDriverManager/lib
export
PATH=$PATH:/home/oracle/bin:/home/oracle/bin/UnixOdbcDriverManager/lib:/home/oracle/bin/UnixOdbcDriverManager/bin
export
LD_LIBRARY_PATH=/u01/app/oracle/product/11gR204/db_1/lib:/u13/app/DBCLIENT/sqllib/lib64:/home/oracle/bin/UnixOdbcDriverManager/lib

dbclient at omsa4103:SUPCON(/u13/app/DBCLIENT)> which isql
/home/oracle/bin/UnixOdbcDriverManager/bin/isql
dbclient at omsa4103:SUPCON(/u13/app/DBCLIENT)> isql
exec(): 0509-036 Cannot load program isql because of the following errors:
        0509-022 Cannot load module
/home/oracle/bin/UnixOdbcDriverManager/lib/libodbc.a(libodbc.so.2).
        0509-150   Dependent module /usr/lib/libiconv.a(libiconv.so.2)
could not be loaded.
        0509-152   Member libiconv.so.2 is not found in archive
        0509-022 Cannot load module isql.
        0509-150   Dependent module
/home/oracle/bin/UnixOdbcDriverManager/lib/libodbc.a(libodbc.so.2) could
not be loaded.
        0509-022 Cannot load module .
dbclient at omsa4103:SUPCON(/u13/app/DBCLIENT)>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20160121/03caca91/attachment.html>


More information about the unixODBC-support mailing list