Joe et al
Sounds like a permissions problem
Which user was used to install 10.2.0.3?
What happens when you use that same user ro install and run perl scripts?
M-
---------------------------------------------------------------------------
This e-mail message (including attachments, if any) is intended for the use of
the individual or entity to which it is addressed and may contain information
that is privileged, proprietary , confidential and exempt from disclosure. If
you are not the intended recipient, you are notified that any dissemination,
distribution or copying of this communication is strictly prohibited.
---------------------------------------------------------------------------
Le présent message électronique (y compris les pièces qui y sont annexées, le
cas échéant) s'adresse au destinataire indiqué et peut contenir des
renseignements de caractère privé ou confidentiel. Si vous n'êtes pas le
destinataire de ce document, nous vous signalons qu'il est strictement interdit
de le diffuser, de le distribuer ou de le reproduire.
----- Original Message -----
From: "joe bayer" <[EMAIL PROTECTED]>
To: "Reidy, Ron" <[EMAIL PROTECTED]>; "RaviChandra Chelikam" <[EMAIL
PROTECTED]>; <[email protected]>
Sent: Friday, March 23, 2007 11:12 PM
Subject: RE: help with my perl script
>I I just installed the ORACLE 10.2.0.3 to another home, and re-run the
>script, this time, even perl itself stopped running.
> =======================
> The script is like this:
> #!/usr/bin/perl
>
> my $ORACLE_HOME = "/opt/oracle/product_10g_2";
> $ENV{ORACLE_HOME}=$ORACLE_HOME;
> my $ORACLE_SID="test";
> $ENV{ORACLE_SID}=$ORACLE_SID;
> my $backup_log = "backup_log.log";
>
> open RMAN, "| /opt/oracle/product_10g_2/bin/rman target=sys/temp" or die
> "Can't pipe to $!";
> print RMAN "startup nomount\n";
> print RMAN "exit\n";
> close RMAN;
> =====================
>
> [EMAIL PROTECTED] dba]$ ps -eaf|grep pmon
> ora92 8178 1 0 22:31 ? 00:00:00 ora_pmon_test
> ora92 10212 1 0 23:04 ? 00:00:00 ora_pmon_test
>
> The SID did passed, but somehow this "test" is different from that "test",
> how can that be possible?
>
> Thanks for your help.
>
>
> "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? 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.
>
>
> ---------------------------------
> 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.
>
>
>
>
> ---------------------------------
> Be a PS3 game guru.
> Get your game face on with the latest PS3 news and previews at Yahoo! Games.
