如何在Oracle里设置访问多个SQL Server数据库？假设我们要在Oracle里同时能访问SQL Server里默认的pubs和Northwind两个数据库。
1、在安装了Oracle9i Standard Edition或者Oracle9i Enterprise Edition的windows上(IP:192.168.0.2), 产品要选了透明网关(Oracle Transparent Gateway)里访问Microsoft SQL Server数据库：ORACLE9I_HOMEtg4msqladmin下新写initpubs.ora和initnorthwind.ora配置文件。
initpubs.ora内容如下:
HS_FDS_CONNECT_INFO="SERVER=SQLSERVER_HOSTNMAE;DATABASE=pubs"
HS_DB_NAME=pubsHS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER |
initnorthwind.ora内容如下:
HS_FDS_CONNECT_INFO="SERVER=sqlserver_hostname;DATABASE=Northwind"
HS_DB_NAME=Northwind
HS_FDS_TRACE_LEVEL=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER |
$ORACLE9I_HOMEnetworkadmin 下listener.ora内容如下:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = test9)
(ORACLE_HOME = d:oracleora92)
(SID_NAME = test9)
)
(SID_DESC=
(SID_NAME=pubs)
(ORACLE_HOME=d:OracleOra92)
(PROGRAM=tg4msql)
)
(SID_DESC=
(SID_NAME=northwind)
(ORACLE_HOME=d:OracleOra92)
(PROGRAM=tg4msql)
)
) |
重启动这台做gateway的Windows机器上(IP:192.168.0.2)TNSListener服务(凡是按此步骤新增可访问的SQL Server数据库时，TNSListener服务都要重启动)。
