RE: SQLPLUS with cronjob is giving problem

2003-09-17 Thread Paula_Stankus
Title: RE: SQLPLUS with cronjob is giving problem  Dear Sami, As a matter of fact whatever environ. values are set in your .profile are not in operation through a crontab process.  To deal with this issue we do something that I have seen others do as well.  We basically create a

Re: SQLPLUS with cronjob is giving problem

2003-09-17 Thread H elp_me
TECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: SQLPLUS with cronjob is giving problem >Date: Tue, 16 Sep 2003 06:04:25 -0800 > >Hi List > > >I am trying to automate "Number of Oracle Connections" >using cronjob. > &

RE: SQLPLUS with cronjob is giving problem

2003-09-16 Thread Rothouse, Michael
- Sent: Tuesday, September 16, 2003 10:04 AM To: Multiple recipients of list ORACLE-L Hi List I am trying to automate "Number of Oracle Connections" using cronjob. $ crontab -l 0 8 * * * /export/home/oracle/scripts/dba/.Schedulejobs/xyz_conn_monitor.sh > /tmp/xyz_conn_monitor.ls

RE: SQLPLUS with cronjob is giving problem

2003-09-16 Thread Mercadante, Thomas F
er of Oracle Connections" using cronjob. $ crontab -l 0 8 * * * /export/home/oracle/scripts/dba/.Schedulejobs/xyz_conn_monitor.sh > /tmp/xyz_conn_monitor.lst 2>&1 $ cat xyz_conn_monitor.sh /u02/app/oracle/product/8.1.7/bin/sqlplus user1/[EMAIL PROTECTED] @/export/home/oracle/scrip

RE: SQLPLUS with cronjob is giving problem

2003-09-16 Thread Jamadagni, Rajendra
Title: RE: SQLPLUS with cronjob is giving problem oops ... someone forgot to run . ./.profile in the sh file ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are

RE: SQLPLUS with cronjob is giving problem

2003-09-16 Thread Mladen Gogala
On > Behalf Of Oracle DBA > Sent: Tuesday, September 16, 2003 10:04 AM > To: Multiple recipients of list ORACLE-L > Subject: SQLPLUS with cronjob is giving problem > > > Hi List > > > I am trying to automate "Number of Oracle Connections" > using cro

SQLPLUS with cronjob is giving problem

2003-09-16 Thread Oracle DBA
Hi List I am trying to automate "Number of Oracle Connections" using cronjob. $ crontab -l 0 8 * * * /export/home/oracle/scripts/dba/.Schedulejobs/xyz_conn_monitor.sh > /tmp/xyz_conn_monitor.lst 2>&1 $ cat xyz_conn_monitor.sh /u02/app/oracle/product/8.1.7/bin/sqlplus us

e: locks, not cronjob!

2002-05-10 Thread Sherman, Paul R.
Hello, Sorry about the screw-up in the subject. It should be "locks". Dreaming about the week-end, I suppose. Thank you, Paul Sherman DBAElcom, Inc. voice - 781-501-4143 (direct #) fax- 781-278-8341 (secure) email - [EMAIL PROTECTED] -Original Message- Sent: Friday, May 10,

RE: Cronjob

2002-05-10 Thread Sherman, Paul R.
Hello, Has anyone ever tried setting dml_locks to zero or disabling table locks on an OPS (2-node, 8.1.7.2.1, 32-bit; HP 11.0, 64-bit) as a way of reducing contention and freeing up resources ? We currently use 7,250 dml_locks/instance. Oracle's OPS Admin manual (8i) had the following to say: Ob

Re: Cronjob

2002-05-05 Thread Steven Lembark
-- [EMAIL PROTECTED] > Dear Tom, > Would you send me example of the script. Because I'm new with VMS > environment. > > thanks in advance, This is gonna be living hell to deal with in DCL. Suggestion: grab a copy of perl5 and use Schedule::Cron to cycle the jobs with the vms-ish file system t

Re: Cronjob

2002-05-05 Thread lynxidajax
- 957 6028 > > EPABX : +44 (0) 115 - 957 6418 Ext. 76028 > > Fax : +44 (0) 115 - 957 6018 > > > > > > -Original Message- > > Sent: 25 April 2002 12:43 > > To: Multiple recipients of list ORACLE-L > > > > > > Hallo, > > >

RE: Cronjob

2002-04-25 Thread Mercadante, Thomas F
ROTECTED] > [EMAIL PROTECTED] > Phone : +44 (0) 115 - 957 6028 > EPABX : +44 (0) 115 - 957 6418 Ext. 76028 > Fax : +44 (0) 115 - 957 6018 > > > -Original Message- > Sent: 25 April 2002 12:43 > To: Multiple recipients of list ORACLE-L > > > Hal

