ORACLE LINUX 通过ODBC 连MYSQL 报 MYSQL.SOCK错误

[客家族_Shark曾_小凡仙]

我是在RAC 上安装访问MYSQL的连接
wget -c ftp://ftp.gnu.org/gnu/readline/readline-6.2.tar.gz
wget http://sourceforge.net/projects/ ... -64.tar.gz/download
wget http://dev.mysql.com/get/Downloa ... tp://cdn.mysql.com/


安装这三个工具

配置ODBC.INI 是OK的 isql mysqllink -v 可以查询数据

initmysqllink.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 =mysqllink
HS_FDS_TRACE_LEVEL = 255
HS_FDS_SHAREABLE_NAME =/u01/unixodbc-2.2.14/usr/local/lib/libodbc.so
HS_FDS_SUPPORT_STATISTICS=FALSE
HS_LANGUAGE=AMERICAN_AMERICA.ZHS16GBK
HS_FDS_TRACE_FILE_NAME=MYSQLTRACE.TRC
HS_FDS_NCHAR=UCS2

#
# ODBC specific environment variables
#
set ODBCINI=/u01/unixodbc-2.2.14/odbc.ini
set LD_LIBRARY_PATH = $LD_LIBRARY_PATH:/usr/lib:/usr/lib64


监听配置
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME=mysqllink)
(ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)
(PROGRAM=dg4odbc)
(ENVS=LD_LIBRARY_PATH=/u01/unixodbc-2.2.14/usr/local/lib:/u01/app/oracle/product/11.2.0/db_1/lib:/u01/unixodbc-2.2.14/odbc.ini)
)
)


TNSNAEM。ORA 也配对了

建立了PUBLIC DBLINK
SQL> select count(*) from t_fw_main@TEST_MYSQL_BI;
select count(*) from t_fw_main@TEST_MYSQL_BI
*
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[unixODBC][MySQL][ODBC 5.3(w) Driver]Can't connect to local MySQL server through socket '/tmp/mysql.sock' (13) {08S01,NativeErr = 2002}
ORA-02063: preceding 2 lines from TEST_MYSQL_BI