odbc error "Failed to load ODBC library symbol"

trajon
trajon Member Posts: 1 Green Ribbon

Hello

I have Percona 5.7 (first server OEL 7), I need to create dblink for Oracle 19 (64-bit) (second server OEL).

I have installed odbc driver mysql-connector-odbc-5.3.13-linux-el7-x86-64bit.

When I try select data using isql that work ok:

[[email protected] ~]# isql -v percona_db oracle
+---------------------------------------+
| Connected!                           |
|                                      |
| sql-statement                        |
| help [tablename]                     |
| quit                                 |
|                                      |
+---------------------------------------+
SQL> show databases
+-----------------------------------------------------------------+
| Database                                                       |
+-----------------------------------------------------------------+
| information_schema                                             |
| mysql                                                          |
| percona_db                                                         |
| performance_schema                                             |
| sys                                                            |
+-----------------------------------------------------------------+
SQLRowCount returns 5
5 rows fetched


When I select data from dblink (select * from [email protected];), have error:

[[email protected] log]$ cat PERCONA_agt_4511.trc


Oracle Corporation --- 2021-02-26 04:05:09.388611000


Heterogeneous Agent Release
19.0.0.0.0




Oracle Corporation --- 2021-02-26 04:05:09.388459000

   Version 19.0.0.0.0

HOSGIP for "HS_FDS_TRACE_LEVEL" returned "ON"
HOCXU_VC2_MAX=4000
HOCXU_RAW_MAX=2000
HOSGIP for "HS_FDS_SHAREABLE_NAME" returned "/usr/local/lib/libmyodbc5a.so"
Failed to load ODBC library symbol: /usr/local/lib/libmyodbc5a.so(SQLColAttributeW)
HS Gateway: NULL connection context at exit
HOA 02/26 04:05:09.403468000: (horcrces_CleanupExtprocSession) Entered!
HOA 02/26 04:05:09.403528000: (horcrpooe_PopOciEnv) Entered!
HOA 02/26 04:05:09.403557000: (horcrfoe_FreeOciEnv) Entered!
HOA 02/26 04:05:09.403586000: (horcrfoe_FreeOciEnv) Exiting...
HOA 02/26 04:05:09.403614000: (horcrfse_FreeStackElt) Entered!
HOA 02/26 04:05:09.403642000: (horcrfse_FreeStackElt) Exiting...
HOA 02/26 04:05:09.403670000: (horcrpooe_PopOciEnv) Exiting...
HOA 02/26 04:05:09.403837000: (horcrces_CleanupExtprocSession) Exiting...

Thanks