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: v\:*
{behavior:url(#default#VML);} o\:* {behavior:url(#default#VML);} w\:*
{behavior:url(#default#VML);} .shape {behavior:url(#default#VML);}
st1\:*{behavior:url(#default#ieooui) } Then there is
something wrong with your environment. Have you tried using oraenv to set you
environment vs. setting the %ENV hash? In cron, it would look like this:
(export ORAENV_ASK=NO && export ORACLE_SID=test && . oraenv &&
/path/to/rman/script)
There are other environment variables that are set in oraenv.
Another question I have to ask is the DB running?
--
Ron Reidy
Lead DBA
Array BioPharma, Inc.
---------------------------------
From: joe bayer [mailto:[EMAIL PROTECTED]
Sent: Friday, March 23, 2007 4:25 PM
To: Reidy, Ron; RaviChandra Chelikam; [email protected]
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
---------------------------------
From: joe bayer [mailto:[EMAIL PROTECTED]
Sent: Friday, March 23, 2007 3:33 PM
To: Reidy, Ron; RaviChandra Chelikam; [email protected]
Subject: 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{ORACLE_HOME}=$ORACLE_HOME;
my $ORACLE_SID="test";
$ENV{ORACLE_SID}=test; # what is this? Shouldnt this read
$ENV{ORACLE_SID}=$ORACLE_SID or $ENV{ORACLE_SID}=test
my $backup_log = "/backup/backup_log.log";
open RMAN, "| /opt/oracle/product_10g/eratest/10.2/bin/rman target=sys/temp
log=$backup_log" or die "Can't pipe to $!";
print RMAN "exit\n";
close RMAN;
======
It works in command line, but when I put it into crontab job, I always get
===================
connected to target database (not started)
RMAN>
===================
The script does not recognize the sid, what can I do to fix it?
Thanks very much for your help.
---------------------------------
No need to miss a message. Get email on-the-go
with Yahoo! Mail for Mobile. Get started.
---------------------------------
size=2 width="100%" align=center>
This electronic message transmission is a PRIVATE communication which
contains information
which may be confidential or privileged. The information is intended to be for
the use of the individual
or entity named above. If you are not the intended recipient, please be aware
that any disclosure,
copying, distribution or use of the contents of this information is
prohibited. Please notify the sender
of the delivery error by replying to this message, or notify us by telephone
(877-633-2436, ext. 0),
and then delete it from your system.
---------------------------------
No need to miss a message. Get email on-the-go
with Yahoo! Mail for Mobile. Get started.
---------------------------------
TV dinner still cooling?
Check out "Tonight's Picks" on Yahoo! TV.
