Re: Unix backup script problem

In article <2r8mtf$r03_at_news.tamu.edu>, keith_at_loony-toons.tamu.edu (Keith A. Marrocco) writes:
|> We are trying to use cron and a Unix script file to shut down Oracle every
|> Sunday at 6:00am, do a full backup of the database, and restart the database.
|> Everything works fine when we go through the process manually, but when cron
|> actually runs the script we get the following:
|>
|> ORA-01034: ORACLE not available
|> ORA-07429: smsgsg: shmget() failed to get segment.
|> SVR4 Error: 2: No such file or directory
|>
|> Oracle *is* up and running when the script gets these messages. Can anybody
|> tell me why the script works when we enter the commands manually but croaks
|> when we have cron submit it? I can post the script itself if it is necessary.
|>

Check the following:

  1.) Make sure that all the normal oracle goodies are exported to the

      environment of the script file that is being run to shut down 
      (ORACLE_SID, ORACLE_HOME), etc.  This is essential.

  2.) Make sure that the suid bit is set correctly on your oracle
      executable - i am assuming that this is not the problem otherwise
      unix users logged in other than oracle would get a shared memory
      error.

-- 
Thanks,
--------------------------------------------------
joseph r minnich	jminnich_at_bugaboo.ssnet.com
724 millcreek lane	home: (302)322-6244
bear delaware 19701	work: (302)368-8982