On 3/25/07, Reidy, Ron <[EMAIL PROTECTED]> wrote:
This tells me there is something not set in your environment. Have you
tried setting the environment like I specified?
Here's a handy method for getting the environment correct
in a script (DBI or otherwise) to run from cron when all
else see
od luck.
rr
From: joe bayer [mailto:[EMAIL PROTECTED]
Sent: Friday, March 23, 2007 9:13 PM
To: Reidy, Ron; RaviChandra Chelikam; dbi-users@perl.org
Subject: RE: help with my perl script
I I just installed the ORACLE 10.2.0.3 to another home, and re-run the
script, this time, e
@perl.org
Subject: RE: help with my perl script
Yes, DB is running. If I run
./test.sh, there is no problem.
The problem comes only when I put it in cron.
"Reidy, Ron" <[EMAIL PROTECTED]> wrote:
Then there is something wrong with your environment. Have you tried
using o
PROTECTED]>; "RaviChandra Chelikam" <[EMAIL
PROTECTED]>;
Sent: Friday, March 23, 2007 11:12 PM
Subject: RE: help with my perl script
>I I just installed the ORACLE 10.2.0.3 to another home, and re-run the
>script, this time, even perl itself stopped running.
>
-
From: joe bayer [mailto:[EMAIL PROTECTED]
Sent: Friday, March 23, 2007 4:25 PM
To: Reidy, Ron; RaviChandra Chelikam; dbi-users@perl.org
Subject: RE: help with my perl script
Thanks for your prompt response.
I tri
t;[EMAIL
PROTECTED]>;
Sent: Friday, March 23, 2007 9:27 PM
Subject: RE: help with my perl script
> Yes, DB is running. If I run
> ./test.sh, there is no problem.
>
> The problem comes only when I put it in cron.
>
>
>
> "Reidy, Ron" <[EMAIL
From: joe bayer [mailto:[EMAIL PROTECTED]
Sent: Friday, March 23, 2007 4:25 PM
To: Reidy, Ron; RaviChandra Chelikam; dbi-users@perl.org
Subject: RE: help with my perl script
Thanks for your prompt response.
I tried
$ENV{ORACLE_SID}=$ORACLE_SID or $ENV{ORACLE_SID}=test
ndra Chelikam; dbi-users@perl.org
Subject: RE: help with my perl script
Thanks for your prompt response.
I tried
$ENV{ORACLE_SID}=$ORACLE_SID or $ENV{ORACLE_SID}="test"
It did not work.
"Reidy, Ron" <[EMAIL PROTECTED]> wrote:
See below ...
__
bject: help with my perl script
Dear group, I know it is not DBI related problem, but it is hard to find
some one who knows perl, shell and Oracle.
I am trying to write a RMAN script,
==
#!/usr/bin/perl
my $ORACLE_HOME = "/opt/oracle/product_10g/test/10.2";
$ENV{ORAC
Le vendredi 23 mars 2007 à 14:33 -0700, joe bayer a écrit :
> my $ORACLE_SID="test";
> $ENV{ORACLE_SID}=test;
Could this be your culprit ? Try with either
$ENV{ORACLE_SID}="test";
or
$ENV{ORACLE_SID}=$ORACLE_SID;
--
Olivier
See below ...
From: joe bayer [mailto:[EMAIL PROTECTED]
Sent: Friday, March 23, 2007 3:33 PM
To: Reidy, Ron; RaviChandra Chelikam; dbi-users@perl.org
Subject: help with my perl script
Dear group, I know it is not DBI related problem, but it is hard to
Dear group, I know it is not DBI related problem, but it is hard to find some
one who knows perl, shell and Oracle.
I am trying to write a RMAN script,
==
#!/usr/bin/perl
my $ORACLE_HOME = "/opt/oracle/product_10g/test/10.2";
$ENV{ORACLE_HOME}=$ORACLE_HOME;
my $ORACLE_SID="test";
$ENV{ORAC
Cute, about the rabbits. :-)
-Will
> -Original Message-
> From: David Nicol [mailto:[EMAIL PROTECTED]
> Sent: Wednesday 23 August 2006 17:28
> To: Rutherdale, Will
> Cc: dbi-users@perl.org
> Subject: Re: Help with my perl script
>
>
> On 8/23/06, Rutherd
On 8/23/06, Rutherdale, Will <[EMAIL PROTECTED]> wrote:
Again, I recommend simply using fork(), in a loop.
a rabbit doesn't need a loop...
$start_time = time + 10;
... # one process
fork; # two here
fork; # four here
fork; # eight here
fork; # 16
fork;
> Sent: Wednesday 23 August 2006 16:48
> To: Stephen Carville
> Cc: dbi-users@perl.org; joe bayer
> Subject: Re: Help with my perl script
>
>
> On 8/23/06, Stephen Carville <[EMAIL PROTECTED]> wrote:
> >
> > joe bayer wrote:
> > > Group,
> > >
On 8/23/06, Stephen Carville <[EMAIL PROTECTED]> wrote:
joe bayer wrote:
> Group,
>
> I am trying to write a load testing script.
>
> The script goes like this: ++ my $j =
> 0; while ($j < 300) { $dbh[$j] = DBI->connect (
> "dbi:Oracle:$instance[$i]", "$username[$
joe bayer wrote:
Group,
I am trying to write a load testing script.
The script goes like this: ++ my $j =
0; while ($j < 300) { $dbh[$j] = DBI->connect (
"dbi:Oracle:$instance[$i]", "$username[$i]", "$passwd[$i]", {
PrintError => 1, RaiseError => 1, AutoCommit =
arate
processes. The child code can then connect to DBI and run your testing
suite.
-Will
> -Original Message-
> From: joe bayer [mailto:[EMAIL PROTECTED]
> Sent: Wednesday 23 August 2006 14:05
> To: dbi-users@perl.org
> Subject: Help with my perl script
>
>
> G
Group,
I am trying to write a load testing script.
The script goes like this:
++
my $j = 0;
while ($j < 300)
{
$dbh[$j] = DBI->connect ( "dbi:Oracle:$instance[$i]",
"$username[$i]",
"$passwd[$i]",
{
19 matches
Mail list logo
