[CentOS] best practises for avoiding to write passwords in shell scripts (example sqlplus from Oracle)

Tue Dec 1 23:15:55 UTC 2009
nate <centos at linuxpowered.net>

nate wrote:
> Sven Aluoor wrote:
>> Hi folks
>>
>> I have here a CentOS box where i need to setup cronjob (with session
>> to remote Oracle instance). On the remote DB i have no access, expect
>> limited user.
>
> With sqlplus and oracle I pretty much always ran scripts
> as sysdba

If this doesn't work then you can try scheduling the jobs
from inside oracle itself using the oracle scheduler, run as
your user, wouldn't expect any password is needed

http://www.oracle.com/technology/products/database/scheduler/htdocs/scheduler_fov.html



nate