六步搞定 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觸發器心得體會