[Ssh-sftp-perl-users] Puzzling Oracle/SSH Issue
Brought to you by:
dbrobins
|
From: CNewtonne <cne...@ya...> - 2006-05-02 18:42:07
|
<!-- 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)
|