Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-27303: additional info: No process is on the other end of the pipe

jl1997Mar 3 2011 — edited Mar 3 2011
Can someone help me with the following error?

ORA-27370: job slave failed to launch a job of type EXECUTABLE
ORA-27300: OS system dependent operation:accessing execution agent failed with status: 233
ORA-27301: OS failure message: No process is on the other end of the pipe.
ORA-27302: failure occurred at: sjsec 9
ORA-27303: additional information: No process is on the other end of the pipe.

I am simply trying to copy a file from a folder on the database server to another location on a different drive. The destination folder is not defined in the Oracle DB as a directory_object (I need to be able to move files to any folder on the file system, not just folders defined as directory objects)

Here is my PL/SQL:
DECLARE
l_job VARCHAR2(10) := 'DB$S1';
BEGIN
DBMS_SCHEDULER.create_job (
job_name => l_job,
job_type => 'EXECUTABLE',
job_action => '%WINDIR%\system32\cmd.exe',
number_of_arguments=>3,
enabled => FALSE,
auto_drop=>FALSE,
comments => 'CREATE_JOB test using a CMD script.');

dbms_scheduler.set_job_argument_value(l_job,1,'/q');
dbms_scheduler.set_job_argument_value(l_job,2,'/c');
dbms_scheduler.set_job_argument_value(l_job,3,'D:\Oracle\utl_file\copy_file.bat');
dbms_scheduler.enable(l_job);

COMMIT;

END;
/

Here is contents of "copy_file.bat"
--
copy data.txt J:\test\data.txt
--

I have researched similar posts, but so far have not been able to get past this error.

*Note: The OracleJobScheduler service is running
The user does have the CREATE EXTERNAL JOB privilege

Much thanks,
Jim
This post has been answered by Ronald Rood on Mar 3 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 31 2011
Added on Mar 3 2011
2 comments
1,250 views