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. $ crontab -l 0 8 * * * /export/home/oracle/scr

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

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 21 $ cat xyz_conn_monitor.sh /u02/app/oracle/product/8.1.7/bin/sqlplus user1/[EMAIL PROTECTED

RE: SQLPLUS with cronjob is giving problem

2003-09-16 Thread Mladen Gogala
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 cronjob. $ crontab -l 0 8 * * * /export/home/oracle/scripts/dba/.Schedulejobs

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

RE: SQLPLUS with cronjob is giving problem

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

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.lst 21 $ cat

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:

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-05 Thread lynxidajax
- 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 could I easy change this script? 0 18

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 to

Re: Cronjob

2002-04-25 Thread Jared Still
of 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 advance Roland

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 21 Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

RE: Cronjob

2002-04-25 Thread SARKAR, Samir
-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/log

Re: Cronjob

2002-04-25 Thread Jan Pruner
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 21 Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET

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 * * * /d31/appl/konto/bat/laddabilbo.sh

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/log

Re: Cronjob

2002-04-25 Thread cichomitiko
0 6 * * 6 /d31/appl/konto/bat/laddabilbo.sh /d31/appl/konto/log/laddabilbo.log 21 __ www.cichomitiko.cjb.net __ - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, April 25, 2002 1:43 PM Hallo, I would like to have this cronjob run only

Re: Cronjob

2002-04-25 Thread Ron Rogers
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 have this cronjob run only in saturday mornings at 6 am

Re: Cronjob

2002-04-25 Thread lynxidajax
- 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/log/laddabilbo.log 21 Thanks in advance

Re: Cronjob

2002-04-25 Thread Gene Sais
: +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 could I easy change this script? 0 18 * * * /d31/appl/konto/bat/laddabilbo.sh /d31/appl

RE: Cronjob

2002-04-25 Thread Mercadante, Thomas F
: +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 could I easy change this script? 0 18

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

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]

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 DBA [EMAIL

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 can tell me how to delete a job

RE: Cronjob

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

Re: Cronjob

2002-04-24 Thread Jared . Still
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 Roland man crontab -- -- Bill Shrek

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

RE: Cronjob

2002-04-24 Thread Karniotis, Stephen
: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 Anyway? ) Jared

RE: Cronjob

2002-04-24 Thread Marc Cure
: 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 Roland man crontab -- -- Bill Shrek Thater ORACLE

Re: Cronjob

2002-04-24 Thread Alex
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 Wed, 24 Apr 2002

RE: Cronjob

2002-04-24 Thread Sherman, Edward
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] cc: Subject:Re: Cronjob

RE: Cronjob

2002-04-24 Thread Sherman, Paul R.
] 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] wrote: Anyone whom can tell me how to delete a job

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 installed

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

Re: Cronjob

2002-04-24 Thread Suzy Vordos
] 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] wrote: Anyone

Re: Cronjob

2002-04-24 Thread Joe Testa
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] wrote: Anyone whom can tell me how to delete a job that is created by crontab. Thanks

RE: Cronjob

2002-04-24 Thread Ivan Llamoca
: Asunto: RE: Cronjob [EMAIL PROTECTED

Re: Cronjob

2002-04-24 Thread Rachel Carmichael
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] cc: Subject:Re: Cronjob

RE: Cronjob

2002-04-24 Thread Deshpande, Kirti
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 crontab

RE: Cronjob

2002-04-24 Thread Kimberly Smith
? ) 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 Wed, 24 Apr 2002, bill thater wrote: [EMAIL

Re: Cronjob

2002-04-24 Thread Jared Still
: [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! 1000 points if you can figure out why. ( guess I'm watching too much 'Whose Line Is It Anyway? ) Jared

Re: Cronjob

2002-04-24 Thread Jared Still
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] wrote: Anyone whom can tell me how

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 21 -recompile.sh #!/bin/ksh ## Program name : recompile.sh ## Purpose : Recompile Invalid Database

Re: Cronjob misbehaving

2002-03-22 Thread hemantchitale
] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Cronjob misbehaving

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' /ops/scripts

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 -Cron Entry 0 5

RE: Cronjob misbehaving

2002-03-22 Thread Simon Waibale
] 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 Hi all, Thanx

Re: Cronjob misbehaving

2002-03-22 Thread James J. Morrow
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 21 -recompile.sh #!/bin/ksh ## Program name : recompile.sh ## Purpose

RE: Cronjob misbehaving

2002-03-22 Thread Simon Waibale
, 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 21 -recompile.sh #!/bin/ksh ## Program name : recompile.sh