oracle 连接 sqlserver
【A】连接sqlserver
先安装:OracleTransparentGatewayforMicrosoftSQLServer9.2.0.1.0
安装完毕后会在..oracle\ora92目录下新增一个tg4msql目录,然后编辑
。。。oracle\ora92\tg4msql\admin目录里面的inittg4msql.ora文件:
#ThisisasampleagentinitfilethatcontainstheHSparametersthatare
#neededfortheTransparentGatewayforSQLServer
#
#HSinitparameters
#
HS_FDS_CONNECT_INFO="SERVER=10.120.10.139;DATABASE=数据库名"
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
然后更改。。:\oracle\ora92\network\admin目录下的listener.ora文件
#LISTENER.ORANetworkConfigurationFile:E:\oracle\ora92\network\admin\listener.ora
#Generatedbyoracleconfigurationtools.
LISTENER=
(DESCRIPTION_LIST=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))
)
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=drpxy01)(PORT=1521))
)
)
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(ORACLE_HOME=E:\oracle\ora92)
(SID_NAME=tg4msql)
(PROGRAM=tg4msql)
)
.................
然后更改。。\oracle\ora92\network\admin目录下的tnsnames.ora文件,增加一个服务名
SQLSERVER.TEPCO.NCPG=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=10.120.6.1)(PORT=1521))
)
(CONNECT_DATA=
(SID=tg4msql)
)
(HS=OK)
)
然后重新启动listener服务;
先安装:OracleTransparentGatewayforMicrosoftSQLServer9.2.0.1.0
安装完毕后会在..oracle\ora92目录下新增一个tg4msql目录,然后编辑
。。。oracle\ora92\tg4msql\admin目录里面的inittg4msql.ora文件:
#ThisisasampleagentinitfilethatcontainstheHSparametersthatare
#neededfortheTransparentGatewayforSQLServer
#
#HSinitparameters
#
HS_FDS_CONNECT_INFO="SERVER=10.120.10.139;DATABASE=数据库名"
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
然后更改。。:\oracle\ora92\network\admin目录下的listener.ora文件
#LISTENER.ORANetworkConfigurationFile:E:\oracle\ora92\network\admin\listener.ora
#Generatedbyoracleconfigurationtools.
LISTENER=
(DESCRIPTION_LIST=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))
)
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=drpxy01)(PORT=1521))
)
)
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(ORACLE_HOME=E:\oracle\ora92)
(SID_NAME=tg4msql)
(PROGRAM=tg4msql)
)
.................
然后更改。。\oracle\ora92\network\admin目录下的tnsnames.ora文件,增加一个服务名
SQLSERVER.TEPCO.NCPG=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=10.120.6.1)(PORT=1521))
)
(CONNECT_DATA=
(SID=tg4msql)
)
(HS=OK)
)
然后重新启动listener服务;