RE: Cronjob

2002-04-25 Thread Marc Cure
tching too much 'Whose Line Is It Anyway?" ) Jared Alex <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 04/24/2002 10:07 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: Cronjob

Re: Cronjob

2002-04-25 Thread Gene Sais
[EMAIL PROTECTED] > Phone : +44 (0) 115 - 957 6028 > EPABX : +44 (0) 115 - 957 6418 Ext. 76028 > Fax : +44 (0) 115 - 957 6018 > > > -Original Message- > Sent: 25 April 2002 12:43 > To: Multiple recipients of list ORACLE-L > > > Hallo, > &g

Re: Cronjob

2002-04-25 Thread lynxidajax
EPABX : +44 (0) 115 - 957 6418 Ext. 76028 > Fax : +44 (0) 115 - 957 6018 > > > -Original Message- > Sent: 25 April 2002 12:43 > To: Multiple recipients of list ORACLE-L > > > Hallo, > > I would like to have this cronjob run only in saturday mornings at 6 am. How &

Re: Cronjob

2002-04-25 Thread Ron Rogers
re. States that the job will run at 0 minutes after the hour of 6 on day 6 ,all days of the month, all months of the year. If you want to run the job only once use the "at" command. Ron ROR mª¿ªm >>> [EMAIL PROTECTED] 04/25/02 07:43AM >>> Hallo, I would like to

Re: Cronjob

2002-04-25 Thread Cherie_Machler
Sent by: cc: [EMAIL PROTECTED] Subject: Cronjob

Re: Cronjob

2002-04-25 Thread cichomitiko
> > I would like to have this cronjob run only in saturday mornings at 6 am. How could I easy change this script? > > 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh >/d31/appl/konto/log/laddabilbo.log > 2>&1 > > Thanks in advance > > Roland > > -- > Please s

RE: Cronjob

2002-04-25 Thread Thomas, Kevin
Use vi. -Original Message- Sent: 25 April 2002 12:43 To: Multiple recipients of list ORACLE-L Hallo, I would like to have this cronjob run only in saturday mornings at 6 am. How could I easy change this script? 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh >/d31/appl/konto/

Re: Cronjob

2002-04-25 Thread Rachel Carmichael
man cron man crontab you really need to do some research on your questions before posting --- [EMAIL PROTECTED] wrote: > Hallo, > > I would like to have this cronjob run only in saturday mornings at 6 > am. How could I easy change this script? > > 0 18 * * * /

Re: Cronjob

2002-04-25 Thread Jan Pruner
gt; I would like to have this cronjob run only in saturday mornings at 6 am. > How could I easy change this script? > > 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh > >/d31/appl/konto/log/laddabilbo.log 2>&1 > > Thanks in advance > > Roland -- Please see the official

RE: Cronjob

2002-04-25 Thread SARKAR, Samir
- 957 6018 -Original Message- Sent: 25 April 2002 12:43 To: Multiple recipients of list ORACLE-L Hallo, I would like to have this cronjob run only in saturday mornings at 6 am. How could I easy change this script? 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh >/d31/a

Cronjob

2002-04-25 Thread Roland . Skoldblom
Hallo, I would like to have this cronjob run only in saturday mornings at 6 am. How could I easy change this script? 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh >/d31/appl/konto/log/laddabilbo.log 2>&1 Thanks in advance Roland -- Please see the official ORACLE-L

Re: Cronjob

