我想实现从oracle(主机ip:10.0.0.1)访问sql server(主机ip:10.0.0.2)库中的表,设计了透明网关,详情如下:
1.我在oracle主机上(10.0.0.1)安装了oracle的针对sql server的透明网关组件,得到一个inittg4msql.ora文件,根据需要修改其内容(我需要访问tempdb库):
# This is a sample agent init file that contains the HS parameters that are
# needed for the Transparent Gateway for SQL Server
#
# HS init parameters
#
HS_FDS_CONNECT_INFO="SERVER=10.0.0.2;DATABASE=tempdb"
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
2.我增加了oracle主机的listener.ora文件,如下:
SID_LIST_LISTENER =
(SID_LIST =