下载: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
完整的输出:
[oracle@offdb ~]$ sqluldr2linux64.bin
sqluldr2linux64.bin: error while loading shared libraries: libclntsh.so: cannot open shared object file: No such file or directory
[oracle@offdb ~]$ 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)
[oracle@offdb ~]$
缺这个的这个文件,可以在oracle安装目录中找到,做一个软连接到lib中去,注意权限问题,root操作,否者没权限
ln -s /u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so /lib64/libclntsh.so
再次执行即可运行成功
[root@offdb ~]# ln -s /u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so /lib64/libclntsh.so
[root@offdb ~]# su - oracle
[oracle@offdb ~]$ 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.