Infrastructure Software

Hi, I'm working nowadays in a DatawareHouse project and for the purpose of accessing the remote data origins I have been testing the use of Oracle Heterogeneous Services on Oracle 10g (R2) on Windows, and I had success accessing remote databases on different database management systems (Informix, SQL Server, etc.) through ODBC (Generic connectivity).

But now, I've moved to Linux (Red Hat Enterprise Linux ES (v. 3 for AMD64/Intel EM64T)), because we will use Oracle 10g for Linux in our testing & production systems.

The Oracle platform that we use is Oracle 10 g R1 [10.1.0.3_x86_64], and when I tried to create the heterogenous services access as I did in Windows I found the following error message as restarting the listener:

TNS-01201: Listener cannot find executable $ORACLE_HOME/bin/hsodbc for SID IFXOD

I have configured the listener.ora, tnsnames.ora files in the $ORACLE_HOME/network/admin and the initIFXOD.ora in the $ORACLE_HOME/hs/admin

listener.ora:
(SID_DESC =
(PROGRAM = hsodbc)
(SID_NAME = IFXOD)
(ORACLE_HOME = The oracle HOME Directory)
)

tnsnames.ora
IFX01ODBC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SID = IFXOD)
)
(HS = OK)
)


What's wrong? Are Heterogeneous Services (HS) supported in Linux?
I also noticed that the $ORACLE_HOME/hs/admin files where missing (the sample files that appear on Windows), and that the file hsodbc is missing (in the bin folder).
I have found the library hsodbc.o in the $ORACLE_HOME/hs/lib32/ folder. Do I have to compile it? I've tried to compile it (doing a make -f ins_rdbms.mk ihsodbc in the $ORACLE_HOME/rdbms/lib folder), but it tells me that there's a missing library [error = /usr/bin/ld: cannot find -lnavhoa ]. Any clue on what's wrong?

I have been looking for some information about this problem, but I have not found a solution, so if you have more information on how could I solve this problem it would be really useful for me. Thanks :)

Álex