I have created an online backup script on Sun Solaris. Then I created a crontab from oracle to executed at 00:00 everyday. But it is not executing this job. Whereas the jobs created as root user are executing properly. But jobs created as oracle user are not executing.
I tried to create /.profile for root, to set PATH for oracle directory. But looks like it is not setting this PATH.
My questions are:
1. How can I make jobs created as oracle user get executed?
2. How can I update root's PATH in order to add oracle directory, so that I can execute this script as root?
Any suggestions are highly appreciated.