本文来自:Informatica技术超群(群号:0112443162 )【作者没找到 sorry。。。我转在这啦】
1-安装unixODBC
tar zxvf unixODBC-2.2.12.tar.gz(或者tar.tar)
cd unixODBC-2.2.12
./configure --prefix=/usr/local/unixODBC-2.2.12 --includedir=/usr/include --libdir=/usr/lib -bindir=/usr/bin --sysconfdir=/etc
make
make install
2-将mysql驱动拷贝到linux,放到lib或lib64目录
3-配置odbc,并使用isql命令测试odbc
/etc/odbc.ini
[myodbc_test]
Driver = /usr/lib64/libmyodbc5.so
Server = 192.168.2.1
User = root
Password = root
Port = 3306
database = fpyj_sms
显示以下内容表示测试连接成功:
[root@linux-vm001 ~]# isql myodbc_test
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL>
4-配置oracle监听
$TNS_ADMIN/listener.ora文件中添加
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = dg4odbc)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
(PROGRAM = dg4odbc)
)
)
5-配置oracle监听启动文件
$ORACLE_HOME/hs/admin/下添加文件 init名称.ora(如initdg4odbc.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 = myodbc_test
HS_FDS_TRACE_LEVEL = off
HS_FDS_SHAREABLE_NAME = /usr/lib64/libmyodbc5.so
#
# ODBC specific environment variables
#
set ODBCINI=/etc/odbc.ini
#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>
6-配置客户端连接tns
$TNS_ADMIN/tnsnames.ora文件中添加连接
dg4odbc =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
(CONNECT_DATA=(SID=dg4odbc))
(HS=OK)
)
7-建立db_link操作mysql
drop database link db4smsoto;
create database link db4smsoto
connect to "root"
identified by "y4yhl9tbz"
using 'dg4odbc';
或者省略第六步,直接建立db_link
drop database link db4smsoto;
create database link db4smsoto
connect to "root"
identified by "y4yhl9tbz"
using '(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))
(CONNECT_DATA=(SID=myodbc4smsoto))
(HS=OK)
)';
相关推荐
linux下oracle通过unixODBC连接MySQL linux下oracle通过unixODBC连接MySQL
依赖包:mysql-connector-odbc-5.3.6-1.el6.x86_64.rpm和unixODBC,前置条件:Oracle和MySQL字符集需要一致,否则Oracle查询出来的数据是乱码。
安装unixODBC Redhat 6上通过rpm包安装unixODBC rpm –ivh unixODBC-2.2.14-11.el6.x86_64.rpm rpm –ivh unixODBC-devel-2.2.14-11.el6.x86_64.rpm
本文档主要描述了Linux下python数据库驱动的安装和配置,用来实现在Linux平台下通过python访问MySQL、Oracle、SQL Server数据库。 其中包括以下几个软件的安装及配置: unixODBC FreeTDS pyodbc cx_Oracle 欢迎转载...
linux rpm包telnet_server+安装oracle包 libaio-devel-0.3.106-3.2.i386.rpm telnet-server-0.17-38.el5.i386.rpm sysstat-7.0.0-3.el5.i386.rpm sysstat-7.0.2-3.el5.i386.rpm unixODBC-2.2.11-7.1.i386.rpm ...
oracle依赖包 unixODBC-devel
unixODBC是一个来连接数据库的组件。 ODBC(Open Database Connectivity,开放数据库互连)提供了一种标准的API(应用程序编程接口)方法来访问DBMS
unixODBC软件包,用于linux下安装oracle数据库
binutils-2.27-43.base.el7.x86_64.rpm compat-libcap1-1.10-7.el7.x86_64.rpm compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm ...unixODBC-devel-2.3.1-14.el7.x86_64.rpm xterm-295-3.el7.x86_64.rpm
费了九牛二虎之力整理的在linux下安装oracle需要的包集合,详细信息如下:i386: compat-libstdc++-33-3.2.3-61.i386 elfutils-libelf-devel-0.137-3.el5.i386 elfutils-libelf-devel-static-0.137-3.el5.i386 gcc-...
包含Linux安装Oracle11时缺少的所有包:libaio-0.3.105,compat-libstdc++-33-3.2.3,libaio-devel-0.3.105,libgcc-3.4.6,libstdc++-3.4.6,unixODBC-2.2.11,unixODBC-devel-2.2.11,pdksh-5.2.14
ORACLE11GR2安装GRID依赖包unixODBC-2.2.11-7.1.i386.rpm,unixODBC-devel-2.2.11-7.1.i386.rpm
unixODBC数据 oracle 安装必须的软件包
Linux安装oracle11g时所需要的依赖包, 包括libaio-devel-0.3.106-3.2.i386.rpm,libaio-devel-0.3.106-3.2.x86_64.rpm,unixODBC-2.2.11-7.1.i386.rpm,unixODBC-2.2.11-7.1.x86_64.rpm,unixODBC-devel-2.2.11-7.1...
资源包含36个所需依赖包,如果服务器系统不是最小化安装,那这个包基本包含了所需依赖包, 执行 “rpm -ivh 需要安装的包名 --nodeps --force ” 强制免依赖安装,安装完后重新检查一次即可 ...unixODBC-devel
compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm、cpp-4.4.7-3.el6.x86_64.rpm、elfutils-libelf-devel-0.152-1.el6.x86_64.rpm、elfutils-libelf-...将rpm包放在新建指定目录下,然后执行rpm -e *.rpm --nodeps --force
包括: unixODBC-2.2.11-7.1.i386.rpm unixODBC-2.2.11-7.1.x86_64.rpm unixODBC-devel-2.2.11-7.1.x86_64.rpm unixODBC-devel-2.2.11-7.1.i386.rpm
内含以下8个linux安装oracle数据库时需要用到的安装包 libaio-devel-0.3.105-2.i386.rpm libaio-0.3.105-2.i386.rpm libgcc-3.4.6-3.i386.rpm libstdc++-3.4.6-3.1.i386.rpm glibc-2.3.4-2.54.i686.rpm compat-...
Linux、CentOS 64位系统安装Oracle11g依赖包及一键安装脚本,内含compat-libstdc++-33-3.2.3-61、libaio-0.3.105、libaio-devel-0.3.105、libstdc++、pdksh-5.2.14-36、unixODBC-2.2.11-10.el5.i386、unixODBC-devel...
基于ARM64架构linux系统的RabbitMQ离线安装依赖包unixodbc_2.3.1-4.1-arm64.deb