av一区二区在线观看_亚洲男人的天堂网站_日韩亚洲视频_在线成人免费_欧美日韩精品免费观看视频_久草视

您的位置:首頁技術文章
文章詳情頁

ORACLE9i連接SYBASE的透明網關的配置

瀏覽:3日期:2023-11-07 17:09:16
Oracle實現異種數據庫連接服務的技術叫做透明網關(Transparent Gateway)。目前ORACLE利用透明網關可以實現和SQL SERVER、SYBASE、DB2等多種主流數據庫的互聯。 現在通過oracle訪問sybase數據庫,把配置oracle9i TRANSPARENT GATEWAY FOR SYBASE的步驟寫成文檔,供需要的網友參考!配置TRANSPARENT GATEWAY FOR SYBASE步驟1.oracle所在服務器上安裝sybase client(或者在同一臺server上安裝oracle、sybase服務器)確保能夠訪問sybase數據庫2.安裝TRANSPARENT GATEWAY FOR SYBASE選件,要用自定義安裝。正確選擇sybase的安裝目錄3.選擇一個sid字符串預備賦給sybase數據庫。如:tg4sybs設置SYBASE的dll路徑到環境變量PATH(這一步很重要)4.修改初始化文件,默認的是:ORACLE_HOMEtg4sybsadmininittg4sybs.ora設置參數HS_FDS_CONNECT_INFO格式:HS_FDS_CONNECT_INFO= server_name. database_name[,INTERFACE= interface_file]server_name. database_name是大小寫敏感的。INTERFACE可選例子:如下$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$# This is a sample agent init file that contains the HS parameters that are# needed for the Transparent Gateway for Sybase## HS init parameters#HS_FDS_CONNECT_INFO=migration_serv.taxHS_FDS_TRACE_LEVEL=OFFHS_FDS_RECOVERY_ACCOUNT=RECOVERHS_FDS_RECOVERY_PWD=RECOVER## Environment variables required for Sybase#set SYBASE=d: ybase$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$上例中server_name是migration_servdatabase_name是tax5.配置oracle網絡服務的listener,配置文件是:listener.ora默認路徑:ORACLE_HOMEnetworkadmin加入如下SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME= gateway_sid)(ORACLE_HOME= oracle_home_Directory)(PROGRAM=tg4sybs)))gateway_sid就是3選擇的sid字符串oracle_home_directory是ORACLE_HOMEtg4sybs若是SYBASE是特定的。假如是其他數據庫,會不同。例子如下:$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ (SID_DESC= (SID_NAME=tg4sybs) (ORACLE_HOME = D:oracleora92) (PROGRAM=tg4sybs) )$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$6.停止監聽lsnrctl stop重新啟動監聽程序lsnrctl start7.配置oracle server的tnsnames.ora使其能夠訪問sybaseconnect_descriptor=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST= host_name)(PORT= port_number))(CONNECT_DATA=(SID= gateway_sid))(HS=OK))connect_descriptor是連接串,任取,一般為sybshost_name:oracle server的nameport_number:oracle監聽端口gateway_sid就是3選擇的sid字符串例子如下:$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$sybs= (DESCRIPTION= (ADDRESS_LIST = (ADDRESS=(PROTOCOL=TCP)(HOST= dw-server1)(PORT= 1521)) ) (CONNECT_DATA= (SID= tg4sybs) ) (HS=OK) )$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$8.建立database link如:CREATE; DATABASE LINK sybs; CONNECT TO sa IDENTIFIED BY prient; USING 'SBYS' ; 即可訪問sybase 數據庫。 需要注重的是,sybase數據庫的表名,字段名,假如是小寫的,那么在oracle里訪問的時候要加上雙引號''如:SQL〉select 'a' from 'b'@sybs;
標簽: Oracle 數據庫
主站蜘蛛池模板: 亚洲欧美国产精品 | 一区在线视频 | 国产精品黄色 | 亚洲精品福利视频 | 欧美视频在线观看一区 | 欧美日本一区 | 日韩黄色在线视频 | 久久久精品一区二区三区 | 久久久久久久久久久国产 | 色综合久久天天综合网 | 午夜影片 | 精品国产一区二区三 | 国产一二三 | 成人免费毛片嘿嘿连载视频 | 国产一区中文字幕 | 五月婷婷色综合 | 亚洲国产成人在线 | 国产精品99久久久久久久久久久久 | 四虎8848精品成人免费网站 | 激情视频小说 | 一级黄色网 | 婷婷五月在线视频 | 精品欧美一区二区精品久久 | 日本高清www | 日韩在线视频免费观看 | 91福利网 | 欧美一区二区在线播放 | 国产激情网站 | 黄色片毛片| 日韩欧美在线观看视频 | 手机av在线免费观看 | 99视频| 亚洲一区国产精品 | 亚洲精品1 | 欧美精品在线播放 | 91少妇丨porny丨 | 国产蜜臀av| 欧美精品日韩少妇 | 精品视频网站 | 国产日韩精品一区二区 | 日韩亚洲在线 |