sqlldr - This app can’t run on your PC and Access denied

Current Environment:

Oracle EE 12.2.0.1 hosted on Windows Server

Error Description:
One of our client faced below error message while executing sqlldr command.

cmd> sqlldr scott/*****

Access Denied and

‘This app can’t run on your PC’

Problem Description:
Initially, i thought that it was not an Oracle issue, but after checking observed that this sqlldr file corresponds to Oracle Binaries only. This file is used for SQL*Loader which is the primary method for quickly populating Oracle tables with data from external files. It has a powerful data parsing engine that puts little limitation on the format of the data in the datafile. SQL*Loader is invoked when you specify the sqlldr command or use the Enterprise Manager interface.


Problem Identification:
After executing below command, i got the path of the sqlldr command which is nothing but $ORACLE_HOME/bin/sqlldr

cmd> where sqlldr

D:\app\oracle\product\12.2.1\dbhome_1\bin

First I checked the permissions of the file and compared permissions with sqlplus file. But proper permissions were given to both sqlplus and sqlldr file.

I tried to log in to database and i was able to login without any issue.

Then I checked size of the file sqlldr which was the main culprit.

The size of the file sqlldr was 0 KB.  I used below resolution for this issue.

Problem Resolution:
1. Take backup of the original file(Copy this file with different name).

2. Check same Oracle 12.2.0.1 setup wherever exists. Copy the same sqlldr file to affected server in the same directory.

Note: Don't copy the file from 11g to 12c or vice-versa.

3. Check the size of the file.

After implementing this resolution, problem was fixed.




Thanks for reading this post ! Please comment if you like this post !