透明网管安装配子详(windows版本)V1.1.docxVIP

Gateways安装详解 文档修改记录 版本修订人修订说明1.1王维初稿 1.登录oracle官网下载gateways组件 2.解压并运行setup.exe: 3.等待几分钟进入安装页面: 4.单击下一步: 5.选着路径时一定要是本机Oracle安装路径,不能随意安装,如果随意安装后续配置起来非常麻烦,而且会导致dblink连接不成功: 6.选着需要安装连接的数据库 7.配置SQL Server: 8.概要: 9.等待安装完成 10.注册静态监听 (ORACLE_HOME/NETWORK/ADMIN/listener.ora) 复制: (SID_DESC = (SID_NAME = dg4msql) (ORACLE_HOME = F:\app\Administrator\product\11.2.0\dbhome_2) (PROGRAM = dg4msql) )11.修改链接SQL SERVER的配置 (ORACLE_HOME/dg4msql/admin/initdg4msql.ora) 复制: # This is a customized agent init file that contains the HS parameters # that are needed for the Database Gateway for Microsoft SQL Server # # HS init parameters # HS_FDS_CONNECT_INFO=192.168.3.73//GJSJDB HS_FDS_TRACE_LEVEL=OFF HS_FDS_RECOVERY_ACCOUNT=RECOVER HS_FDS_RECOVERY_PWD=RECOVER12.修改数据连接配置 (ORACLE_HOME/NETWORK/ADMIN/tnsnames.ora) 复制: dg4msql = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) (CONNECT_DATA = (SID = dg4msql) ) (HS = OK) )13.重启监听 cmd?lsnrctl?stop?start 14.创建DBLink create database link dblink名字 connect to sqlserver用户名 identified by sqlserver密码 using dg4msql‘15.测试连接 select * from dual@ dblink名字 select * from 某个表@ dblink名字16.测试成功返回结果