oracle透明网关配置.doc

透明网关的安装和配置1、运行Oracle Installation ProductsUniversal Installer进行透明网关组件的安装2、选择自定义3、选择要安装的透明网关4、系统提示配置5、查看C:oracleora92tg4msqladmin目录tg4msqladmin-透明网关配置目录tg4msql_tx.sqlbin-系统配置的东西nls-定义错误的消息engjpndemo-提供了一些在SQLServer环境下得demohtml-提供了一些SQLServer和Oracle的参考文档trace-提供系统跟踪情况6、修改C:oracleora92tg4msqladmininittg4msql.ora# HS_FDS_CONNECT_INFO=SERVER=host;DATABASE=northwindHS_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_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、重新启动侦听服务Microsoft Windows XP 版本5.1.2600(C)版权所有1985-2001 Microsoft Corp.C:Documents and SettingsAdministratorlsnrctl stopLSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 14-10月-2007 16:21:25Copyright (c) 1991, 2002, Oracle Corporation.All rights reserved.正在连接到(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)命令执行成功C:Documents and SettingsAdministratorlsnrctl startLSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 14-10月-2007 16:21:38Copyright (c) 1991, 2002, Oracle Corporation.All rights reserved.启动tnslsnr：请稍候.TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production系统参数文件为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)LISTENER的STATUS-别名LISTENER版本TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production启动日期14-10月-2007 16:21:40正常运行时间0天0小时0分2秒跟踪级别off安全性OFFSNMPOFF监听器参数文件C:oracleora92networkadminlistener.ora监听器日志文件C:oracleora92networkloglistener.log监听端点概要.(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=.pipeEXTPROC0ipc)(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=host)(PORT=1521)服务摘要.服务PLSExtProc包含1个例程。例程PLSExtProc,状态UNKNOWN,包含此服务的1个处理程序.服务tg4msql包含1个例程。例程tg4msql,状态UNKNOWN,包含此服务的1个处理程序.服务wbq包含1个例程。例程wbq,状态UNKNOWN,包含此服务的1个处理程序.命令执行成功C:Documents and SettingsAdministratorlsnrctl statusLSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 14-10月-2007 16:21:47Copyright (c) 1991, 2002, Oracle Corporation.All rights reserved.正在连接到(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)LISTENER的STATUS-别名LISTENER版本TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production启动日期14-10月-2007 16:21:40正常运行时间0天0小时0分9秒跟踪级别off安全性OFFSNMPOFF监听器参数文件C:oracleora92networkadminlistener.ora监听器日志文件C:oracleora92networkloglistener.log监听端点概要.(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=.pipeEXTPROC0ipc)(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=host)(PORT=1521)服务摘要.服务PLSExtProc包含1个例程。例程PLSExtProc,状态UNKNOWN,包含此服务的1个处理程序.服务tg4msql包含1个例程。例程tg4msql,状态UNKNOWN,包含此服务的1个处理程序.服务wbq包含1个例程。例程wbq,状态UNKNOWN,包含此服务的1个处理程序.命令执行成功C:Documents and SettingsAdministrator10、测试解析状态C:Documents and SettingsAdministratortnsping tg4msqlTNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 14-10月-2007 16:29:43Copyright (c) 1997 Oracle Corporation.All rights reserved.已使用的参数文件:C:oracleora92networkadminsqlnet.ora已使用TNSNAMES适配器来解析别名Attempting to contact (DESCRIPTION= (ADDRESS_LIST = (ADDRESS = (PROTOCOL=TCP)(HOST= host)(PORT=1521) (CONNECT_DATA= (SID=tg4msql) (HS=OK)OK（20毫秒）11、创建数据库链接CREATE PUBLIC DATABASE LINK MStest CONNECT TO “sa” IDENTIFIED BY “sa” USING tg4msql;12、察看数据库链接select * from sys.LINK$13、测试select * from CustomersMStest;透明网关配置的疑难问题配置过程遇到的异常情况：ORA-28500:连接ORACLE到非Oracle系统时返回此信息:Transparent gateway for MSSQLH006 The init parameter is not set. Please set it in init.ora file.ORA-02063:紧接着2 lines（源于MSTEST）解决过程，请检查以下参数Listener.oraPROGRAM必须为tg4msqlSID_NAME为gateway_sid，也就是说单个透明网关情况下一定是tg4msql，即inittg4msql.ora的名字部分去掉init即可，呵呵Tnsnames.oraSID为Listener.ora中的SID_NAMETNS的名称可以随便进行配置。至于以下这两个区别，我到现在也没搞明白LHS_FDS_CONNECT_INFO=SERVER=local;DATABASE=northwindHS_FDS_CONNECT_INFO=host.northwind多个透明网关的配置1、把inittg4msql.ora复制并修改名称为inittg4msql2.ora2、修改C:oracleora92tg4msqladmininittg4msql2.ora只修改第一行，服务器和数据库名即可HS_FDS_CONNECT_INFO=host.pubs-hostname.databasename3、修改C:oracleora92networkadminlistener.ora，增加如下注意SID_Name的变化SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(SID_NAME = tg4msql2)(ORACLE_HOME = C:ora