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

[CNewtonne <cne...@ya...>]

<!-- 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)