資源描述：
《通過透明網(wǎng)關(guān)使Linux上Oralcle鏈接SQL》由會員上傳分享，免費在線閱讀，更多相關(guān)內(nèi)容在教育資源-天天文庫。
1、方法一：注意：確保外部可以通過命令telnetIPPort連通.1.準備:一臺SQLServer主機OS:windows2003+SqlServer2000ip:10.86.16.27一臺透明網(wǎng)關(guān)主機OS:windows2003ip:10.86.184.250一臺Oracle10g數(shù)據(jù)庫OS:Linux+Oracle10gip:10.86.17.1002.在透明網(wǎng)關(guān)主機上安裝10201_gateways_win32.zip:運行Setup進行安裝,選擇oracletransparentgatewayformicrosoftsqlserver
2、.并完成安裝.在安裝目錄下D:oracleproduct10.2.0tg_1tg4msqladmin新建名稱為init.ora的文件,可以隨便起名.這里我起名為:inithowey.ora內(nèi)容如下:10.86.16.27為SQlServer主機IP.Smartit為SQLServer數(shù)據(jù)庫名稱:HS_FDS_CONNECT_INFO="SERVER=SERVER=10.86.16.27;DATABASE=SmartIT"HS_FDS_TRACE_LEVEL=OFFHS_FDS_RECOVERY_ACCOUNT
3、=RECOVERHS_FDS_RECOVERY_PWD=RECOVER3.在透明網(wǎng)關(guān)主機上配置listener.ora,所在位置如下:D:oracleproduct10.2.0tg_1NETWORKADMIN內(nèi)容如下:SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=PLSExtProc)(ORACLE_HOME=D:oracleproduct10.2.0tg_1)(PROGRAM=extproc))(SID_DESC=(SID_NAME=howey)(ORACLE_HOME
4、=D:oracleproduct10.2.0tg_1)(PROGRAM=tg4msql)))LISTENER=(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.86.184.250)(PORT=1521))(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))))4.啟動windows透明網(wǎng)關(guān)監(jiān)聽D:oracleproduct10.2.0tg_1BIN>lsnrctlstartLSNRCTLfor32-bitWindows:V
5、ersion10.2.0.1.0-Productionon31-3月-200915:50:14Copyright(c)1991,2005,Oracle.Allrightsreserved.正在啟動tnslsnr:請稍后...TNSLSNRfor32-bitWindows:Version10.2.0.1.0-Production系統(tǒng)參數(shù)檔案是D:oracleproduct10.2.0tg_1etworkadminlistener.ora日志信息寫入D:oracleproduct10.2.0tg_1etworklo
6、glistener.log監(jiān)聽之處:(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.86.184.250)(PORT=1521)))監(jiān)聽之處:(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.pipeEXTPROC0ipc)))連線至(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.86.184.250)(PORT=1521)))監(jiān)聽器的狀態(tài)------------------------別名LISTENE
7、R版本TNSLSNRfor32-bitWindows:Version10.2.0.1.0-Production啟動日期31-10月-201115:50:15正常運作時間0days0hr.0min.1sec追蹤層次off安管ON:LocalOSAuthenticationSNMPOFF監(jiān)聽器參數(shù)檔案D:oracleproduct10.2.0tg_1etworkadminlistener.ora監(jiān)聽器日志文件D:oracleproduct10.2.0tg_1etworkloglistener.log監(jiān)聽終止點摘要
8、...(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.86.184.250)(PORT=1521)))(DESCRIPTION=(ADD
