Categories
odbc error "Failed to load ODBC library symbol"
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:
[root@oracle ~]# 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 emp@percona;), have error:
[oracle@oracle 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
0