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? 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.
