linux sqluldr2命令,sqluldr2 linux64

上传解压后，放入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.