You (oracle) are not allowed to use this program (crontab) crontab -l crontab -e run because of /etc/cron.allow

Hi,

I got ” You (oracle) are not allowed to use this program (crontab) ” error during crontab -l run.

 

Details of error are as follows. When I try to drop database in mount mode, i got the following error.

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

 

 

 

This error is related with the /etc/cron.allow file.

To solve this error you should add oracle or any other users that will use the Crontab into this file as follows.

[root@msdbadb01 home]# cat /etc/cron.allow
root
[root@msdbadb01 home]#

 

Add oracle user and save /etc/cron.allow

[root@msdbadb01 home]# vi /etc/cron.allow

[root@msdbadb01 home]# cat /etc/cron.allow
root
oracle
[root@msdbadb01 home]#

 

Now you can run the crontab -l command successfully as follows.

[MSDB1]/home/oracle $ crontab -l
00,15,30,45 * * * * sh /u01/app/oracle/admin/cron_jobs/clear_oracle_home.sh 
* * * * * /u01/app/oracle/admin/cron_jobs/alert_mail.sh > /u01/app/oracle/admin/cron_jobs/log/check_alertlog.txt

 

 

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/