Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Can't get sqlldr.exe running on new Windows 10 machine

Brian LeahyMay 12 2022 — edited May 12 2022

I have followed the instructions I've found online (detailed below) to accomplish this, and still I get:
image.png...followed by identical errors for oranls.dll, oracore.dll and oraxml.dll.
This is for a user PC, I need sqlldr.exe running, but the database is not local.
What I have tried:
I downloaded all these files:
instantclient-basiclite-windows.x64-21.3.0.0.0.zip
instantclient-tools-windows.x64-21.3.0.0.0.zip
instantclient-sqlplus-windows.x64-21.3.0.0.0.zip
I unzipped all of them into C:\Oracle\instantclient_21_3
Edited my Path environment variable to include C:\Oracle\instantclient_21_3 - both the user's Path and the "System" Path.
Created environment variable TNS_ADMIN to point to directory C:\Oracle\tns_admin in which I have these (certified correct) files:
ldap.ora
sqlnet.ora
tnsnames.ora
I downloaded and ran vs_redistx64.exe (visual studio redistributable) and rebooted the PC.
Still, when I go to C:\Oracle\instantclient_21_3 and execute .\sqlldr.exe (with no arguments) I get the above error messages "The code execution cannot proceed..." etc. Instead, I should at least get the text telling me how to use sqlldr.exe
This machine won't be used for development, and I would prefer not to install SDKs, let alone an actual database, onto the local machine if I can avoid it.
Can someone help?

This post has been answered by Brian Leahy on May 14 2022
Jump to Answer
Comments
Post Details
Added on May 12 2022
3 comments
3,591 views