3同行回答
安装好gateway之后再$ORACLE_BASE\tg_1\network\admin 这个目录就变成了新的 网络监听设置的目录啦，原来在$ORACLE_HOME/network/admin中的配置都要弄过来哦，还要设置 init$SID.ora文件
里面有 # This is a sample agent init file that contains the HS parameters that are
# needed for the Database Gateway for ODBC
#
# HS init parameters
#
#HS_FDS_CONNECT_INFO =
#HS_FDS_TRACE_LEVEL =
#
# Environment variables required for the non-Oracle system
#
#set=
HS_FDS_CONNECT_INFO = xxxx
HS_FDS_TRACE_LEVEL = 255收起
里面有 # This is a sample agent init file that contains the HS parameters that are
# needed for the Database Gateway for ODBC
#
# HS init parameters
#
#HS_FDS_CONNECT_INFO =
#HS_FDS_TRACE_LEVEL =
#
# Environment variables required for the non-Oracle system
#
#set
HS_FDS_CONNECT_INFO = xxxx
HS_FDS_TRACE_LEVEL = 255收起
浏览865
下面是偶之前的一个case
xxxx =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =yy.yyy.yyy.yyy)(PORT = 1621))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = xxxx)
)
(HS=OK)
)
create public database link dl_xxxx
connect to test identified by test
using 'xxxx';
select * from t1@dl_xxx;
select * from t2@dl_xxx;
ORA-28545: 连接代理时 Net8 诊断到错误 NCRO:无法执行 RSLV 连接
ORA-02063: 紧接着2 lines（源于DL_xxxx）
E:\product\11.2.0\tg_1\NETWORK\ADMIN\listener.ora
ORA-28500: 连接 ORACLE 到非 Oracle 系统时返回此信息:[Microsoft][ODBC 驱动程序管理器] 在指定的 DSN中，驱动程序和应用程序之间的体系结构不匹配 {IM014}
ORA-02063: 紧接着2 lines（源于xxxx）
oracle ,sqlserver
两边都需要32bit 或者 64 bit软件收起
xxxx =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =yy.yyy.yyy.yyy)(PORT = 1621))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = xxxx)
)
(HS=OK)
)
create public database link dl_xxxx
connect to test identified by test
using 'xxxx';
select * from t1@dl_xxx;
select * from t2@dl_xxx;
ORA-28545: 连接代理时 Net8 诊断到错误 NCRO:无法执行 RSLV 连接
ORA-02063: 紧接着2 lines（源于DL_xxxx）
E:\product\11.2.0\tg_1\NETWORK\ADMIN\listener.ora
ORA-28500: 连接 ORACLE 到非 Oracle 系统时返回此信息:[Microsoft][ODBC 驱动程序管理器] 在指定的 DSN中，驱动程序和应用程序之间的体系结构不匹配 {IM014}
ORA-02063: 紧接着2 lines（源于xxxx）
oracle ,sqlserver
两边都需要32bit 或者 64 bit软件收起
浏览1029