資源描述：
《oracle透明網(wǎng)關(guān)配置》由會(huì)員上傳分享，免費(fèi)在線閱讀，更多相關(guān)內(nèi)容在教育資源-天天文庫。
1、透明網(wǎng)關(guān)的安裝和配置1、運(yùn)行OracleInstallationProductsàUniversalInstaller進(jìn)行透明網(wǎng)關(guān)組件的安裝2、選擇自定義3、選擇要安裝的透明網(wǎng)關(guān)4、系統(tǒng)提示配置5、查看C:oracleora92tg4msqladmin目錄tg4msql├─admin--透明網(wǎng)關(guān)配置目錄│tg4msql_tx.sql│├─bin--系統(tǒng)配置的東西├─nls--定義錯(cuò)誤的消息│├─eng│└─jpn├─demo--提供了一些在SQLServer環(huán)境下得demo├─html--提供了一些SQLServer和Oracle的參考文檔└─trace--提供系統(tǒng)跟蹤情況6、修改C:or
2、acleora92tg4msqladmininittg4msql.ora#HS_FDS_CONNECT_INFO="SERVER=host;DATABASE=northwind"HS_FDS_CONNECT_INFO=host.northwind--hostname.databasenameHS_FDS_TRACE_LEVEL=DEBUGHS_FDS_RECOVERY_ACCOUNT=RECOVERHS_FDS_RECOVERY_PWD=RECOVER7、修改C:oracleora92networkadminlistener.ora，增加SID_LIST_LISTENER=(SID_LIS
3、T=(SID_DESC=(SID_NAME=tg4msql)(ORACLE_HOME=C:oracleora92)(PROGRAM=tg4msql)))8、修改C:oracleora92networkadminTnsname.ora，增加TG4MSQL=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=host)(PORT=1521)))(CONNECT_DATA=(SID=tg4msql))(HS=OK))9、重新啟動(dòng)偵聽服務(wù)MicrosoftWindowsXP[版本5.1.2600](C)版權(quán)所有1985-2001Micro
4、softCorp.C:DocumentsandSettingsAdministrator>lsnrctlstopLSNRCTLfor32-bitWindows:Version9.2.0.1.0-Productionon14-10月-200716:21:25Copyright(c)1991,2002,OracleCorporation.Allrightsreserved.正在連接到(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))命令執(zhí)行成功C:DocumentsandSettingsAdministrator>lsnrctlstartL
5、SNRCTLfor32-bitWindows:Version9.2.0.1.0-Productionon14-10月-200716:21:38Copyright(c)1991,2002,OracleCorporation.Allrightsreserved.啟動(dòng)tnslsnr：請(qǐng)稍候...TNSLSNRfor32-bitWindows:Version9.2.0.1.0-Production系統(tǒng)參數(shù)文件為C:oracleora92networkadminlistener.ora寫入C:oracleora92networkloglistener.log的日志信息監(jiān)聽：(DESCRIPTION=
6、(ADDRESS=(PROTOCOL=ipc)(PIPENAME=.pipeEXTPROC0ipc)))監(jiān)聽：(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=host)(PORT=1521)))正在連接到(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))LISTENER的STATUS------------------------別名LISTENER版本TNSLSNRfor32-bitWindows:Version9.2.0.1.0-Production啟動(dòng)日期14-10月-200716:21:40正
7、常運(yùn)行時(shí)間0天0小時(shí)0分2秒跟蹤級(jí)別off安全性O(shè)FFSNMPOFF監(jiān)聽器參數(shù)文件C:oracleora92networkadminlistener.ora監(jiān)聽器日志文件C:oracleora92networkloglistener.log監(jiān)聽端點(diǎn)概要...(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=.pipeEXTPROC0ipc)))(DESCRIPTION=(ADDR
