如何在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服务都要重启动)。

您可能感兴趣的文章: