设置Oracle来同时访问多个SQL Server


如何在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_HOME\tg4msql\admin下新写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_HOME\network\admin 下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:\oracle\ora92) 

(SID_NAME = test9) 

) 

(SID_DESC= 

(SID_NAME=pubs) 

(ORACLE_HOME=d:\Oracle\Ora92) 

(PROGRAM=tg4msql) 

) 

(SID_DESC= 

(SID_NAME=northwind) 

(ORACLE_HOME=d:\Oracle\Ora92) 

(PROGRAM=tg4msql) 

) 

)

　

重启动这台做gateway的Windows机器上(IP:192.168.0.2)TNSListener服务(凡是按此步骤新增可访问的SQL Server数据库时，TNSListener服务都要重启动)。

  • 1
  • 2
  • 3
  • 下一页
【内容导航】
第1页：设置Oracle来同时访问多个SQL Server 第2页：设置Oracle来同时访问多个SQL Server
第3页：设置Oracle来同时访问多个SQL Server

相关内容