ORA-27303: additional info: No process is on the other end of the pipe
jl1997Mar 3 2011 — edited Mar 3 2011Can 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