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/