I am trying to create a crontab job for my Oracle logon. I added oracle to the cron.allow file but when I try the crontab -e I get:

Xlib:connection to 0:0 refused by server
Xlib:Client is not authorized to connect to server
Error:Cannot open display "0:0"
crontab temporary file empty

when I crontab -e as root I dont have this issue... also is there a way instead of creating a crontab job under user oracle can I add a cron job to root's crontab and run it as oracle???

Any help is greatly appreciated.. Thanks

depends on your OS.

If you are using linux, as root create a /var/spool/cron/<OracleUserName> file with the details of the job that you want to run. chown the file to root:<OracleUsersPrimaryGroup>, chmod it 0600 and restart the cron daemon (possibly /etc/rc.d/init.d/vixiecron

The error message you have given, however, does not relate to crontab directly. It is the usual error you get when you try and run an X program as a different user to the one that started X. Are you trying this in an xterm after having su'ed to the oracle user? Does the oracle user have a valid shell in /etc/passwd? does the oracle user have a valid (readable and writeable by the oracle user) home directory in /etc/passwd?

What OS? (output from uname -a)

as root user try:

Hi,

You may try the following:

EDITOR=vi
export EDITOR
crontab -e

<<Enter crontabs>>

Ctrl q! <<--- Command to end crontab file

I don't think there would be any problem, incase the problem still persists, you may use what wempy has mentioned i.e. /var/spool/cron/crontabs

Regards,
Sumedha