---

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"
[color=#FFFFFF'][/color]

　　HS_DB_NAME=pubs
　　HS_FDS_TRACE_LEVEL=OFF
　　HS_FDS_RECOVERY_ACCOUNT=RECOVER
　　HS_FDS_RECOVERY_PWD=RECOVER
[color=#FFFFFF'][/color]

　　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 =
[color=#FFFFFF'][/color]

　　 (DESCRIPTION_LIST =
　　 (DESCRIPTION =
　　 (ADDRESS_LIST =
　　 (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521))
　　 )
　　 )
　　 )