Database Software

Hi

I'm in two minds as to whether this as an XE database problem or a general Scheduler problem so I'm trying my luck on this forum first.

Details: Database XE, Centos O/S

Problem

I can schedule all the different types of jobs and all except external jobs(job_type EXECUTABLE) do run. With external jobs, they just never complete running. It's not like they are doing anything either.

- Selecting from USER_SCHEDULER_RUNNING_JOBS while an external job is running just never comes back.

- Checking what's going on in v$session reveals an ACTIVE status and EVENT "JS external job".

- The xe_J00X os process doesn't seem to be doing anything. However, if I terminate(kill) it, it won't die except with kill -9, which frees up the database.

I have searched and tried a number of ideas but I haven't been able to resolve this.

So far
- I have tried the Metalink notes for setting permissions to nobody user.
- I have added #!/bin/ksh or #!/bin/bash to the shell scripts
- Implemented externaljob.ora

The results are the same. External jobs just hang, no error message, nothing.

I'd appreciate help if you can.

Thank you.
--
Siphiwe