DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: probelm scheduling thru cron job "ORPHAN (no passwd entry)"

  1. #1
    Join Date
    Apr 2006
    Posts
    35

    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

  2. #2
    Join Date
    Apr 2003
    Location
    Gourock, Scotland
    Posts
    102
    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.

  3. #3
    Join Date
    Apr 2006
    Posts
    35
    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

  4. #4
    Join Date
    Apr 2003
    Location
    Gourock, Scotland
    Posts
    102
    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.

  5. #5
    Join Date
    Apr 2006
    Posts
    35
    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
  •  


Click Here to Expand Forum to Full Width