Re: "sqlplus orauser/orapasswd@SID" avoid writing passwords in shell scripts

  • From: Amit DBA <piyush.oracledba@xxxxxxxxx>
  • To: aluoor@xxxxxxxxx
  • Date: Thu, 3 Dec 2009 22:56:05 +0800

Hi Sven,

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@xxxxxxxxx> 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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>

Other related posts: