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" <Ron.Reidy@xxxxxxxxxxxxxxxxxx> 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) } 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
with Yahoo! Mail for Mobile. Get started.


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

Relevant Pages

  • RE: help with my perl script
    ... help with my perl script ... I am trying to write a RMAN script, ... sender of the delivery error by replying to this message, or notify us by ...
    (perl.dbi.users)
  • RE: help with my perl script
    ... help with my perl script ... I am trying to write a RMAN script, ... with Yahoo! ... Please notify the sender ...
    (perl.dbi.users)
  • [NEWS] IBM Informix Web DataBlade Local Root by Design
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... that ease development of "intelligent", interactive, Web-enabled database ... person who has access to change the Perl script. ...
    (Securiteam)
  • my perl script for ripping mp3s...aka MP3scRIPt
    ... This is a Perl script to convert audio cd tracks to mp3s. ... Possibly root privs to access the cdrom device ... - this is mainly a problem on 'variety cds', mp3 files suffering from this ill ...
    (comp.unix.bsd.freebsd.misc)
  • RE: help with my perl script
    ... So, obviously, perl is ... working and so is your script. ... and recovery and RMAN documents. ... Do not set your environment using the %ENV hash - use oraenv. ...
    (perl.dbi.users)