Data Was Not Loaded: The Program Can't Start because oranfsodm12.dll is Missing from Your Computer

Symptoms

After running the import process into the Oracle database in the import log file there was no information about the number of loaded rows, and additional .log files with the information about the data load process were not generated in the export directory.

Also when running the -help command with sqlldr utility.

 sqlldr -help

You see the screenshot below:

Cause

This issue appears with Oracle Database Client (12.1.0.2.0), the because there is no oranfsodm12.dll in the BIN directory (directory on the local machine, where all the Oracle utilities are located).

Solution

There are 2 ways of resolving such a case.

• Copy the File

In the BIN directory, copy the oraodm12.dll file and renaming it to oranfsodm12.dll. And it should solve the issue.

• Reinstall your Oracle Client

The other way is to reinstall your Oracle client.
After the installation process this issue should be fixed.

If you have any additional questions, please feel free to contact us: support@ispirer.com