Concurrent Request completed with “sqlldr : Permission denied” error

While running the Concurrent Request it has completed with the following Error.


Arguments
————
/testapps/apps/apps_st/appl/doyen/12.0.0/Interfaces/DOYENINBOUND/doyen2.csv


sqlldr: Permission denied
usdsop: exec failed during spawnusdsop cannot write to pipe


Cause: usdsop attempted to write data to another process using a pipe, but an error occurred during the write.


Action: Check the other process for abrupt termination. Check that you have sufficient resource: Broken pipe
usdsop cannot write to pipe


Cause: usdsop attempted to write data to another process using a pipe, but an error occurred during the write.


Cause:


Due to some reasons the permission has been changed or the binary may be corrupted.


solution:
=========
1. Check the permission for sqlldr file in (ORACLE_HOME) ie) 10.1.2 ORACLE_HOME/bin directory
2. Check the ORACLE_HOME path is set correctly for apps.
Recent Posts