通过透明网关使Linux上Oralcle链接SQL

《通过透明网关使Linux上Oralcle链接SQL》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、方法一：注意：确保外部可以通过命令telnetIPPort连通.1.准备:一台SQLServer主机OS:windows2003+SqlServer2000ip:10.86.16.27一台透明网关主机OS:windows2003ip:10.86.184.250一台Oracle10g数据库OS:Linux+Oracle10gip:10.86.17.1002.在透明网关主机上安装10201_gateways_win32.zip:运行Setup进行安装,选择oracletransparentgatewayformicrosoftsqlserver

2、.并完成安装.在安装目录下D:oracleproduct10.2.0tg_1tg4msqladmin新建名称为init.ora的文件,可以随便起名.这里我起名为:inithowey.ora内容如下:10.86.16.27为SQlServer主机IP.Smartit为SQLServer数据库名称: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.在透明网关主机上配置listener.ora,所在位置如下:D:oracleproduct10.2.0tg_1NETWORKADMIN内容如下: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透明网关监听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系统参数档案是D:oracleproduct10.2.0tg_1etworkadminlistener.ora日志信息写入D:oracleproduct10.2.0tg_1etworklo

6、glistener.log监听之处:(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.86.184.250)(PORT=1521)))监听之处:(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.pipeEXTPROC0ipc)))连线至(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.86.184.250)(PORT=1521)))监听器的状态------------------------别名LISTENE

7、R版本TNSLSNRfor32-bitWindows:Version10.2.0.1.0-Production启动日期31-10月-201115:50:15正常运作时间0days0hr.0min.1sec追踪层次off安管ON:LocalOSAuthenticationSNMPOFF监听器参数档案D:oracleproduct10.2.0tg_1etworkadminlistener.ora监听器日志文件D:oracleproduct10.2.0tg_1etworkloglistener.log监听终止点摘要

8、...(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.86.184.250)(PORT=1521)))(DESCRIPTION=(ADD