I am in RAC installation access MYSQL connection
Wget -c ftp://ftp.gnu.org/gnu/readline/readline-6.2.tar.gz
Wget http://sourceforge.net/projects/... - 64. The tar. Gz/download
Wget http://dev.mysql.com/get/Downloa... tp://cdn.mysql.com/


Install the three tool

configure ODBC.ini is OK isql mysqllink - v can query data

Initmysqllink. Ora
# This is a sample agent init file that contains the HS the parameters that are
# men for the Database Gateway for ODBC

#
# the 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
The set LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib/usr/lib64:


Monitoring configuration
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=mysqllink)
(ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)
(the 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 also matches the

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