Знаю что тема много раз поднималась, весь форум уже перерыл и инет в том числе.
Имеем unixODBC freetds oracle 11 solaris 10 mssql 2008

-bash-3.2# cat /etc/odbcinst.ini
[FreeTDS]
Driver=/usr/local/lib/libtdsodbc.so
client charset=utf-8
UsageCount=23

-bash-3.2# cat /etc/odbc.ini
[MyMSSQL]
Driver=FreeTDS
Servername=MyMSSQL
TDS_Version=8.0
Database=BPMonline
UID=IBSOUser
PWD=IBSOUser
CHARSET=utf8

-bash-3.2# cat /usr/local/etc/freetds.conf
[MyMSSQL]
host = srv-mssql
port = 1433
tds version = 8.0
client charset = UTF-8
dump file = /tmp/freetds.log
dump file append = yes

-bash-3.2# isql -v MyMSSQL IBSOUser IBSOUser
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> select count(*) from contact;
+------------+
| |
+------------+
| 43 |
+------------+
SQLRowCount returns 1
1 rows fetched
SQL>


до этого все как бы хорошо

а вот oracle подключаться никак не хочет:

-bash-3.2# cat /u/app/oracle/product/11.2.0/db_1/hs/admin/initMyMSSQL.ora
HS_FDS_CONNECT_INFO=MyMSSQL
HS_FDS_SHAREABLE_NAME = /usr/local/lib/libtdsodbc.so
HS_FDS_TRACE_LEVEL=255
set ODBCINI = /etc/odbc.ini
set ODBCINSTINI = /etc/odbcinst.ini
#HS_LANGUAGE=AMERICAN_AMERICA.UTF8
HS_LANGUAGE=RUSSIAN_RUSIA.UTF8
#HS_FDS_SQLLEN_INTERPRETATION=32


-bash-3.2# cat /u/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
HS =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= TCP)(Host= 192.168.2.47 )(Port= 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROCHS))
)
SID_LIST_HS =
(SID_LIST =
(SID_DESC =
(PROGRAM=dg4odbc)
(SID_NAME = MyMSSQL)
(ORACLE_HOME = /u/app/oracle/product/11.2.0/db_1/)
(ENVS="LD_LIBRARY_PATH=/u/app/oracle/product/11.2.0/db_1/lib:/usr/lib:/usr/local/lib/sparcv9/:/usr/local/lib:/usr/openwin/lib:/usr/dt/lib")
)
)
CONNECT_TIMEOUT_HS = 10
INBOUND_CONNECT_TIMEOUT_HS = 0
STARTUP_WAIT_TIME_HS = 0


sun04.oracle> tnsping MyMSSQL

TNS Ping Utility for Solaris: Version 11.2.0.3.0 - Production on 19-JUL-2014 12:19:27

Copyright (c) 1997, 2011, Oracle. All rights reserved.

Used parameter files:
/u/app/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.47)(PORT = 1522)) (CONNECT_DATA = (SID = MyMSSQL) (SERVICE_NAME = MyMSSQL)) (HS = OK))
OK (10 msec)


При попытке сделать заброс из дблинка получаем:
SQL> select count(*) from "Contact"@dl_terrasoft;
select count(*) from "Contact"@dl_terrasoft
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
ORA-02063: preceding line from DL_TERRASOFT

Кусок трассировки:

Exiting hgolofns at 2014/07/19-10:51:22
Failed to load ODBC library symbol: /usr/local/lib/libtdsodbc.so(SQLDescribeParam)
Exiting hgolofn, rc=28500 at 2014/07/19-10:51:22
Exiting hgoinit, rc=28500 with error ptr FILE:hgoinit.c LINE:420 ID:Loading ODBC aray of function ptrs
hostmstr: 61480960: HOA After hoainit
RPC Calling nscontrol(0), rc=0
hostmstr: 61497344: RPC Before Exit Agent
hostmstr: 61513728: HOA Before hoaexit
Entered hgoexit
HS Gateway: NULL connection context at exit
Exiting hgoexit, rc=0 with error ptr FILE:hgoexit.c LINE:110 ID:Connection context
hostmstr: 61530112: HOA After hoaexit
hostmstr: 61546496: RPC After Exit Agent


