oracle怎么连接mysql（mysql oracle数据库怎么对接）

本文目录

• mysql oracle数据库怎么对接
• 如何在oracle上建dblink连接远程mysql数据库
• mysql怎么连接oracle
• oracle sql developer怎么连接mysql

mysql oracle数据库怎么对接

Mysql连接oracle数据库PrintPreviewDialog pPDlg; exec_prefix=’NONE’PACKAGE=’libevent’PACKAGE_BUGREPORT=’’PACKAGE_NAME=’’PACKAGE_STRING=’’PACKAGE_TARNAME=’’PACKAGE_URL=’’PACKAGE_VERSION=’’PATH_SEPARATOR=’:’

如何在oracle上建dblink连接远程mysql数据库

oracle：系统redhat 5.5 数据库：11.2.0.1mysql：系统centos6.3 数据库：5.6.211.先装 mysql-connector-odbc和unixODBC# rpm -qa | grep mysqlmysql-5.0.77-4.el5_4.2mysql-5.0.77-4.el5_4.2mysql-connector-odbc-5.1.13-1.rhel5# rpm -qa | grep ODBCunixODBC-devel-2.2.11-7.1unixODBC-2.2.11-7.1unixODBC-devel-2.2.11-7.1unixODBC-2.2.11-7.12.配置 /etc/odbc.iniDriver = /usr/lib64/libmyodbc5.soDescription = MySQL ODBC 5.1 Driver DSNSERVER = 192.1.1.200PORT = 3306USER = biPassword = 123456Database = chanpinOPTION = 3SOCKET =charset = utf83.配置/etc/odbcinst.iniDescription = ODBC for MySQLDriver = /usr/lib64/libmyodbc5.soSetup = /usr/lib64/libodbcmyS.soFileUsage = 14.测试连接# isql myodbc3 -v+---------------------------------------+| Connected! || || sql-statement || help || quit || |+---------------------------------------+SQL》5.配置oracle环境变量export ORACLE_BASE=/u01/app/oracleexport GRID_HOME=/u01/gridexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1export ORACLE_SID=rac1export BASE_PATH=/usr/sbin:$PATHexport PATH=$ORACLE_HOME/bin:$BASE_PATH:/usr/binexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib:$ORACLE_HOME/hs/lib:/usr/lib64export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibODBCINI=/etc/odbc.ini; export ODBCINIODBCSYSINI=/etc; export ODBCSYSINIODBCINSTINI=/etc/odbc.iniexport ODBCINSTINI6.配置监听listener.ora:LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.1.1.100)(PORT = 1522)) ) )SID_LIST_LISTENER= (SID_LIST= (SID_DESC= (PROGRAM = dg4odbc) (SID_NAME= myodbc3) (ORACLE_HOME= /u01/app/oracle/product/11.2.0/db_1) (ENVS=LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/db_1/lib:/lib:/usr/lib:/usr/local/lib:/u01/app/oracle/product/11.2.0/db_1/hs/lib:/usr/lib64) ) ) tnsname.ora:myodbc3= (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.1.1.100)(PORT = 1522)) (CONNECT_DATA = (SID = myodbc3)) (HS = OK) )7.配置odbc监听路径：$ORACLE_HOME/hs/admin注意：名字要跟odbc配置的名字一样 我这里是myodbc3$ cat initmyodbc3.oraHS_FDS_CONNECT_INFO = myodbc3HS_FDS_TRACE_LEVEL = ONHS_FDS_TRACE_FILE_NAME = odbc_test.logHS_FDS_TRACE_LEVEL = 4HS_FDS_SHAREABLE_NAME = /usr/lib64/libodbc.soHS_FDS_SUPPORT_STATISCTICS = FALSEHS_LANGUAGE = AMERICAN_AMERICA.WE8ISO8859P1HS_FDS_SQLLEN_INTERPRETATION=32set ODBCINI = /etc/odbc.ini8.测试下监听$ tnsping myodbc3TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 25-NOV-2014 03:02:16Copyright (c) 1997, 2009, Oracle. All rights reserved.Used parameter files:Used TNSNAMES adapter to resolve the aliasAttempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.1.1.100)(PORT = 1522)) (CONNECT_DATA = (SID = myodbc3)) (HS = OK))OK (0 msec)9.创建dblinkSQL》create public database link myodbc connect to "bi" identified by "123456" using’myodbc3’;SQL》 select count(*) from "t_user"@myodbc; COUNT(*)---------- 53980

mysql怎么连接oracle

通过配置本地数据库的tns配置文件实现：去oracle安装目录下oracle\product\10.2.0\db_2\NETWORK\ADMIN\ 找到tnsnames.ora，用记事本打开，里边有远程数据库的tns连接配置串如下ORCL23 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.23)(PORT = 1521)) ) (CONNECT_DATA = (SID = ORCL) ) )添加好ip、端口和目标数据库的实例名(SID)，然后确保tns名称(ORCL23)在整个文档中唯一，保存后打开数据库连接工具，输入远程数据库上的用户名密码，选择数据库对象为你配置的连接名就可以了。还有一种方法就是配置Database Link，详情参考下帖***隐藏网址***

oracle sql developer怎么连接mysql

　　1:　　Oracle SQL Developer 是非常强悍的开源的SQL开发工具, 可惜最近我才开始研究它, 刚安装好的Oracle SQL Developer 是不支持连接MySQL的, 需要从MySQL官网下载JDBC驱动forMySQL.　　Oracle SQL Developer官网下载地址:***隐藏网址******隐藏网址***　　2:　　右击表，然后打开表，数据tab就可以数据。　　过滤器中输入: id=1 and valid_flag=1 回车之后就可以过滤数据了