oracle odbc mysql_通过odbc配置oracle到mysql的连接

最新推荐文章于 2023-03-24 18:01:32 发布

AIAlchemist

最新推荐文章于 2023-03-24 18:01:32 发布

阅读量194

点赞数

文章标签： oracle odbc mysql

版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

本文链接：https://blog.csdn.net/weixin_35751412/article/details/113207806

版权

**************public信息**************SQL> select * fromdba_db_links;

OWNER DB_LINK USERNAME HOST CREATED------------------------------ ---------------------------------------- ------------------------------ -------------------------------------------------- ------------PUBLIC TOMOT CRM (DESCRIPTION= 08-AUG-17(ADDRESS= (PROTOCOL = TCP)(HOST = 10.16.245.3

2)(PORT = 1521))

(CONNECT_DATA=(SERVER=DEDICATED)

(SERVICE_NAME=orcl)

)

)

PUBLIC GWTOCRMHIS pifuser toCrmHis01-AUG-17PUBLIC LINK2TOUGU syn TOTOUGU11-OCT-18OWNER DB_LINK USERNAME HOST CREATED------------------------------ ---------------------------------------- ------------------------------ -------------------------------------------------- ------------PUBLIC GWTOOTC pifuser toOtc30-JUN-17PUBLIC GWTOKCBL pifuser toKCBL30-JUN-17PUBLIC GZ20 GZREADER (DESCRIPTION= 30-JUN-17(ADDRESS= (PROTOCOL = TCP)(HOST = 10.17.29.67)(PORT= 1521))

(CONNECT_DATA=(SERVER=DEDICATED)

(SERVICE_NAME=guzhibk)

)

)

OWNER DB_LINK USERNAME HOST CREATED------------------------------ ---------------------------------------- ------------------------------ -------------------------------------------------- ------------PUBLIC GWTOCOS pifuser toCos30-JUN-17PUBLIC GWTOCCRM pifuser toCcrm30-JUN-17PUBLIC GWTOCRMOF pifuser toCrmof30-JUN-17PUBLIC GWTOCRM pifuser toCrm30-JUN-17PUBLIC GWTOSJZD pifuser dg4msql30-JUN-17

/oracle/app/oracle/product/11.2.0.4/tg_1/network/admin/oracle/app/oracle/product/11.2.0.4/tg_1/dg4msql/admin

createpublic database link KBSSACCT connect to "sa" IDENTIFIED by "bushisa" using 'dg4msql';/oracle/app/oracle/product/11.2.0.4/tg_1/network/admin/oracle/app/oracle/product/11.2.0.4/tg_1/dg4msql/admin

TOTOUGU=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS= (PROTOCOL = TCP)(HOST = 10.16.232.220)(PORT = 1521))

)

(CONNECT_DATA=(SERVICE_NAME=totougu)

)

(HS=OK)

)

SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(SID_NAME=dg4msql)

(ORACLE_HOME=/oracle/app/oracle/product/11.2.0.4/tg_1)

(PROGRAM=dg4msql)

)

(SID_DESC=(SID_NAME=toCrm)

(ORACLE_HOME=/oracle/app/oracle/product/11.2.0.4/tg_1)

(PROGRAM=dg4msql)

)

(SID_DESC=(SID_NAME=toCrmof)

(ORACLE_HOME=/oracle/app/oracle/product/11.2.0.4/tg_1)

(PROGRAM=dg4msql)

)

(SID_DESC=(SID_NAME=toCos)

(ORACLE_HOME=/oracle/app/oracle/product/11.2.0.4/tg_1)

(PROGRAM=dg4msql)

)

(SID_DESC=(SID_NAME=toCcrm)

(ORACLE_HOME=/oracle/app/oracle/product/11.2.0.4/tg_1)

(PROGRAM=dg4msql)

)

(SID_DESC=(SID_NAME=toKCBL)

(ORACLE_HOME=/oracle/app/oracle/product/11.2.0.4/tg_1)

(PROGRAM=dg4msql)

)

(SID_DESC=(SID_NAME=toOtc)

(ORACLE_HOME=/oracle/app/oracle/product/11.2.0.4/tg_1)

(PROGRAM=dg4msql)

)

(SID_DESC=(SID_NAME=totougu)

(ORACLE_HOME=/oracle/app/oracle/product/11.2.0.4/dbhome_1)

(PROGRAM=dg4odbc)

(ENVS=LD_LIBRARY_PATH=/usr/lib64:/oracle/app/oracle/product/11.2.0.4/dbhome_1/lib)

)

)

alterpublic database link LINK2TOUGU connect to syn identified by "syn";

createpublic database link LINK2TOUGU2 connect to "syn" IDENTIFIED by "syn" using 'TOTOUGU';

[dbjf-crm-pifda:oracle]:/oracle/app/oracle/product/11.2.0.4/dbhome_1/hs/admin>cat inittotougu.ora

