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!

Launching external job failed: Couldn't fork process?

552957Jul 10 2009 — edited Jul 10 2009
Hi,

I've searched the forum but didn't see any similar problems. I'm trying to set up a simple remote job. The DB is on UNIX and the remote agent is on Windows XP on my laptop. Unfortunately I'm getting the following errors. Any advice would be greatly appreciated.

Thanks
Owen

on user_scheduler_job_run_details
STANDARD_ERROR="Launching external job failed: Couldn't fork process"

On the remote host's agent.log
2009.07.10 11:27:10 BST Log ID: job_1115953_41 Name: SINGLETONO.TEST_JOB Source: chasdwdbdev.ins-sure.com : 9999 Source DB: DWODSD01.XCHANGING.COM Command: c:\python26\python.exe --version
2009.07.10 11:27:10 BST Job terminated with error number: 9. Duration: 0.328 seconds

The job definition is below.


BEGIN

dbms_scheduler.purge_log();
dbms_scheduler.drop_credential('singletono');

dbms_scheduler.create_credential
(
credential_name => 'singletono',
username => 'singletono',
password => '******'
);

dbms_scheduler.create_job(
job_name => 'TEST_JOB',
job_type => 'EXECUTABLE',
job_action => 'c:\python26\python.exe --version',
auto_drop => TRUE
);

dbms_scheduler.set_attribute('TEST_JOB', 'credential_name', 'singletono');
dbms_scheduler.set_attribute('TEST_JOB', 'destination', '10.17.24.46:9999');
dbms_scheduler.enable('TEST_JOB');

END;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 7 2009
Added on Jul 10 2009
1 comment
3,835 views