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 _______________________________________________ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
