-
probelm scheduling thru cron job "ORPHAN (no passwd entry)"
i have a probelm scheduling (export dmp)exp.exe ,i edited crontab -e and added the following
38 15 * * * . /home/oracle/scripts/export.sh &
now if i check /var/log/cron,i get logs like
"" (tmp.29581) ORPHAN (no passwd entry)""
no info found in tmp.29581
the export.sh is all fine &will work when executed manually however does't trigger when scheduled
however i checked with a dummy script called a.sh which creates
an empty file & it worked
plz help
regards,
natraj.dba
-
A couple of initial questions:
Why the & at the end of the cron entry?
Is your environment (ORACLE_HOME, ORACLE_SID,PATH) set within the script as cron runs in a very limited environment of it's own.
If I have to choose between two evils, I always like to choose the one I haven't tried yet.
-
Thank u Mr.Ken
as u told i have add the env variables and its working now and
one more thing msg in the /var/log/cron "ORPHAN (no passwd entry)"
remains
>>cron runs in a very limited environment of it's own.
thanks u were right
'&' tell to run in background
regards,
natraj.dba
-
Glad I could help. I'm thinking that the ORPHAN message is being issued because of the & at the end of the command. In cron, there's really no need to make the job run in the background as essentially it already does. Good luck.
If I have to choose between two evils, I always like to choose the one I haven't tried yet.
-
u r right again orphan message is bcos of the "&",
thanks u sir
regards
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|