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
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
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
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
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
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
-
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
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:
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,
- 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
-- [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
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
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
-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
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
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
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
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
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
-
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
: +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
: +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
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
[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]
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
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
)
[EMAIL PROTECTED] Asunto: RE: Cronjob
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
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
: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
:
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
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
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
]
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
-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
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
]
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
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
: Asunto: RE: Cronjob
[EMAIL PROTECTED
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
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
? )
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
: [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
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
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
]
cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group)
Subject: Cronjob misbehaving
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
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
] 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
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
, 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
51 matches
Mail list logo