RE: help with my perl script
- From: Ron.Reidy@xxxxxxxxxxxxxxxxxx (Ron Reidy)
- Date: Fri, 23 Mar 2007 16:10:10 -0600
See below ...
________________________________
From: joe bayer [mailto:joebayerii@xxxxxxxxx]
Sent: Friday, March 23, 2007 3:33 PM
To: Reidy, Ron; RaviChandra Chelikam; dbi-users@xxxxxxxx
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? Shouldn't 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
<http://us.rd.yahoo.com/evt=43910/*http:/mobile.yahoo.com/mail%0d%0a>
with Yahoo! Mail for Mobile. Get started.
<http://us.rd.yahoo.com/evt=43910/*http:/mobile.yahoo.com/mail%0d%0a>
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.
- Follow-Ups:
- RE: help with my perl script
- From: Joe Bayer
- RE: help with my perl script
- References:
- RE: Internal Error while compiling Pro*C program
- From: Ron Reidy
- help with my perl script
- From: Joe Bayer
- RE: Internal Error while compiling Pro*C program
- Prev by Date: help with my perl script
- Next by Date: Re: help with my perl script
- Previous by thread: help with my perl script
- Next by thread: RE: help with my perl script
- Index(es):
Relevant Pages
|
|