тут вроде все красиво:

sun04.oracle> file "/usr/local/lib/libtdsodbc.so"
/usr/local/lib/libtdsodbc.so: ELF 64-bit MSB dynamic lib SPARCV9 Version 1, dynamically linked, not stripped, no debugging information available
sun04.oracle> ldd "/usr/local/lib/libtdsodbc.so"
libodbcinst.so.2 => /usr/local/lib/libodbcinst.so.2
libthread.so.1 => /lib/64/libthread.so.1
libnsl.so.1 => /lib/64/libnsl.so.1
libsocket.so.1 => /lib/64/libsocket.so.1
libc.so.1 => /lib/64/libc.so.1
libgcc_s.so.1 => /usr/local/lib/sparcv9//libgcc_s.so.1
libmp.so.2 => /lib/64/libmp.so.2
libmd.so.1 => /lib/64/libmd.so.1
libscf.so.1 => /lib/64/libscf.so.1
libdoor.so.1 => /lib/64/libdoor.so.1
libuutil.so.1 => /lib/64/libuutil.so.1
libgen.so.1 => /lib/64/libgen.so.1
libm.so.2 => /lib/64/libm.so.2
/lib/sparcv9/../libm/sparcv9/libm_hwcap1.so.2
/platform/sun4v/lib/sparcv9/libc_psr.so.1
/platform/sun4v/lib/sparcv9/libmd_psr.so.1
sun04.oracle>

sun04.oracle> file /u/app/oracle/product/11.2.0/db_1/bin/dg4odbc
/u/app/oracle/product/11.2.0/db_1/bin/dg4odbc: ELF 64-bit MSB executable SPARCV9 Version 1, dynamically linked, not stripped



перепробовал несколько версий freetds и unixODBC эффекта нет
Раньше уже встречал подобную проблему на linux там решалось установкой других вариантов ODBC. На солярке для подключения к mssql не знаю что можно еще использовать кроме freetds.

При таком варианте не силльно лучше получается

SQL> select count(*) from "Contact"@dl_terrasoft;
select count(*) from "Contact"@dl_terrasoft
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[unixODBC][Driver Manager]Data source name not found, and no default driver
specified {IM002}
ORA-02063: preceding 2 lines from DL_TERRASOFT


SQL>


Exiting hgogenconstr, rc=0 at 2014/07/19-13:09:17
Entered hgopoer at 2014/07/19-13:09:17
hgopoer, line 231: got native error 0 and sqlstate IM002; message follows...
[unixODBC][Driver Manager]Data source name not found, and no default driver specified {IM002}
Exiting hgopoer, rc=0 at 2014/07/19-13:09:17
hgocont, line 2754: calling SqlDriverConnect got sqlstate IM002
Exiting hgocont, rc=28500 at 2014/07/19-13:09:17 with error ptr FILE:hgocont.c LINE:2774 ID:Something other than invalid authorization
Exiting hgolgon, rc=28500 at 2014/07/19-13:09:17 with error ptr FILE:hgolgon.c LINE:801 ID:Calling hgocont

sun04.oracle> cat /u/app/oracle/product/11.2.0/db_1/hs/admin/initMyMSSQL.ora
HS_FDS_CONNECT_INFO=MyMSSQL
#HS_FDS_SHAREABLE_NAME = /usr/local/lib/libtdsodbc.so
HS_FDS_SHAREABLE_NAME = /usr/local/lib/libodbc.so
HS_FDS_TRACE_LEVEL=255
set ODBCINI = /etc/odbc.ini
set ODBCINSTINI = /etc/odbcinst.ini
#HS_LANGUAGE=AMERICAN_AMERICA.UTF8
HS_LANGUAGE=RUSSIAN_RUSIA.UTF8
#HS_FDS_SQLLEN_INTERPRETATION=32

