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