Oracle SqlLoader fix for Windows 2016


August 26, 2019WindowsNo comments

After configuring Windows 2016 OS, if you start SQL Loader you may receive the message

This Program can’t start because oranfsodm12.dll is missing from your computer.Try reinstalling the program to fix this problem

Most often the reason is the missing dll after installing oracle client on the machine.

The quick fix for this error is to copy the oranfsodm12.dll from a working copy into this folder c:\oracle\product\12.1.0\client_32\BIN (depends on your oracle directory)

Second step is to have the tnsnames.ora file configured in the Oracle client. Either you can save the file on C:\oracle\product\12.1.0\client_32\network\admin or have it point to a location from environment variable.

Run the sqlldr command to test the fix.

Leave a Reply