2002-04-24 Thread Jared Still
; > Alex <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 04/24/2002 10:07 AM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> cc: > > Subject:

Re: Cronjob

2002-04-24 Thread Jared Still
gure out why. > ( guess I'm watching too much 'Whose Line Is It Anyway?" ) > > Jared > > > > > > Alex <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 04/24/2002 10:07 AM > Please respond to ORACLE-L > > > To: Multiple reci

Re: Cronjob

2002-04-24 Thread Jared Still
7 > > > -Original Message- > > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > > Sent: Wednesday, April 24, 2002 4:19 PM > > To: Multiple recipients of list ORACLE-L > > Subject:Re: Cronjob > > > > crontab -e is bad! > > > > 1

RE: Cronjob

2002-04-24 Thread Kimberly Smith
'Whose Line Is It Anyway?" ) Jared Alex <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 04/24/2002 10:07 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: Cronjob crontab -e On

RE: Cronjob

2002-04-24 Thread Deshpande, Kirti
) > > > >Jared > > > > > > > > > > > >Alex <[EMAIL PROTECTED]> > >Sent by: [EMAIL PROTECTED] > >04/24/2002 10:07 AM > >Please respond to ORACLE-L > > > > > >To: Multiple recipients of list O

Re: Cronjob

2002-04-24 Thread Rachel Carmichael
> > >Jared > > > > > > > > > > > >Alex <[EMAIL PROTECTED]> > >Sent by: [EMAIL PROTECTED] > >04/24/2002 10:07 AM > >Please respond to ORACLE-L > > > > > >To: Multiple recipients of list ORACLE-L > &l

RE: Cronjob

2002-04-24 Thread Ivan Llamoca
amoca" lud.com.pe> cc: (cco: Ivan Llamoca/NOVASALUD) Enviado por: Asunto:

Re: Cronjob

2002-04-24 Thread Joe Testa
t; >Jared > > > > > >Alex <[EMAIL PROTECTED]> >Sent by: [EMAIL PROTECTED] >04/24/2002 10:07 AM >Please respond to ORACLE-L > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >cc: >Subject:R

Re: Cronjob

2002-04-24 Thread Suzy Vordos
ay?" ) > > Jared > > Alex <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 04/24/2002 10:07 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:

RE: Cronjob

2002-04-24 Thread Scott . Shafer
Come on, Jared, its more fun to: crontab < /dev/null Scott Shafer San Antonio, TX 210-581-6217 > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, April 24, 2002 4:19 PM > To: Multiple recipients of list ORACLE-L > Subject

RE: Cronjob

2002-04-24 Thread Steve McClure
> -e Edit the current crontab using the editor specified by the >VISUAL or EDITOR environment variables. The specified editor must >edit the file in place; any editor that unlinks the file and >recreates it cannot be used. After you exit from the editor, the >modified crontab will be instal

RE: Cronjob

2002-04-24 Thread Sherman, Paul R.
AIL PROTECTED]> Sent by: [EMAIL PROTECTED] 04/24/2002 10:07 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: Cronjob crontab -e On Wed, 24 Apr 2002, bill thater wrote: > [EMAIL PROTECTED] w

RE: Cronjob

2002-04-24 Thread Sherman, Edward
f you can figure out why. ( guess I'm watching too much 'Whose Line Is It Anyway?" ) Jared Alex <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 04/24/2002 10:07 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>

Re: Cronjob

2002-04-24 Thread Alex
g too much 'Whose Line Is It Anyway?" ) > > Jared > > > > > > Alex <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 04/24/2002 10:07 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE

RE: Cronjob

2002-04-24 Thread Marc Cure
<[EMAIL PROTECTED]> cc: Subject:Re: Cronjob crontab -e On Wed, 24 Apr 2002, bill thater wrote: > [EMAIL PROTECTED] wrote: > > > Anyone whom can tell me how to delete a job that is created by crontab. > > > > Thanks in advance > >

RE: Cronjob

2002-04-24 Thread Karniotis, Stephen
] Web:www.compuware.com -Original Message- Sent: Wednesday, April 24, 2002 5:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: Cronjob crontab -e is bad! 1000 points if you can figure out why. ( guess I'm watching too much 'Whose Line Is It An

RE: Cronjob

2002-04-24 Thread Godlewski, Melissa
Title: RE: Cronjob A wrong keystroke could blow away the entire crontab file by accident.  %:| -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 5:19 PM To: Multiple recipients of list ORACLE-L Subject: Re: Cronjob crontab -e is

Re: Cronjob

2002-04-24 Thread Jared . Still
list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: Cronjob crontab -e On Wed, 24 Apr 2002, bill thater wrote: > [EMAIL PROTECTED] wrote: > > > Anyone whom can tell me how to delete a job that is created by crontab. > > > > Thanks in adva

RE: Cronjob

2002-04-24 Thread Ivan Llamoca
ASALUD) [EMAIL PROTECTED] Asunto: RE: C

