【A】连接sqlserver
先安装:Oracle Transparent Gateway for Microsoft SQL Server 9.2.0.1.0
安装完毕后会在.. oracle/ora92目录下新增一个tg4msql目录,然后编辑
。。。oracle/ora92/tg4msql/admin目录里面的inittg4msql.ora文件:
# 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.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.ORA Network Configuration File: E:/oracle/ora92/network/admin/listener.ora
# Generated by oracle configuration tools.
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服务;
先安装:Oracle Transparent Gateway for Microsoft SQL Server 9.2.0.1.0
安装完毕后会在.. oracle/ora92目录下新增一个tg4msql目录,然后编辑
。。。oracle/ora92/tg4msql/admin目录里面的inittg4msql.ora文件:
# 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.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.ORA Network Configuration File: E:/oracle/ora92/network/admin/listener.ora
# Generated by oracle configuration tools.
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服务;