oracle透明网关配置

《oracle透明网关配置》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、透明网关的安装和配置1、运行OracleInstallationProductsàUniversalInstaller进行透明网关组件的安装2、选择自定义3、选择要安装的透明网关4、系统提示配置5、查看C:oracleora92tg4msqladmin目录tg4msql├─admin--透明网关配置目录│tg4msql_tx.sql│├─bin--系统配置的东西├─nls--定义错误的消息│├─eng│└─jpn├─demo--提供了一些在SQLServer环境下得demo├─html--提供了一些SQLServer和Oracle的参考文档└─tra

2、ce--提供系统跟踪情况6、修改C:oracleora92tg4msqladmininittg4msql.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:oracleora92networkadminl

3、istener.ora，增加SID_LIST_LISTENER=(SID_LIST=(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

4、、重新启动侦听服务MicrosoftWindowsXP[版本5.1.2600](C)版权所有1985-2001MicrosoftCorp.C:DocumentsandSettingsAdministrator>lsnrctlstopLSNRCTLfor32-bitWindows:Version9.2.0.1.0-Productionon14-10月-200716:21:25Copyright(c)1991,2002,OracleCorporation.Allrightsreserved.正在连接到(DESCRIPTION=(ADDRESS=(PROT

5、OCOL=IPC)(KEY=EXTPROC0)))命令执行成功C:DocumentsandSettingsAdministrator>lsnrctlstartLSNRCTLfor32-bitWindows:Version9.2.0.1.0-Productionon14-10月-200716:21:38Copyright(c)1991,2002,OracleCorporation.Allrightsreserved.启动tnslsnr：请稍候...TNSLSNRfor32-bitWindows:Version9.2.0.1.0-Production系统

6、参数文件为C:oracleora92networkadminlistener.ora写入C:oracleora92networkloglistener.log的日志信息监听：(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=.pipeEXTPROC0ipc)))监听：(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=host)(PORT=1521)))正在连接到(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))LISTEN

7、ER的STATUS------------------------别名LISTENER版本TNSLSNRfor32-bitWindows:Version9.2.0.1.0-Production启动日期14-10月-200716:21:40正常运行时间0天0小时0分2秒跟踪级别off安全性OFFSNMPOFF监听器参数文件C:oracleora92networkadminlistener.ora监听器日志文件C:oracleora92networkloglistener.log监听端点概要...(DESCRIPTION=(ADDRESS=(PROTOC

8、OL=ipc)(PIPENAME=.pipeEXTPROC0ipc)))(DESCRIPTION=(ADDR