大多数配置与for odbc是一样的,区别在于gateway的配置。
第1步配置odbc没有,因为是直连sqlsever,不用odbc中转。
2.GateWay Server上initdg4oa.ora文件配置目录: E:\app\Administrator\product\11.2.0\dbhome_1\dg4msql\admin\
注意红色字体部分,分别为sqlserver ip/instance/database,实例是sql2005才提出的概念,在sql2000没有此说,所以空着。
在目标数据库中ufdata_800_2011中需安装recover的用户。
# 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=[192.168.1.4]//UFDATA_800_2011
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
目录:E:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN
注意红色字体部分,sid_name要与前文的initsid.ora的sid一致,本文是dg4oa。
可以看到蓝色部分,定义了for ms sqlserver的侦听配置,program是dg4msql,对应的后台进程是dg4msql.exe
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 138.20.1.2 )(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = dg4msqltemp)
(ORACLE_HOME = E:\app\Administrator\product\11.2.0\dbhome_1\)
(PROGRAM = dg4msql)
)
(SID_DESC =
(SID_NAME = dg4oa)
(ORACLE_HOME = E:\app\Administrator\product\11.2.0\dbhome_1\)
(PROGRAM = dg4odbc)
)
)
其他都一样,也需要建立link database。