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

最新推荐文章于 2022-08-03 11:57:33 发布

ArduousBonze

最新推荐文章于 2022-08-03 11:57:33 发布

阅读量1.1k

点赞数

分类专栏： Oracle 文章标签： oracle sql server sqlserver migration list database

Oracle 专栏收录该内容

35 篇文章 0 订阅

订阅专栏

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