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
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.
>
&
-
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
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
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
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
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
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,
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
-- [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
- 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,
> >
>
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
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
[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
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.
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
Sent by: cc:
[EMAIL PROTECTED] Subject: Cronjob
>
> 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
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/
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 * * * /
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
- 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
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
; > 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:
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
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
'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
)
> >
> >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
>
> >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
amoca"
lud.com.pe> cc: (cco: Ivan Llamoca/NOVASALUD)
Enviado por: Asunto:
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
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:
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
> -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
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
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]>
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
<[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
> >
]
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
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
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
ASALUD)
[EMAIL PROTECTED] Asunto: RE: C
"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
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
[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]
--
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
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
>
> ---
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
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
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
>
> --
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' >
lt;[EMAIL PROTECTED]>
cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group)
Subjec
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
53 matches
Mail list logo