Re: login.sql equivalent for RMAN

From: <TESTAJ3_at_nationwide.com>
Date: Wed, 29 Apr 2009 18:20:26 -0400
Message-ID: <OFA15E0736.EB7E3B3B-ON852575A7.007AB896_at_lnotes-gw.ent.nwie.net>

How about putting it in a shell script and getting the password from an external file and put unix variables in the script, I have some examples, if u email me direct tomorrow I will send some.

Joe
Sent from the crackberry, so please excuse the typos and terseness.

Thanks, joe

• Original Message ----- From: William Wagman [wjwagman_at_ucdavis.edu] Sent: 04/29/2009 02:25 PM MST To: Oracle-L Freelists <oracle-l_at_freelists.org> Subject: login.sql equivalent for RMAN

Greetings,

I am running Oracle 9.2.0.8.0 EE. Is there an equivalent to login.sql for RMAN such that I don't have to store passwords in my scripts? I have looked but am unable to find a solution. What I would like to be able to do, as I can do with SQL is something like create a file like RMAN_LOGIN.SQL -

define rman_user=usera
define rman_password=password

And then do something like

RMAN> connect target &&rman_user/&&rman_password_at_remote_db

Does anyone know how if this is possible and if so can you point me to the documentation?

Thanks.

Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman_at_ucdavis.edu
(530) 754-6208

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Apr 29 2009 - 17:20:26 CDT