1、安装oracle 的transparent gateway 透明网关。
安装oracle 选择自定义安装， 然后再选择 安装透明网关，再进去选择 安装for sqlserver 的组件。
2、修改 oraclehomeora92tgsmsqladmininittg4msql.orq 文件
hs_fds_connect_info=server=yirong-no1;database=jsoct
hs_fds_trace_level=off
hs_fds_recovery_account=recover
hs_fds_recovery_pwd=recover
说明 可以通过 oracle 工具中的migration workbench 进行配置。（过程中需要配置odbc）
3、建立监听 修改oracle 的 oraclehomeora92networkadminlistener.ora 文件。
# listener.ora network configuration file: f:oracleora92networkadminlistener.ora
# generated by oracle configuration tools.
listener =
(description_list =
(description =
(address_list =
(address = (protocol = ipc)(key = extproc0))
)
(address_list =
(address = (protocol = tcp)(host = yirong-no1)(port = 1521))
)
)
)
sid_list_listener =
(sid_list =
(sid_desc =
(sid_name = plsextproc)
(oracle_home = f:oracleora92)
(program = extproc)
)
(sid_desc =
(global_dbname = ora9i2)
(oracle_home = f:oracleora92)
(sid_name = ora9i2)
)
#连接 sqlserver
(sid_desc =
(global_dbname = tg4msql)
(program = tg4msql)
(sid_name = tg4msql)
(oracle_home = f:oracleora92)
)
)
4、修改tns
tg4msql =
(description=
(address=(protocol=tcp)(host=localhost)(port=1521))
(connect_data=(sid=tg4msql))
(hs=)
)
5、创建dblink 说明建立的 用户名，密码要是 sqlserver 的用户名和密码
create public database link oratosql
connect to sa identified by lanwei
using 'tg4msql' ;
6、测试数据的是否正常检索。
，