在Oracle里设置访问多个SQL Server

　　initpubs.ora内容如下:

　　hs_fds_connect_info="server=sqlserver_hostnmae;database=pubs"

　　hs_db_name=pubs

　　hs_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))

　　 )

　　 )

　　 )