HS_FDS_CONNECT_INFO=totougu # /etc/odbc.ini中的配置

HS_FDS_SHAREABLE_NAME=/usr/lib64/libodbc.so

HS_FDS_SUPPORT_STATISTICS=FALSE

HS_FDS_REMOTE_DB_CHARSET=utf8

HS_KEEP_REMOTE_COLUMN_SIZE=ALL

HS_NLS_LENGTH_SEMANTICS=CHAR

HS_LANGUAGE=AMERICAN_AMERICA.AL32UTF8

# Oracle数据库字符集，根据情况进行设置

#HS_FDS_MAP_NCHAR=TRUE

#HS_SQL_HANDLE_STMT_REUSE=TRUE

HS_NLS_NCHAR=UCS2

#UCS2

# ODBC env variablesset ODBCINI=/etc/odbc.ini

[dbjf-crm-pifda:oracle]:/oracle/app/oracle/product/11.2.0.4/dbhome_1/hs/admin>cat /etc/odbc.ini

[totougu]

# 如上为ODBC的连接标识

Driver= /usr/lib64/libmyodbc5.so

# 指定驱动文件路径

Description=Connect to MySQL DB of TouGu system

# 描述

SERVER= 10.16.244.218# MySQL服务器IP

PORT= 3306# MySQL服务器端口

USER=syn

# MySQL数据库用户

PASSWORD=syn

# MySQL数据库密码

DATABASE=robot_portfolio_core

# MySQL数据库的库，注意大小写

OPTION= 0TRACE=OFF

CHARSET=utf8

STMT= SET NAMES 'utf8'# 如上两行需要设置为与MySQL数据库字符集相同

export ODBCINI=/etc/odbc.ini

export LD_LIBRARY_PATH=/usr/lib64:/oracle/app/oracle/product/11.2.0.4/dbhome_1/lib

isql totougu-v

[totougu]

Driver= /usr/lib64/libmyodbc5.so

Description=Connect to MySQL DB of TouGu system

SERVER= 10.16.244.218PORT= 3306USER=syn

PASSWORD=syn

DATABASE=robot_portfolio_core

OPTION= 0TRACE=OFF

CHARSET=utf8

STMT= SET NAMES 'utf8'[root@dbjf-crm-pifda ~]# odbcinst -j

unixODBC2.2.14DRIVERS............:/etc/odbcinst.ini

SYSTEM DATA SOURCES:/etc/odbc.ini

FILE DATA SOURCES..:/etc/ODBCDataSources

USER DATA SOURCES..:/root/.odbc.ini

SQLULEN Size.......:8SQLLEN Size........:8SQLSETPOSIROW Size.:8[root@dbjf-crm-pifda ~]#

root@dbjf-crm-pifda ~]# isql totougu -v+---------------------------------------+

| Connected! |

| |

| sql-statement |

| help [tablename] |

| quit |

| |

+---------------------------------------+SQL>[root@dbjf-crm-pifda ~]#

[root@dbjf-crm-pifda ~]# isql totougu -v+---------------------------------------+

| Connected! |

| |

| sql-statement |

| help [tablename] |

| quit |

| |

+---------------------------------------+SQL>show tables;+-----------------------------------------------------------------+

| Tables_in_robot_portfolio_core |

+-----------------------------------------------------------------+

| cart_item |

| content |

| customer |

| customer_cart |

| customer_fof |

| fund_dividend |

| fund_dividend_tmp |

| fund_monthly_return |

| fund_performance |

| fund_return |

| fund_split |

| fund_split_tmp |

| fund_value |

| fund_value20190228 |

| fund_value_tmp |

| fund_weekly_return |

| holiday_period |

| index_type |

| portal_role |

| portal_user_role |

| portfolio |

| portfolio_adjustment_history |

| portfolio_detail |

| portfolio_max_drawdown |

| portfolio_monthly_return |

| portfolio_performance |

| portfolio_return |

| portfolio_risk_sequence |

| portfolio_setting |

| portfolio_value |

| portfolio_value20190228 |

| portfolio_weekly_return |

| site |

| site_jwt_key |

| sub_fund |

| sub_fund_attachment |

| sub_fund_class |

| sub_fund_detail |

| sub_fund_detail_tmp |

| sub_fund_estimated_fee_rate |

| sub_fund_open_date |

| sub_fund_site |

| sub_fund_tmp |

| update_log |

| version |

+-----------------------------------------------------------------+SQLRowCount returns45

45rows fetched

SQL>

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
oracle odbc mysql_通过odbc配置oracle到mysql的连接

**************public信息**************SQL> select * fromdba_db_links;OWNER DB_LINK USERNAME HOST ...
复制链接

扫一扫

评论

被折叠的条评论为什么被折叠?

到【灌水乐园】发言

查看更多评论

添加红包

成就一亿技术人!

hope_wisdom

发出的红包

实付元

使用余额支付

点击重新获取

扫码支付

钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。