[freetds] Generic Connectivity Using ODBC

Зверев Виталий Борис Зверев Виталий Борис
Tue May 3 06:02:01 EDT 2005


Hi, Daron.
Listener is trying to launch the heterogeneous agent but
1) heterogeneous agent may be absent (not installed)
2) pointed into wrong ORACLE_HOME via listener.ora  
3) has wrong permissions

You could try to check it:

bash-2.03$ cd $ORACLE_HOME/rdbms/lib
bash-2.03$ make -f ins_rdbms.mk ihsodbc

 - Linking hsodbc agent
rm -f /home2/u01/app/oracle/product/9.2/rdbms/lib/hsodbc
/usr/ccs/bin/ld -o /home2/u01/app/oracle/product/9.2/rdbms/lib/hsodbc
-L/home2/u01/app/oracle/product/9.2/rdbms/lib/
-L/home2/u01/app/oracle/product/9.2/lib/ -dy
/home2/u01/app/oracle/product/9.2/lib/WS6U1/crti.o
/home2/u01/app/oracle/product/9.2/lib/WS6U1/crt1.o
/home2/u01/app/oracle/product/9.2/hs/lib/hsodbc.o
/home2/u01/app/oracle/product/9.2/rdbms/lib/defopt.o
/home2/u01/app/oracle/product/9.2/rdbms/lib/homts.o
-L/home2/u01/app/oracle/product/9.2/lib/  -lnavhoa  -lhsnav -lhsbase
-lagtsh -lpls9 -lplp9 -lthread  -lclntsh  -lnls9  -lcore9 -lnls9 -lcore9
-lnls9 -lxml9 -lcore9 -lunls9 -lnls9
/home2/u01/app/oracle/product/9.2/lib/libgeneric9.a   `cat
/home2/u01/app/oracle/product/9.2/lib/sysliblist` -R
/opt/SUNWcluster/lib:/home2/u01/app/oracle/product/9.2/lib  -Y
P,:/opt/SUNWcluster/lib:/usr/ccs/lib:/usr/lib  -Qy -lc -laio -lposix4
-lkstat -lm  /home2/u01/app/oracle/product/9.2/lib/WS6U1/crtn.o   -lvsn9
mv -f /home2/u01/app/oracle/product/9.2/bin/hsodbc
/home2/u01/app/oracle/product/9.2/bin/hsodbcO
mv /home2/u01/app/oracle/product/9.2/rdbms/lib/hsodbc
/home2/u01/app/oracle/product/9.2/bin/hsodbc
chmod 751 /home2/u01/app/oracle/product/9.2/bin/hsodbc
bash-2.03$ 

bash-2.03$ /home2/u01/app/oracle/product/9.2/bin/hsodbc

Oracle Corporation --- TUESDAY   MAY 03 2005 13:59:10.572

Heterogeneous Agent Release 9.2.0.5.0 - Production  Built with
   Driver for ODBC

Sincerely yours. 

------------------------------------------------------------ 
 Vitaly Zverev, Oracle Applications DBA,
   Genesis Ltd., St.Petersburg, Russia 
>>>>>> Tel : +7(812) 329-5689  <<<<<<
>>>>>>>> http://www.gen.ru <<<<<<<<



-----Original Message-----
From: freetds-bounces at lists.ibiblio.org
[mailto:freetds-bounces at lists.ibiblio.org] On Behalf Of Daron Daron
Sent: Tuesday, May 03, 2005 12:57 PM
To: freetds at lists.ibiblio.org
Subject: [freetds] Generic Connectivity Using ODBC 


Hi,
   I have oracle 9i on linux redhat 9, and the MSSQL is runing on window 
2003. I try with no luck and having the same problems. Hope can get some 
hints from you guys.

TNS:01201 : listener cannot find executable 
/opt/oracle/product/9.2.0/bin/hsodbc for SID DBSTAF.
Listener failed to start


initDBSTAF.ora
# This is a sample agent init file that contains the HS parameters that are
# needed for an ODBC Agent.

#
# HS init parameters
#
HS_FDS_CONNECT_INFO = DbStaf
HS_FDS_TRACE_LEVEL = off
HS_FDS_SHAREABLE_NAME = /usr/local/lib/libodbc.so

#
# ODBC specific environment variables
#
set ODBCINI=/etc/odbc.ini


Thanks

Daron

_________________________________________________________________
Block pop-up ads with MSN Toolbar. http://toolbar.msn.com.my/

_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


More information about the FreeTDS mailing list