Re: Alternatives to RMAN cleartext password in batch file for backups?
From: Jamey Johnston <jj_at_jameyj.com>
Date: Sun, 24 Apr 2011 12:30:23 -0500
Message-Id: <207609EE-808A-400D-A1B2-54D20C5F4E5D_at_jameyj.com>
Looks like you are using Windows. Might be able to use Powershell - http://bittangents.com/2010/03/20/powershell-script-encrypting-decrypting-a-string-function-encrypt-string/
Date: Sun, 24 Apr 2011 12:30:23 -0500
Message-Id: <207609EE-808A-400D-A1B2-54D20C5F4E5D_at_jameyj.com>
Looks like you are using Windows. Might be able to use Powershell - http://bittangents.com/2010/03/20/powershell-script-encrypting-decrypting-a-string-function-encrypt-string/
jbj2
-- Jamey Johnston On Apr 23, 2011, at 8:05 PM, Bill Myers <bwmyers_at_gmail.com> wrote:Received on Sun Apr 24 2011 - 12:30:23 CDT
> Hi all,
> I have the following commands in a batch file scheduled for daily execution:
>
> set oracle_sid=mydatadb
> rman target / catalog mycatusr/mycatpwd_at_mycatdb script Daily_Backup >> backup.log
>
> My organization requires the catalog password (mycatpwd) above to be encrypted and not stored as clear text in any other file or environment variable. How can I still use this batch file for scheduled backups without providing a clear text password?
>
> The only option I can think of is to compile the commands into a binary executable. Any other ideas besides that?
>
> Thanks in advance.
> Bill
-- http://www.freelists.org/webpage/oracle-l