配置GATEWAY FOR SERVER 的过程如下:
1、环境:
Oracle Database 11
g
Release 2 (11.2)
Oracle Database 11
g
Release 2 (11.2) Gateways
(oracle db 和gateway 位于同一台服务器(linux redhat6.5))
SQL SERVER 2008 R2
(位于另一台服务器(window server 2008))
2、按matalink的步骤,安装完成gateway。
由于gateway和database 版本一致,所以安装的 ORACLE_HOME目录相同
3、配置相关文件initdg4msql.ora ,如下
[oracle@TieshengTest admin]$ cat initdg4msql.ora
# This is a customized agent init file that contains the HS parameters
# that are needed for the Database Gateway for Microsoft SQL Server
#
# HS init parameters
#
HS_FDS_CONNECT_INFO=[10.38.100.17]:1433//EBSData
# alternate connect format is hostname/serverinstance/databasename
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER