...in addition to what's been posted already:
Originally Posted by mazhar07
Please give me the exact procedure for creating and execution of cronjobs
It could increase self-reliance if instead you learn to troubleshoot this issue:
* /usr/bin/run-parts (if that is the "run-part" you are referring to) is used to drive cronjobs in the /etc/directory not cron spools for un/lesser-privileged users in /var/spool/cron,
- read the email in the "oracleuser" account as cron will send to either owner or root,
- if you use an external script then check if it is owned by "oracleuser" account and has the right mode for execution under that account else if you use a command ensure it is correct,
- check if the "oracleuser" account is not in /etc/cron.deny and if /etc/cron.deny does not exist that the account is in /etc/cron.allow if it exists,
- check your /etc/(r)syslog(-ng).conf where cron daemon messages are sent to (defaults to /var/log/cron IIRC) then check that file for any errors related to your "oracleuser" account,
- in /etc/aliases redirect email for the "oracleuser" user to a mail account of an unprivileged user to be read by a human (and not root!) then run 'newaliases', then try to run the cronjob and read the human users email,
* - in /etc/aliases email for system users is redirected to root and root email should be redirected as above to a mail account of an unprivileged user to be read by a human.
** If you encounter warnings, errors or AVC messages (SELinux, Auditd) then please be verbose posting and if necessary post the exact cronjob script or command line you use.