Re: "sqlplus orauser/orapasswd_at_SID" avoid writing passwords in shell scripts

As martin had mentioned you can use Oracle Secure password store, where in you can create a wallet. I have implemented this at a client side and it worked without any issues. You can check out post detailing setup steps

http://askdba.org/weblog/2009/09/using-oracle-wallet-to-execute-shell-scriptcron-without-hard-coded-oracle-database-password/

Cheers
Amit
http://askdba.org/weblog/

On Wed, Dec 2, 2009 at 5:40 AM, Sven Aluoor <aluoor_at_gmail.com> wrote:

> Hi folks
>
> I have here a Solaris box where i need to setup cronjob (with session
> to remote DB). On the remote DB i have no access, expect limited user
> via sqlplus.
>
> How to avoid putting passwords in shell scripts?
>
> cheers
> Sven
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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