Re: [Ssh-sftp-perl-users] Puzzling Oracle/SSH Issue
Brought to you by:
dbrobins
|
From: Matthew J. S. <vag...@ya...> - 2006-05-02 19:21:43
|
--- 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
|