可视化工具superset连oracle数据库 DPI-1047
DPI-1047: Cannot locate a 64-bit Oracle Client library
每次配置superset数据源oracle连接都报错 DPI-1047: Cannot locate a 64-bit Oracle Client library: libclntsh.so: cannot open shared object file: No such file or directory,即使我在profile、bashrc等文件写上了LD_LIBRARY_PATH都不行。甚至于在创建容器的时传递环境变量以及在superset_config中配置了相关环境变量都不行
安装oracle 客户端 oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
alien oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm dpkg -i oracle-instantclient11.2-basic_11.2.0.4.0-2_amd64.deb
/etc/profile
export ORACLE_HOME=/usr/lib/oracle/11.2/client64 export PATH=$ORACLE_HOME/bin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
下面这个步很重要,至关重要
root@9e4abb311e7b:/home/superset# cat /etc/ld.so.conf include /etc/ld.so.conf.d/*.conf /usr/lib/oracle/11.2/client64/lib
docker restart superset
至此,可以连上数据库获取到数据了,但是还有问题:中文乱码