You mustn't forgot to set the complete oracle environment for the oracle user. That means SID, PATH, ORACLE_HOME etc. because cron does not set it up.
The shortest way is to calll the ~/.profile as the first command in your backup script.
Also try to search this forum as this topic has been discussed many times this year.




Reply With Quote