RE: Cronjob

2002-04-24 Thread Scott . Shafer
"man kill" Scott Shafer San Antonio, TX 210-581-6217 > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, April 24, 2002 9:29 AM > To: Multiple recipients of list ORACLE-L > Subject: Cronjob > > Anyone whom

Re: Cronjob

2002-04-24 Thread Alex
crontab -e On Wed, 24 Apr 2002, bill thater wrote: > [EMAIL PROTECTED] wrote: > > > Anyone whom can tell me how to delete a job that is created by crontab. > > > > Thanks in advance > > > > > > Roland > > > > > > man crontab > > > -- > -- > Bill "Shrek" Thater ORACLE DB

Re: Cronjob

2002-04-24 Thread bill thater
[EMAIL PROTECTED] wrote: > Anyone whom can tell me how to delete a job that is created by crontab. > > Thanks in advance > > > Roland > > man crontab -- -- Bill "Shrek" Thater ORACLE DBA [EMAIL PROTECTED] --

Cronjob

2002-04-24 Thread Roland . Skoldblom
Anyone whom can tell me how to delete a job that is created by crontab. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Cronjob misbehaving

2002-03-22 Thread Simon Waibale
CLE_HOME, $PATH, etc.) -- James Simon Waibale wrote: > > Hi all, > Thanx for all the good work U R doing for Oracle. > I have a misbehaving cronjob > > -Cron Entry > 0 5 * * * /usr/scripts/recompile.sh > /ops/scripts/recompile.log 2>&1 > > ---

Re: Cronjob misbehaving

2002-03-22 Thread James J. Morrow
etc.) -- James Simon Waibale wrote: > > Hi all, > Thanx for all the good work U R doing for Oracle. > I have a misbehaving cronjob > > -Cron Entry > 0 5 * * * /usr/scripts/recompile.sh > /ops/scripts/recompile.log 2>&1 > > -recompile

RE: Cronjob misbehaving

2002-03-22 Thread Simon Waibale
t; <[EMAIL PROTECTED]> 22/03/2002 04:18 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Cronjob misbehaving

Re: Cronjob misbehaving

2002-03-22 Thread Connor McDonald
Set your Oracle environment as the first thing in the cron job (typically by setting ORACLE_SID and calling oraenv) hth connor --- Simon Waibale <[EMAIL PROTECTED]> wrote: > Hi all, > Thanx for all the good work U R doing for Oracle. > I have a misbehaving cronjob > > --

RE: Cronjob misbehaving

2002-03-22 Thread Hallas John
Title: RE: Cronjob misbehaving It looks as if your ORACLE_HOME is not being set up. Try either or both of the following 1) Amend your cron job to look like the following (I assume you are running this as user oracle) 0 5 * * * su - oracle 'usr/scripts/recompile.sh' >

Re: Cronjob misbehaving

2002-03-22 Thread hemantchitale
lt;[EMAIL PROTECTED]> cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subjec

Cronjob misbehaving

2002-03-22 Thread Simon Waibale
Hi all, Thanx for all the good work U R doing for Oracle. I have a misbehaving cronjob -Cron Entry 0 5 * * * /usr/scripts/recompile.sh > /ops/scripts/recompile.log 2>&1 -recompile.sh #!/bin/ksh ## Program name : recompile.sh ## Purpose : Recompile Invali