2 Dec
2009
2 Dec
'09
12:15 a.m.
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/schedule...
nate