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

来源：互联网发布：一个巴掌拍不响知乎编辑：程序博客网时间：2024/06/06 08:39

本文从六步来帮你轻松搞定 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=OFF
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_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、测试数据的是否正常检索。