下載:http://www.onexsoft.com/software/sqluldr2linux64.zip
上傳解壓后羡铲,放入path路徑
先直接調(diào)用執(zhí)行試試蜂桶,一般會(huì)報(bào)如下錯(cuò)誤:
sqluldr2linux64.bin: error while loading shared libraries: libclntsh.so: cannot open shared object file: No such file or directory
也可以用ldd命令來(lái)看缺什么包: 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 ~]$
缺這個(gè)的這個(gè)文件,可以在oracle安裝目錄中找到也切,做一個(gè)軟連接到lib中去扑媚,注意權(quán)限問題腰湾,root操作,否者沒權(quán)限
ln -s /u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so /lib64/libclntsh.so
再次執(zhí)行即可運(yùn)行成功
[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.