ну да не находит DSN он именно с libodbc.so

трассировка ODBC вроде как включена только файл создается исключительно при пользовании isql, при запросах через dg4odbc в лог ничего не пишется.

поставил ODBCSYSINI, изменений никаких.

не понятно почему не находит в initMyMSSQL.ora четко же прописано
set ODBCINI=/etc/odbc.ini
set ODBCINSTINI=/etc/odbcinst.ini

и если ставить библиотеку
libtdsodbc.so
то вроде как находит

ну и еще до кучи в .profile
прописано
export ODBCSYSINI=/etc
export ODBCINI=/etc/odbc.ini

тут тоже добавил
sun04.oracle> cat /u/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
HS =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= TCP)(Host= 192.168.2.47 )(Port= 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROCHS))
)
SID_LIST_HS =
(SID_LIST =
(SID_DESC =
(PROGRAM=dg4odbc)
(SID_NAME = MyMSSQL)
(ORACLE_HOME = /u/app/oracle/product/11.2.0/db_1/)
(ENVS="LD_LIBRARY_PATH=/u/app/oracle/product/11.2.0/db_1/lib:/usr/lib:/usr/local/lib/sparcv9/:/usr/local/lib:/usr/openwin/lib:/usr/dt/lib,ODBCSYSINI=/etc,ODBCINI=/etc/odbc.ini,ODBCINSTINI=/etc/odbcinst.ini")
)
)
CONNECT_TIMEOUT_HS = 10
INBOUND_CONNECT_TIMEOUT_HS = 0
STARTUP_WAIT_TIME_HS = 0


эффекта никакого нет

SQL> select count(*) from "Contact"@dl_terrasoft;
select count(*) from "Contact"@dl_terrasoft
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[unixODBC][Driver Manager]Data source name not found, and no default driver
specified {IM002}
ORA-02063: preceding 2 lines from DL_TERRASOFT

с библиотекой тоде все нормально вроде
sun04.oracle> file /usr/local/lib/libodbc.so
/usr/local/lib/libodbc.so: ELF 64-bit MSB dynamic lib SPARCV9 Version 1, dynamically linked, not stripped, no debugging information available
sun04.oracle> ldd /usr/local/lib/libodbc.so
libthread.so.1 => /lib/64/libthread.so.1
libc.so.1 => /lib/64/libc.so.1
libgcc_s.so.1 => /usr/local/lib/sparcv9//libgcc_s.so.1
libm.so.2 => /lib/64/libm.so.2
/lib/sparcv9/../libm/sparcv9/libm_hwcap1.so.2
/platform/sun4v/lib/sparcv9/libc_psr.so.1

что то с strace ничего не выходит, файл лога не создается

-bash-3.2# ps -Af |grep hs
oracle 1845 1 0 Jul 19 ? 0:01 /u/app/oracle/product/11.2.0/db_1/bin/tnslsnr hs -inherit

-bash-3.2# strace -fae -o /tmp/dg4odbc.log -p 1845

что не так делаю?

sun04.oracle> uname -a
SunOS sun04 5.10 Generic_147440-19 sun4v sparc sun4v


Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production


-bash-3.2# ls -l /etc/odbc.ini
-rw-rw-r-- 1 root root 119 Jul 19 09:29 /etc/odbc.ini

в общем проблему решил
в солярке аналог strace
truss -fae -o /tmp/dg4odbc.log -p 1845

проблема была вот в чем:

19532/1: open("/etc//etc/odbcinst.ini", O_RDONLY) Err#2 ENOENT
19532/1: open("/etc//etc/odbcinst.ini", O_RDWR|O_CREAT|O_TRUNC, 0666) Err#2 ENOENT
19532/1: time() = 1406111184
19532/1: open("/etc//etc/odbcinst.ini", O_RDONLY) Err#2 ENOENT
19532/1: open("/etc//etc/odbcinst.ini", O_RDWR|O_CREAT|O_TRUNC, 0666) Err#2 ENOENT

