oracle 透明网关环境的建立

                       Oracle 透明网关环境的建立                                 兰伟 2007-0-082 1、安装oracle 的transparent gateway 透明网关。
    安装ORACLE 选择自定义安装，然后再选择安装透明网关，再进去选择安装FOR SQLSERVER 的组件。
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 说明建立的用户名，密码要是 SQLSERVER 的用户名和密码
create PUBLIC DATABASE LINK oratoSql
    CONNECT TO sa IDENTIFIED BY "lanwei"
    USING 'TG4MSQL' ; 6、测试数据的是否正常检索。
Trackback: http://tb.blog.csdn.net/TrackBack.ASPx?PostId=1518385