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!

Scheduler Error

435911Mar 3 2008 — edited Mar 3 2008
Hi all,

I could really use some help with the following errors. I have spent time reviewing the posts here but have not been able to resolve the issues. Here is what I am getting.

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.

What I am trying to accomplish is this;
From within my PLSQL Web toolkit application I want to run a procedure that executes a job to stop and start isqlplus.

I create the following 2 jobs.

begin
DBMS_SCHEDULER.CREATE_JOB (
job_name =>'ISQLSTART',
job_type =>'executable',
job_action => 'C:\WINDOWS\SYSTEM32\CMS.EXE /c C:\ISQLSTART.BAT >null',
enabled =>true,auto_drop =>false
);
end;
/


begin
DBMS_SCHEDULER.CREATE_JOB (
job_name =>'ISQLSTOP',
job_type =>'executable',
job_action => 'C:\WINDOWS\SYSTEM32\CMS.EXE /c C:\ISQLSTOP.BAT >null',
enabled =>true,auto_drop =>false
);
end;
/

ISQLSTART.BAT is
e:\oracle\product\10.2.0\db\bin\isqlplusctl start

ISQLSTOP.BAT is
e:\oracle\product\10.2.0\db\bin\isqlplusctl stop


Both of these files run when executed from a command prompt.

Oracle version is 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production

Any help would be greatly appreciated.

Thanks.

Tom
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 31 2008
Added on Mar 3 2008
2 comments
2,153 views