Google it ....

Sunday, November 8, 2020

You (oracle) are not allowed to use this program (crontab)

 On one of our server we are trying to schedule some os script in cron but appears oracle user can't do that:


$ crontab -l
You (oracle) are not allowed to use this program (crontab)
See crontab(1) for more information

Solution :
This error is due to oracle don’t have access to crontab.
There are two files on server, to allow and deny access to crontab, Files are named as etc/cron.allow and /etc/cron.deny
check that if oracle user is present in cron.deny file. if it is present remove oracle user from cron.deny file and add oracle user to cron.allow file.
if the files "/etc/cron.allow" and "/etc/cron.deny" files are not present on server, we can create both files manually.
# cat /etc/cron.allow
root

So, I haved added oracle user to cron.allow file, file will look as follows:
# cat /etc/cron.allow
root
oracle

Now Oracle user able to access the crontab.
$ crontab -l
no crontab for oracle

No comments:

Post a Comment