在tdg4msql\admin新建一个init+[sid].ora文件,命名为initetest.ora,实例名为test(数据库实例名)。编辑文件内容如下:
HS_FDS_CONNECT_INFO=10.6.41.39//master
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
其中172.19.1.36为sqlserver所在的host,master为sqlserver databasename。
HS_FDS_CONNECT_INFO=10.6.41.39//master需要默认端口是1433
HS_FDS_CONNECT_INFO=kevingypeng-PC1:1433//master
HS_FDS_CONNECT_INFO=10.6.41.39:1433//master
HS_FDS_CONNECT_INFO=KEVINGYPENG-PC1:1433//master
HS_FDS_CONNECT_INFO=[KEVINGYPENG-PC1]:1433//master
HS_FDS_CONNECT_INFO=[10.6.41.39]:1433//master
LISTENER=
(DESCRIPTION_LIST=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=http://www.doczj.com/doc/78c6ea6e7e21af45b307a88d.html)(PORT= 1522))
(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1522))
)
)
安装完gateway后,会自动建立一个11g的listener。編輯內容如下(文件位置在安装GATEWARY目录下的netwrok/admin下例如F:\app\kevingypeng\NETWORK\ADMIN)SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=PLSExtProc)
(ORACLE_HOME=F:\app\kevingypeng)
(PROGRAM=extproc)
)
(SID_DESC=
(SID_NAME=test)---对应透明网关安装目录tg4msql\admin下的inittest.ora文件名。
(ORACLE_HOME=F:\app\kevingypeng)
(PROGRAM=dg4msql)
)