Re: run an external OS script in Oracle 10g

On Sat, 22 Apr 2006 17:40:44 +0200, "Michele Campagni" <michele.campagni_at_libero.it> wrote:

>I've difficult in executing an external OS script like this:
>vmstat.sh: "/usr/bin/vmstat >> /tmp/vmstat.LST"
>which have this permission:
>-rwxr-xr-x 1 oracle other 47 Apr 3 05:13
>/export/home/oracle/vmstat.sh
>
>I try with this:
>
>BEGIN
> dbms_scheduler.create_job(job_name => 'myjob',
> job_type => 'executable',
> job_action => '/oracle/vmstat.sh',
> enabled => TRUE,
> auto_drop => TRUE);
>END;
>/
>
>but oracle responds:
>SQL> exec dbms_scheduler.run_job('VMSTAT_JOB');
>BEGIN dbms_scheduler.run_job('VMSTAT_JOB'); END;
>
>*
>ERROR at line 1:
>ORA-27369: job of type EXECUTABLE failed with exit code: Not owner
>ORA-06512: at "SYS.DBMS_ISCHED", line 150
>ORA-06512: at "SYS.DBMS_SCHEDULER", line 441
>ORA-06512: at line 1
>
>I'm using Solaris 10/Sparc and Oracle 10g.
>what's the problem?
>thanks
>
>

/oracle/vmstat.sh doesn't look exactly like to be the same file as /usr/bin/vmstat.sh
Other than that: why on earth are you running vmstat in a *database*.

--
Sybrand Bakker, Senior Oracle DBA