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

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


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




More information about the CentOS mailing list