Re: How I run a shell script from the scheduler on 10.2.0.2.0 ?

  • From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
  • To: owensmith99@xxxxxxxxx
  • Date: Fri, 7 Sep 2007 11:38:58 +0200

Owen

What user owns the extproc Binary in $ORACLE_HOME/bin ? The scheduler will
fork a process to execute your script '/h/oracle/scripts/tst.sh' as that
user. Ensure the user has execute rights (and can change into that
directory). Per default - if I'm not mistaken, it's user "nobody".

Stefan

On 9/7/07, Owen Smith <owensmith99@xxxxxxxxx> wrote:
>
> Hello Oracle People,
>
> I'd like to run a shell script from the Scheduler in my 10g database.
>
> Right now it is a simple shell script.
>
> Eventually it will wrap RMAN commands to back up my DB.
>
> I wrote a simple pl/sql script to create a job:
>
> -- cr_job10.sql
>
> BEGIN
> DBMS_SCHEDULER.CREATE_JOB (
>    job_name             => 'my_backup_job',
>    job_type             => 'EXECUTABLE',
>    job_action           => '/h/oracle/scripts/tst.sh',
>    start_date           => '06-SEP-07 5.33.00PM US/Pacific',
>    repeat_interval      => 'FREQ=DAILY',
>    end_date             => '08-SEP-07 4.00.00PM US/Pacific',
>    enabled              =>  TRUE,
>    comments             => 'My Backup Job');
> END;
> /
>
> I see no errors when I run the above procedure.
>
> I checked DBA_SCHEDULER_JOBS and the job is in there.
>
> The scheduler, though, errors out with an error which I see in a trace
> file:
>
> /h/oracle/admin/orcl/bdump/orcl_j000_22396.trc
> Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
> With the Partitioning, OLAP and Data Mining options
> ORACLE_HOME = /h/oracle/product/10r2
> System name:    SunOS
> Node name:      sol
> Release:        5.10
> Version:        Generic_118855-14
> Machine:        i86pc
> Instance name: orcl
> Redo thread mounted by this instance: 1
> Oracle process number: 15
> Unix process pid: 22396, image: oracle@sol (J000)
>
> *** ACTION NAME:(MY_BACKUP_JOB) 2007-09-06 17:33:00.175
> *** MODULE NAME:(DBMS_SCHEDULER) 2007-09-06 17:33:00.175
> *** SERVICE NAME:(SYS$USERS) 2007-09-06 17:33:00.175
> *** CLIENT ID:() 2007-09-06 17:33:00.175
> *** SESSION ID:(140.13520) 2007-09-06 17:33:00.175
> *** 2007-09-06 17:33:00.175
> ORA-12012: error on auto execute of job 53267
> ORA-27369: job of type EXECUTABLE failed with exit code: 274662
>
> I googled on this:
>
> ORA-27369: job of type EXECUTABLE failed with exit code: 274662
>
> Google returned only 1 hit.
>
> There, I see some evidence that I need to configure something inside
> of Oracle to run shell scripts from the scheduler, but possibly just
> for machines running windows.  I'm running Solaris.
>
> Do any of you know what I need to configure inside of Oracle to
> run shell scripts from the scheduler?
>
> -Owen
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>


-- 
=========================

Stefan P Knecht
Consultant
Infrastructure Managed Services

Trivadis AG
Europa-Strasse 5
CH-8152 Glattbrugg

Phone +41-44-808 70 20
Fax +41-808 70 12
Mobile +41-79-571 36 27
stefan.knecht@xxxxxxxxxxxx
http://www.trivadis.com

OCP SCSA SCNA
=========================

Other related posts: