Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 28331 invoked from network); 8 Sep 2007 04:00:27 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 8 Sep 2007 04:00:27 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 503D873B80D; Sat, 8 Sep 2007 04:21:46 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 22016-07; Sat, 8 Sep 2007 04:21:46 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B367B73B787; Sat, 8 Sep 2007 04:21:45 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Sat, 08 Sep 2007 03:37:15 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EC74773BFBA for ; Sat, 8 Sep 2007 03:37:14 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 15567-09 for ; Sat, 8 Sep 2007 03:37:14 -0400 (EDT) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.181]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4790073BF41 for ; Sat, 8 Sep 2007 03:37:14 -0400 (EDT) Received: by wa-out-1112.google.com with SMTP id k22so904370waf for ; Sat, 08 Sep 2007 01:15:54 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; bh=hIsVwW9aLX8On9Ftq7V7uSvIYAbmQ+64mrHshbBoqjk=; b=qIyQfMDqMXP/0Fj97ckLGs5Z2GVP+xXbiHWHVxZ5tEgzpRB+0ssZ8asdbFA9fMHVD7KbA8y1GJ7uJmyWNRf/DHFv4un/ph6HqGJxXJS1CFY9w9cA4RVaxukupsmCm4aFDsJZDsPfGvbs7NHK1K8vE3NWFAg1VwTz7la+Pt07WvU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=Ib5K7iw6w6ldfnWG2+1AMCK4jxCKBedGJ8BD24W6tecVhxXYJrzYh6vof8YQtTsXcgDPV/oK7k2OnyPRAA162lCpe+k/qMl7nfkDlEFIcNcrjLUZgg66bJHx/Aowr65JkjwUgoqIdYVqu7Irj2FFFSVBFouVhSTjoYcfIg2rz8E= Received: by 10.115.58.1 with SMTP id l1mr1785637wak.1189239354267; Sat, 08 Sep 2007 01:15:54 -0700 (PDT) Received: by 10.114.144.12 with HTTP; Sat, 8 Sep 2007 01:15:54 -0700 (PDT) Message-ID: <6e9345580709080115y1da2a7dexbc88f7a954c9da4d@mail.gmail.com> Date: Sat, 8 Sep 2007 10:15:54 +0200 From: "LS Cheng" To: owensmith99@gmail.com Subject: Re: How I run a shell script from the scheduler on 10.2.0.2.0 ? Cc: oracle-l@freelists.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_3943_2113151.1189239354257" References: X-archive-position: 1356 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: exriscer@gmail.com Precedence: normal Reply-to: exriscer@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------=_Part_3943_2113151.1189239354257 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Befoe modifying did you check the permissions of files you did this? chown root $ORACLE_HOME/bin/extjob chmod 4750 $ORACLE_HOME/bin/extjob chown root $ORACLE_HOME/rdbms/admin/externaljob.ora chmod 640 $ORACLE_HOME/rdbms/admin/externaljob.ora because by default those are the permissions, you should not have to do that manually thanks -- LSC On 9/8/07, Owen Smith wrote: > > Oracle People, > > Ravi's comments looked promising. > > I looked for root.sh > > bash sol oracle ~ 23 $ > bash sol oracle ~ 23 $ > bash sol oracle ~ 23 $ cd $ORACLE_BASE > bash sol oracle ~ 24 $ find . -name root.sh -print > ./product/10r2/root.sh > bash sol oracle ~ 25 $ > bash sol oracle ~ 25 $ > bash sol oracle ~ 25 $ > bash sol oracle ~ 25 $ > > I looked for evidence that it alters permissions of files related to > external jobs: > > bash sol oracle ~ 25 $ > bash sol oracle ~ 25 $ > bash sol oracle ~ 25 $ > bash sol oracle ~ 25 $ > bash sol oracle ~ 25 $ > bash sol oracle ~ 25 $ grep CHOWN ./product/10r2/root.sh > CHOWN=/bin/chown > $CHOWN $ORACLE_OWNER $LBIN/`$ECHO $f | $AWK -F/ '{print $NF}'` > 2>&1 2>> $LOG > $CHOWN $ORACLE_OWNER ${ORATAB} > CHOWN="/usr/bin/chown" > CHOWN=/bin/chown > $CHOWN root $ORACLE_HOME/bin/nmo > $CHOWN root $ORACLE_HOME/bin/nmb > $CHOWN root /var/tmp/.oracle > $CHOWN root /tmp/.oracle > bash sol oracle ~ 26 $ > bash sol oracle ~ 26 $ > bash sol oracle ~ 26 $ > > > I did not expect that it would. I'm diligent about following > instructions when I install oracle. > > Perhaps root.sh was enhanced by a quarterly patch. I'm on an eval > license; I have > no access to support or quarterly patches. > > Anyway, I took these steps to follow Ravi's suggestions: > > -emctl stop agent > -emctl stop dbconsole > -lsnrctl stop > -SHUTDOWN IMMEDIATE > > chown root $ORACLE_HOME/bin/extjob > chmod 4750 $ORACLE_HOME/bin/extjob > chown root $ORACLE_HOME/rdbms/admin/externaljob.ora > chmod 640 $ORACLE_HOME/rdbms/admin/externaljob.ora > > -STARTUP > -lsnrctl start > -emctl start agent > -emctl start dbconsole > > > Result? > > It worked. > I can now run shell scripts from the scheduler. > Also I'm pleased that the scripts run as the user I specify in > $ORACLE_HOME/rdbms/admin/externaljob.ora > > For security reasons I don't want external jobs run as a privileged > user like oracle or root. > > Thanks Ravi! > > -Owen > > > On 9/7/07, Owen Smith wrote: > > Hello people, > > > > I should have added this bit of information: > > > > "The script runs fine from oracle's crontab." > > "The script runs fine from a shell owned by oracle." > > > > I'm getting responses telling me to check my env variables and > permissions > > which would be helpful to a UNIX novice. > > > > I have a feeling that no one is using the scheduler to run RMAN scripts. > > > > Tim Hall suggested I take a close look at these files: > > > > $ORACLE_HOME/rdbms/admin/externaljob.ora > > $ORACLE_HOME/bin/extJob > > > > Currently I'm setup like this: > > > > > > bash sol root /h/oracle/product/10r2/bin 31 # > > bash sol root /h/oracle/product/10r2/bin 31 # ll > > $ORACLE_HOME/rdbms/admin/externaljob.ora > > -rw-r--r-- 1 root dba 52 Sep 7 15:29 > > /h/oracle/product/10r2/rdbms/admin/externaljob.ora > > bash sol root /h/oracle/product/10r2/bin 32 # > > bash sol root /h/oracle/product/10r2/bin 32 # cat > > $ORACLE_HOME/rdbms/admin/externaljob.ora > > # externaljob.ora > > run_user = rman > > run_group = rman > > > > bash sol root /h/oracle/product/10r2/bin 33 # > > bash sol root /h/oracle/product/10r2/bin 33 # > > > > > > bash sol root /h/oracle/product/10r2/bin 33 # > > bash sol root /h/oracle/product/10r2/bin 33 # ll $ORACLE_HOME/bin/ext* > > -rwsr-x--- 1 rman dba 30388 Sep 21 2006 > > /h/oracle/product/10r2/bin/extjob* > > -rwsr-x--- 1 rman dba 30392 Sep 21 2006 > > /h/oracle/product/10r2/bin/extjobo* > > -rwsr-x--- 1 rman dba 34468 Sep 21 2006 > > /h/oracle/product/10r2/bin/extproc* > > -rwxr-xr-x 1 oracle dba 300 Sep 21 2006 > > /h/oracle/product/10r2/bin/extusrupgrade* > > bash sol root /h/oracle/product/10r2/bin 34 # > > bash sol root /h/oracle/product/10r2/bin 34 # > > bash sol root /h/oracle/product/10r2/bin 34 # > > > > On my system, the user 'nobody' has no shell so I cannot use nobody. > > > > I created a user named rman: > > > > > > bash sol root /h/oracle/product/10r2/bin 34 # > > bash sol root /h/oracle/product/10r2/bin 34 # > > bash sol root /h/oracle/product/10r2/bin 34 # su - rman > > Sun Microsystems Inc. SunOS 5.10 Generic January 2005 > > $ > > $ id > > uid=220(rman) gid=220(rman) > > $ > > $ > > $ date > > Fri Sep 7 16:30:03 PDT 2007 > > $ > > $ > > > > Jared points out that rman needs access to extproc: > > > > $ ls -la /h/oracle/product/10r2/bin/extproc > > -rwsr-x--- 1 rman dba 34468 Sep 21 2006 > > /h/oracle/product/10r2/bin/extproc > > $ > > $ > > > > > > Here is a demo of rman running his script: > > > > > > bash sol root /h/oracle/product/10r2/bin 35 # su - rman > > Sun Microsystems Inc. SunOS 5.10 Generic January 2005 > > $ > > $ > > $ ls > > scripts > > $ > > $ > > $ scripts/tst.sh > > $ > > $ > > $ cat scripts/tst.sh > > #! /bin/sh > > /usr/bin/date > /tmp/tst.sh.out.txt 2>&1 & > > exit 0 > > > > $ > > $ > > $ cat /tmp/tst.sh.out.txt > > Fri Sep 7 16:31:23 PDT 2007 > > $ > > $ rm /tmp/tst.sh.out.txt > > $ > > > > > > I am focused on this error: > > > > ORA-27369: job of type EXECUTABLE failed with exit code: 274662 > > > > And I am focused on this exit code: 274662 > > > > What does 274662 mean? > > > > If the Scheduler gives me an error like "274662" rather than some > English, > > it's obvious to me the Scheduler is a POS and I should not use it. > > > > And of course, > > If I cannot run RMAN from Oracle Scheduler, I'll use cron. > > > > -Owen > > > > > > > > On 9/7/07, Jared Still wrote: > > > On 9/7/07, Owen Smith wrote: > > > > > > > > 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 > > > > > > > > The scheduler, though, errors out with an error which I see in a > trace > > > > file: > > > > > > > *** 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 > > > > > > > > > > > > Running external jobs from dbms_scheduler is much like running jobs > from > > > cron: > > > You must explicitly set the environment, as no environment is > inherited. > > > > > > See ML Notes *387451.1 and **389685.1.* > > > > > > > > > -- > > > Jared Still > > > Certifiable Oracle DBA and Part Time Perl Evangelist > > > > > > -- > http://www.freelists.org/webpage/oracle-l > > > ------=_Part_3943_2113151.1189239354257 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Befoe modifying did you check the permissions of files you did this?

chown root $ORACLE_HOME/bin/extjob
chmod 4750 $ORACLE_HOME/bin/extjob
chown root $ORACLE_HOME/rdbms/admin/externaljob.ora
chmod 640 $ORACLE_HOME/rdbms/admin/externaljob.ora

because by default those are the permissions, you should not have to do that manually

thanks

--
LSC

On 9/8/07, Owen Smith <owensmith99@gmail.com> wrote:
Oracle People,

Ravi's comments looked promising.

I looked for root.sh

bash sol oracle ~ 23 $
bash sol oracle ~ 23 $
bash sol oracle ~ 23 $ cd $ORACLE_BASE
bash sol oracle ~ 24 $ find . -name root.sh -print
./product/10r2/root.sh
bash sol oracle ~ 25 $
bash sol oracle ~ 25 $
bash sol oracle ~ 25 $
bash sol oracle ~ 25 $

I looked for evidence that it alters permissions of files related to
external jobs:

bash sol oracle ~ 25 $
bash sol oracle ~ 25 $
bash sol oracle ~ 25 $
bash sol oracle ~ 25 $
bash sol oracle ~ 25 $
bash sol oracle ~ 25 $ grep CHOWN ./product/10r2/root.sh
CHOWN=/bin/chown
      $CHOWN $ORACLE_OWNER $LBIN/`$ECHO $f | $AWK -F/ '{print $NF}'`
2>&1 2>> $LOG
$CHOWN $ORACLE_OWNER ${ORATAB}
CHOWN="/usr/bin/chown"
  CHOWN=/bin/chown
$CHOWN root $ORACLE_HOME/bin/nmo
$CHOWN root $ORACLE_HOME/bin/nmb
$CHOWN root  /var/tmp/.oracle
$CHOWN root  /tmp/.oracle
bash sol oracle ~ 26 $
bash sol oracle ~ 26 $
bash sol oracle ~ 26 $


I did not expect that it would.  I'm diligent about following
instructions when I install oracle.

Perhaps root.sh was enhanced by a quarterly patch.  I'm on an eval
license; I have
no access to support or quarterly patches.

Anyway, I took these steps to follow Ravi's suggestions:

-emctl stop agent
-emctl stop dbconsole
-lsnrctl stop
-SHUTDOWN IMMEDIATE

chown root $ORACLE_HOME/bin/extjob
chmod 4750 $ORACLE_HOME/bin/extjob
chown root $ORACLE_HOME/rdbms/admin/externaljob.ora
chmod 640 $ORACLE_HOME/rdbms/admin/externaljob.ora

-STARTUP
-lsnrctl start
-emctl start agent
-emctl start dbconsole


Result?

It worked.
I can now run shell scripts from the scheduler.
Also I'm pleased that the scripts run as the user I specify in
$ORACLE_HOME/rdbms/admin/externaljob.ora

For security reasons I don't want external jobs run as a privileged
user like oracle or root.

Thanks Ravi!

-Owen


