Re: Twist on ORA - 03113 : only happens when running from cron
Date: Mon, 25 Jul 1994 22:37:03 GMT
Message-ID: <1994Jul25.223703.27133_at_sycomp.COM.AU>
From article <2.1116.234.0N72A68C_at_active.ch>, by robert.jung_at_active.ch (Robert Jung):
> BM>su - oracle -c /home1/home/oracle/product/7.0.15/bin/dbshut
> BM>/etc/dump 0ubsdf 126 6000 54000 /dev/nrst1 /home/oracle/data/btl
> BM>su - oracle -c /home1/home/oracle/product/7.0.15/bin/dbstart
>
> 1) This is just a guess, but try to add a'</dev/null' statement at the end
> of dbshut and dbstart. It seems to work with SQL*Plus.
> 2) Is your ORACLE_SID set right, or the TWO_TASK variable.
Another thing to try is making sure that the process run by cron gets run in a directory it has write access to. The easiest way to do this is to run it from a shell script that changes directory to /tmp. Some versions of SQL*NET apparently create files in the current directory.
-- ------------------------------------------------------------------------- troy_at_cbme.unsw.EDU.AU Technical Director, Sycomp Pty Ltd My opinions are my own. Do you really think anybody else would want them?Received on Tue Jul 26 1994 - 00:37:03 CEST