SQL*Loader-704: 内部错误: ulconnect: OCIServerAttach [0] SQL*Loader-704: Internal error ulconnect: OCI

原因1：

Hi,

I had the same problem. I already fixed it!

I use two ORACLE_HOME, one for Oracle Client and one for Oracle Developer Suite 10g. The sqlplus.exe is in both BIN directories, but sqlldr is only in client's ORACLE_HOME\BIN directory.

When you run sqlplus.exe, it uses tnsnames.ora from devsuite's ORACLE_HOME\NETWORK\ADMIN, I think, it contains rows for SID=c.

When you run sqlldr.exe, it uses tnsnames.ora from client's ORACLE_HOME\NETWORK\ADMIN, I think, it does not contain rows for SID=c (my tnsnames.ora did not contain them).

Make both tnsnames.ora the same and your problem will be fixed.

Tom

当你见了两个client时，当保持这两个client的tnsnames.ora文件一致，以确定他们取得sid都有

原因2：

cmd命令首先cd到control文件的目录下