WeiYe-Jing / datax-web

DataX集成可视化页面,选择数据源即可一键生成数据同步任务,支持RDBMS、Hive、HBase、ClickHouse、MongoDB等数据源,批量创建RDBMS数据同步任务,集成开源调度系统,支持分布式、增量同步数据、实时查看运行日志、监控执行器资源、KILL运行进程、数据源信息加密等。
https://segmentfault.com/u/weiye_jing/articles
MIT License
5.6k stars 2.16k forks source link

[BUG] Oracle.DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: "libclntsh.so: cannot open shared object file: No such file or directory". #673

Open basketballboy opened 4 months ago

basketballboy commented 4 months ago

2024-07-04 17:37:21 [JobThread.run-130]
----------- datax-web job execute start -----------
----------- Param: 2024-07-04 17:37:21 [ScriptJobHandler.execute-82] ----------- script file:/u01/datax/datax-web-2.1.2/modules/datax-executor/bin/../data/applogs/executor/jobhandler/gluesource/157298_1720085839000.py ----------- 2024-07-04 17:37:21 [ScriptUtil.execToFile-81] ------------------Process id: 87901 2024-07-04 17:37:21 [ProcessCallbackThread.callbackLog-186]
----------- datax-web job callback finish. Traceback (most recent call last): File "/u01/datax/datax-web-2.1.2/modules/datax-executor/bin/../data/applogs/executor/jobhandler/gluesource/157298_1720085839000.py", line 12, in connection = cx_Oracle.connect(**oracle_config) cx_Oracle.DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: "libclntsh.so: cannot open shared object file: No such file or directory". See https://cx-oracle.readthedocs.io/en/latest/user_guide/installation.html for help 2024-07-04 17:37:21 [JobThread.run-165]
----------- datax-web job execute end(finish) -----------
----------- ReturnT:ReturnT [code=500, msg=script exit value(1) is failed, content=null] 2024-07-04 17:37:21 [TriggerCallbackThread.callbackLog-186]
----------- datax-web job callback finish.

devbiu commented 3 months ago

在datax启动路径前面 有一个 /u01 应该是直接复制路径导致最前面有一个隐藏字符 建议在配置文件中删除datax路径(可以删除整行, 因为有一个不可见字符)然后手动输入 datax路径, 例如: /datax/datax-web-2.1.2/modules/datax-executor/bin/.