win10系统oracle访问mysql

来源：互联网发布：网页编程基础编辑：程序博客网时间：2024/06/07 13:50

系统：windows 10
oracle数据库：11.2.0
mysql数据库：5.5

一、准备

mysql新建数据库oreport，新建表otest，随机插入数据。

二、驱动

下载安装mysql的odbc驱动

三、配置odbc数据源

控制面板 ->管理工具 ->odbc数据源(64位) ->系统DSN ->添加 ->MySQL ODBC * Driver(根据安装的驱动选择)
根据提示配置，如图：
这里写图片描述

Data Source Name自己起名字，注意后边要用
其余都为mysql相关配置，Database选择准备工作中创建的oreport数据库
配置完成点击Test，弹出Connection Successful对话框，完成配置

四、配置oracle

1. init+[sid].ora

在%ORACLE_HOME%/hs/admin/ 路径下添加init+[sid].ora文件，此处为initoreport.ora，内容：

# This is a sample agent init file that contains the HS parameters that are# needed for the Database Gateway for ODBC## HS init parameters#HS_FDS_CONNECT_INFO = mysqllinkHS_FDS_TRACE_LEVEL = debug## Environment variables required for the non-Oracle system##set <envvar>=<value>

HS_FDS_CONNECT_INFO值为上一步骤中Data Source Name

2. listener.ora

在%ORACLE_HOME%/NETWORK/ADMIN/路径下修改listener.ora

# listener.ora Network Configuration File: E:\oracle\product\11.2.0\dbhome_1\network\admin\listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (SID_NAME = CLRExtProc)      (ORACLE_HOME = E:\oracle\product\11.2.0\dbhome_1)      (PROGRAM = extproc)      (ENVS = "EXTPROC_DLLS=ONLY:E:\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")    )    (SID_DESC =      (SID_NAME = oreport)      (ORACLE_HOME = E:\oracle\product\11.2.0\dbhome_1)      (PROGRAM = dg4odbc)    )  )LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))    )  )ADR_BASE_LISTENER = E:\oracle

3. tnsnames.ora

在%ORACLE_HOME%/NETWORK/ADMIN/路径下修改tnsnames.ora
末尾追加

OREPORT =  (DESCRIPTION =    (ADDRESS_LIST =        (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT= 1521))    )    (CONNECT_DATA =        (SID = oreport)    )    (HS=OK) )

四、测试

create database link oreport connect to "root" identified by "123456" using 'OREPORT';select * from otest@oreport;

0 0