I am having trouble running sqlldr.exe on a machine that has Oralce 188.8.131.52 instant client installed. I have already copied over all of the DLL files that it said it needed and the whole RDBMS directory from a machine with the full install. This is the error I am getting:
+SQL*Loader-704: Internal error: ulconnect: OCIEnvCreate [-1]+
I don't have any trouble connecting to anything using sqldeveloper. Are there any files or steps I am missing?
The only supported add-on for the Instant Client is sqlplus, integration of other utilities is not supported. You cannot simply mix DLLs from different software packages. There are some documents about workarounds, for example:
But no guarantee that it works and no support from Oracle.