Наткнулся еще на одну проблему:

SQL> select "Name" from "Contact"@dl_terrasoft limit 10;
select "Name" from "Contact"@dl_terrasoft limit 10
*
ERROR at line 1:
ORA-00933: SQL command not properly ended


SQL> select "Name" from "Contact"@dl_terrasoft;
ERROR:
ORA-28511: lost RPC connection to heterogeneous remote agent using
SID=ORA-28511: lost RPC connection to heterogeneous remote agent using
SID=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.2.47)(PORT=1522))(CONNECT_
DATA=(SID=MyMSSQL)(SERVICE_NAME=MyMSSQL)))
ORA-02063: preceding line from DL_TERRASOFT
Process ID: 1469
Session ID: 449 Serial number: 51117



no rows selected


при этом
SQL> select count(*) from "Contact"@dl_terrasoft;

COUNT(*)
----------
45


никаких фаерволов между серверами нет

sun04.oracle> cat /u/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
CONNECT_TIMEOUT_LISTENER = 10
INBOUND_CONNECT_TIMEOUT_LISTENER = 0
STARTUP_WAIT_TIME_LISTENER = 0

HS =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= TCP)(Host= 192.168.2.47 )(Port= 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROCHS))
)

SID_LIST_HS =
(SID_LIST =
(SID_DESC =
(PROGRAM=dg4odbc)
(SID_NAME = MyMSSQL)
(ORACLE_HOME = /u/app/oracle/product/11.2.0/db_1/)
(ENVS="LD_LIBRARY_PATH=/u/app/oracle/product/11.2.0/db_1/lib:/usr/lib:/usr/local/lib/sparcv9/:/usr/local/lib:/usr/openwin/lib:/usr/dt/lib,ODBCSYSINI=/etc,ODBCINI=/etc/odbc.ini,ODBCINSTINI=/etc/odbcinst.ini")
)
)

SAVE_CONFIG_ON_STOP_LISTENER = TRUE
TRACE_LEVEL_LISTENER = OFF
DIRECT_HANDOFF_TTC_LISTENER=OFF
USE_CKPFILE_LISTENER = OFF

может кто сталкивался с похожей проблемой?
трейс прикрепил в файле

извиняюсь конечно же:
CONNECT_TIMEOUT_HS = 10
INBOUND_CONNECT_TIMEOUT_HS = 0
STARTUP_WAIT_TIME_HS = 0

HS =
(ADDRESS_LIST =
(ADDRESS= (PROTOCOL= TCP)(Host= 192.168.2.47 )(Port= 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROCHS))
)

SID_LIST_HS =
(SID_LIST =
(SID_DESC =
(PROGRAM=dg4odbc)
(SID_NAME = MyMSSQL)
(ORACLE_HOME = /u/app/oracle/product/11.2.0/db_1/)
(ENVS="LD_LIBRARY_PATH=/u/app/oracle/product/11.2.0/db_1/lib:/usr/lib:/usr/local/lib/sparcv9/:/usr/local/lib:/usr/openwin/lib:/usr/dt/lib,ODBCSYSINI=/etc,ODBCI
NI=/etc/odbc.ini,ODBCINSTINI=/etc/odbcinst.ini")
)
)

SAVE_CONFIG_ON_STOP_HS = TRUE
TRACE_LEVEL_HS = OFF
DIRECT_HANDOFF_TTC_HS=OFF
USE_CKPFILE_HS = OFF


но это к сожалению никак не повлияло на результат

мне помогло
HS_FDS_SUPPORT_STATISTICS = FALSE

предыдущий параметр был ни при чем решилось все так:
HS_FDS_FETCH_ROWS=1