sqluldr2 linux64

下载：http://www.onexsoft.com/software/sqluldr2linux64.zip

上传解压后，放入path路径

先直接调用执行试试，一般会报如下错误：
sqluldr2linux64.bin: error while loading shared libraries: libclntsh.so: cannot open shared object file: No such file or directory
也可以用ldd命令来看缺什么包： ldd ./bin/sqluldr2linux64.bin
完整的输出：

[[email protected] ~]$ sqluldr2linux64.bin 
sqluldr2linux64.bin: error while loading shared libraries: libclntsh.so: cannot open shared object file: No such file or directory
[[email protected] ~]$ ldd ./bin/sqluldr2linux64.bin 
    linux-vdso.so.1 =>  (0x00007ffdf0778000)
    libclntsh.so => not found
    libc.so.6 => /lib64/libc.so.6 (0x00007fd398371000)
    /lib64/ld-linux-x86-64.so.2 (0x000055b5a4b9e000)
[[email protected] ~]$

缺这个的这个文件，可以在oracle安装目录中找到，做一个软连接到lib中去，注意权限问题，root操作，否者没权限
ln -s /u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so /lib64/libclntsh.so

再次执行即可运行成功
[[email protected] ~]# ln -s /u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so /lib64/libclntsh.so
[[email protected] ~]# su - oracle
[[email protected] ~]$ sqluldr2linux64.bin

SQL*UnLoader: Fast Oracle Text Unloader (GZIP, Parallel), Release 4.0.1
(@) Copyright Lou Fangxin (AnySQL.net) 2004 - 2010, all rights reserved.

License: Free for non-commercial useage, else 100 USD per server.

转载于:https://www.jianshu.com/p/1dc1eee45d96