On 9/7/07, Owen Smith <owensmith99@gmail.com> wrote:
> Hello people,
>
> I should have added this bit of information:
>
> "The script runs fine from oracle's crontab."
> "The script runs fine from a shell owned by oracle."
>
> I'm getting responses telling me to check my env variables and permissions
> which would be helpful to a UNIX novice.
>
> I have a feeling that no one is using the scheduler to run RMAN scripts.
>
> Tim Hall suggested I take a close look at these files:
>
> $ORACLE_HOME/rdbms/admin/externaljob.ora
> $ORACLE_HOME/bin/extJob
>
> Currently I'm setup like this:
>
>
> bash sol root /h/oracle/product/10r2/bin 31 #
> bash sol root /h/oracle/product/10r2/bin 31 # ll
> $ORACLE_HOME/rdbms/admin/externaljob.ora
> -rw-r--r--   1 root     dba           52 Sep  7 15:29
> /h/oracle/product/10r2/rdbms/admin/externaljob.ora
> bash sol root /h/oracle/product/10r2/bin 32 #
> bash sol root /h/oracle/product/10r2/bin 32 # cat
> $ORACLE_HOME/rdbms/admin/externaljob.ora
> # externaljob.ora
> run_user = rman
> run_group = rman
>
> bash sol root /h/oracle/product/10r2/bin 33 #
> bash sol root /h/oracle/product/10r2/bin 33 #
>
>
> bash sol root /h/oracle/product/10r2/bin 33 #
> bash sol root /h/oracle/product/10r2/bin 33 # ll $ORACLE_HOME/bin/ext*
> -rwsr-x---   1 rman     dba        30388 Sep 21  2006
> /h/oracle/product/10r2/bin/extjob*
> -rwsr-x---   1 rman     dba        30392 Sep 21  2006
> /h/oracle/product/10r2/bin/extjobo*
> -rwsr-x---   1 rman     dba        34468 Sep 21  2006
> /h/oracle/product/10r2/bin/extproc*
> -rwxr-xr-x   1 oracle   dba          300 Sep 21  2006
> /h/oracle/product/10r2/bin/extusrupgrade*
> bash sol root /h/oracle/product/10r2/bin 34 #
> bash sol root /h/oracle/product/10r2/bin 34 #
> bash sol root /h/oracle/product/10r2/bin 34 #
>
> On my system, the user 'nobody' has no shell so I cannot use nobody.
>
> I created a user named rman:
>
>
> bash sol root /h/oracle/product/10r2/bin 34 #
> bash sol root /h/oracle/product/10r2/bin 34 #
> bash sol root /h/oracle/product/10r2/bin 34 # su - rman
> Sun Microsystems Inc.   SunOS 5.10      Generic January 2005
> $
> $ id
> uid=220(rman) gid=220(rman)
> $
> $
> $ date
> Fri Sep  7 16:30:03 PDT 2007
> $
> $
>
> Jared points out that rman needs access to extproc:
>
> $ ls -la /h/oracle/product/10r2/bin/extproc
> -rwsr-x---   1 rman     dba        34468 Sep 21  2006
> /h/oracle/product/10r2/bin/extproc
> $
> $
>
>
> Here is a demo of rman running his script:
>
>
> bash sol root /h/oracle/product/10r2/bin 35 # su - rman
> Sun Microsystems Inc.   SunOS 5.10      Generic January 2005
> $
> $
> $ ls
> scripts
> $
> $
> $ scripts/tst.sh
> $
> $
> $ cat scripts/tst.sh
> #! /bin/sh
> /usr/bin/date > /tmp/tst.sh.out.txt 2>&1 &
> exit 0
>
> $
> $
> $ cat /tmp/tst.sh.out.txt
> Fri Sep  7 16:31:23 PDT 2007
> $
> $ rm /tmp/tst.sh.out.txt
> $
>
>
> I am focused on this error:
>
> ORA-27369: job of type EXECUTABLE failed with exit code: 274662
>
> And I am focused on this exit code: 274662
>
> What does 274662 mean?
>
> If the Scheduler gives me an error like "274662" rather than some English,
> it's obvious to me the Scheduler is a POS and I should not use it.
>
> And of course,
> If I cannot run RMAN from Oracle Scheduler, I'll use cron.
>
> -Owen
>
>
>
> On 9/7/07, Jared Still <jkstill@gmail.com> wrote:
> > On 9/7/07, Owen Smith < owensmith99@gmail.com> wrote:
> > >
> > > 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
> > >
> > > The scheduler, though, errors out with an error which I see in a trace
> > > file:
> > >
> > *** 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
> >
> >
> >
> > Running external jobs from dbms_scheduler is much like running jobs from
> > cron:
> > You must explicitly set the environment, as no environment is inherited.
> >
> > See ML Notes *387451.1 and **389685.1.*
> >
> >
> > --
> > Jared Still
> > Certifiable Oracle DBA and Part Time Perl Evangelist
> >
>
--
http://www.freelists.org/webpage/oracle-l



------=_Part_3943_2113151.1189239354257-- -- http://www.freelists.org/webpage/oracle-l