This error had been discussed a lot, however it is different in my case.
The oracle client is running on Windows Server 2012. Oracle server runs on a different machine. The SQLLDR is launched via an application using an external script (VB/Perl). Users connect to the windows server from Citrix and launch this application to load some files.
The issue is ORA-12560 error does not occur all the time and not for all users. Even when the error occurred I confirmed that the service is running and I was able to connect to oracle fine from the same server. I confirmed ORACLE_HOME is set (even though it may not be required). The challenge is, the issue is not consistent i.e. it works sometimes.
Effectively the command executed is:
sqlldr parfile=E:/PERL_LDS/PERL/dir_script/dir_perl/../../dir_data/dir_temp/20180925_191307_LDR_FLD_History.ctl.param
parfile content:
userid=user/"password"@//0.0.0.0:1521/ORACLE_SID
control=E:/PERL_LDS/PERL/dir_script/dir_perl/../../dir_data/dir_temp/20180925_191307_LDR_FLD_History.ctl
data=E:/PERL_LDS/PERL/dir_script/dir_perl/../../dir_data/terra.FLD_History.dat
rows=50000
log=E:/PERL_LDS/PERL/dir_script/dir_perl/../../dir_log/20180925_191307.terra.FLD_History.log
discard=E:/PERL_LDS/PERL/dir_script/dir_perl/../../dir_log/20180925_191307.terra.FLD_History.discard
bad=E:/PERL_LDS/PERL/dir_script/dir_perl/../../dir_log/20180925_191307.terra.FLD_History.bad
errors=50000
skip=1
Can you help find out the root cause?.