六步搞定 Oracle 透明网关环境的建立

2024-08-29 13:51:29

字体：大中小

来源：转载

供稿：网友

本文从六步来帮你轻松搞定 Oracle透明网关环境的建立。 1、安装oracle 的transparent gateway 透明网关。安装Oracle选择自定义安装，然后再选择安装透明网关，再进去选择安装FOR SQL Server的组件。 2、修改 oraclehome/ora92/tgsmsql/admin/inittg4msql.orq 文件:

HS_FDS_CONNECT_INFO="SERVER=YIRONG-NO1;DATABASE=jsoct"HS_FDS_TRACE_LEVEL=OFFHS_FDS_RECOVERY_ACCOUNT=RECOVERHS_FDS_RECOVERY_PWD=RECOVER

说明可以通过Oracle工具中的migration WorkBench 进行配置。（过程中需要配置ODBC） 3、建立监听修改oracle 的 oraclehome/ora92/network/admin/listener.ora 文件。

# LISTENER.ORA Network Configuration File: F:/oracle/ora92/network/admin/listener.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:/oracle/ora92) (PROGRAM = extproc))(SID_DESC = (GLOBAL_DBNAME = ora9i2) (ORACLE_HOME = F:/oracle/ora92) (SID_NAME = ora9i2))#连接 sqlserver(SID_DESC = (GLOBAL_DBNAME = tg4msql) (PROGRAM = tg4msql) (SID_NAME = tg4msql) (ORACLE_HOME = F:/oracle/ora92) ) )

4、修改TNS:

TG4MSQL = (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SID=tg4msql))(HS=) )

5、创建DBLINK说明建立的用户名，密码要是SQL Server的用户名和密码:

create PUBLIC DATABASE LINK oratoSql CONNECT TO sa IDENTIFIED BY "lanwei"USING 'TG4MSQL' ;

6、测试数据的是否正常检索。

上一篇：Oracle 数据库集中复制方法逐步精细

下一篇：推荐：学习使用 Oracle触发器心得体会