ODBC DBLink - Oracle and MySQL

command.sql

CREATE DATABASE LINK "MYSQL_ORCL_LNK" CONNECT TO "USER_LNK" IDENTIFIED BY "PASSWD_LNK" USING 'MYSQLORACLE';

error.md

SQL> SELECT * FROM table_name@MYSQL_ORCL_LNK;

ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: preceding 2 lines from MYSQL_ORCL_DB

initMySQL.ora

$ORACLE_HOME/hs/admin/initMySQL.ora

HS_FDS_CONNECT_INFO = MySQL
HS_FDS_TRACE_LEVEL = DEBUG
HS_FDS_SHAREABLE_NAME = /usr/lib/libmyodbc.so

HS_FDS_SQLLEN_INTERPRETATION = 32
HS_FDS_REPORT_REAL_AS_DOUBLE = TRUE
HS_FDS_FETCH_ROWS = 1
HS_FDS_RECOVERY_ACCOUNT = RECOVER
HS_FDS_RECOVERY_PWD = RECOVER

set ODBCINI=/etc/odbc.ini
set SQL_MODE='ANSI_QUOTES'

listener.ora

$ORACLE_HOME/network/admin/listener.ora

(SID_DESC =
       (PROGRAM = dg4odbc)
       (ORACLE_HOME = /u01/app/oracle/product/11.2.0/xe)
       (SID_NAME = MySQL)
       (ENVS = LD_LIBRARY_PATH=/usr/lib64:/u01/app/oracle/product/11.2.0/xe/lib:/lib64:/usr/lib64)
)

odbc.ini

[MySQL]
Description=MySQL database
Driver=MySQL
Server=127.0.0.1
Port=3306
Socket=/var/run/mysqld/mysqld.sock
User=root
Password=root
Database=db_test

odbcinst.ini

[MySQL]
Description=ODBC for MySQL
Driver=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so
Setup=/usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so
UsageCount=1

tnsnames.ora

$ORACLE_HOME/network/admin/tnsnames.ora

MYSQLORACLE =
  (DESCRIPTION =
    (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
    (CONNECT_DATA =
        (SID =  MySQL)
     )
     (HS = OK)
  )