Re: [Ssh-sftp-perl-users] Puzzling Oracle/SSH Issue

[Matthew J. S. <vag...@ya...>]

--- CNewtonne <cne...@ya...> wrote:

> <!-- DIV {margin:0px} -->RMAN or recovery manager is
> a server tool Oracle uses to managed backup and
> recovery. Using an ssh connection, I've successfully
> automated the process of runing RMAN cmds remotely.
> It basically reads a local file where the perl code
> is running, dumps it into a scaler variable which is
> eventually echoed to a file on the remote server.
> RMAN gets invoked to execute this file. This code
> was tested and worked on 50 nodes without a glitch.
> However, it is failing on this node as seen below.
> For the life of me, I can not explain this behavior.
> It is either I'm misreading the issue or there is
> something about ssh that I do not know yet. 
>  
>  These are the facts... 
>  1) RMAN code (test.rmn): 
>  connect target '; 
>  exit 
>  2) when logged in interactively vis an ssh
> connection ,this command works just fine 
>  rmn cmdfile=test.rmn 
>   
>  3) However, this command errors out  (same error
> using this module)
>  ssh 10.10.10.10   "export ORACLE_SID=prod2;.
> /home/oracle/.profile;\  $ORACLE_HOME/bin/rman
> cmdfile=test.rmn"  
>   
>  RMAN> connect target /; 
>  2>   
>  3> allocate channel for maintenance type disk ; 
>  4>  
>  RMAN-00571:
>
===========================================================
> 
>  RMAN-00569: =============== ERROR MESSAGE STACK
> FOLLOWS =============== 
>  RMAN-00571:
>
===========================================================
> 
>  ORA-00210: cannot open the specified controlfile 
>  ORA-00202: controlfile: '/dev/rprod1_0128_003' 
>  ORA-27041: unable to open file 
>  Additional information: 7 
>   
>  The DB is up and running, all control files are
> accessible (physically exist and permissions are
> good), no msgs in alert or trace files to support a
> CF access issue. The above command works fine if ran
> against a non-rac DB on same host. The DB causing
> the issue is rac on HACMP.  
> I have confirmed the same issue occurs running
> SQLPLUS as well. For some reason, invoking these
> utils remotly causes them to fail to read from  the
> DB files. 
>   
>  I will pay a milltion dollar for anyone who
> provides a significant lead (kidding)
> 
> 

When I see a problem like this, I immediately say that
it's the environment.  Log in interactivly and check
the output of env against what the following returns
when you insert it into your code.

"export ORACLE_SID=prod2;. /home/oracle/.profile;\ 
env" 

The other option is to use a shell style interface. I
posted an example on the list.  Since it's only few
commands you are executing, it should be pretty simple
to setup.

http://sourceforge.net/mailarchive/forum.php?thread_id=10084037&forum_id=36514 

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com