Wednesday, May 23, 2012

sqlldr: Permission denied

PROBLEM DESCRIPTION:
====================

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 correpted.


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.

No comments: