Skip to content Skip to sidebar Skip to footer

Sqlldr.exe Not Working For Windows 10

I have recently installed Oracle Database Client (12.1.0.2.0)(winx64) with Custom installation and by selecting only database utilities which will include SQL*Loader among with the

Solution 1:

That is a known bug (Bug 17548895) in Oracle Universal Installer.

Oracle provides a workaround for it:

WORKAROUND INFORMATION
======================
Workarounds include:
To avoid the issue in the first place, explicitely select"Oracle NET"
component during install

After the fact, you can 
a) do another custom install into the same home, andselect"Oracle NET"or
b) copying ORACLSCE12.DLL from an existing install into OH\bin also resolves
the issue.

However, ORACLSCE12.DLL is not the only file which is missing (that is the issue you are facing) so the workaround b) is not suitable. Additionally to your desired components you have to select "Oracle Net" in the Oracle Universal Installer, then it should work.

Solution 2:

I tried selecting different options and copying oraclsce12.dll around and found the following solution which is a combination of Wernfrieds answer and this thread: sqlldr cannot start because oranfsodm12.dll is missing:

  • Step 1: Renaming oraodm12.dll to oranfsodm12.dll
  • Step 2: Copy ORACLSCE12.DLL into your OH-folder from the installation process

Im using oracle client version 12.1.

Solution 3:

I don't know if it is a bug or not in this version Oracle Client 12.2.1 64 bit. Today i found the same problem when launch sqlldr. This is the message error looks like oranfsodm12.dll is missing

I solve this problem by renaming file oraodm12.dll and renaming it to oranfsodm12.dll. The file is located in C:\app\client<user name>\product\12.1.0\client_1\BIN

Post a Comment for "Sqlldr.exe Not Working For Windows 10"