Re: Twist on ORA - 03113 : only happens when running from cron

In a previous article, btl_at_hogpf.ho.att.com (-B.LING) says:

>my system (a SUN 670), is having a rather weird problem when it
>comes to doing backups of the oracle database. the command
>run during cron is:
>
>su - oracle -c /home1/home/oracle/product/7.0.15/bin/dbshut
>
>/etc/dump 0ubsdf 126 6000 54000 /dev/nrst1 /home/oracle/data/btl
>
>su - oracle -c /home1/home/oracle/product/7.0.15/bin/dbstart
>
>and this works fine on the command line! however, when run
>as cron, we get:
>
>ORACLE7 Server Release 7.0.15.4.0 - Production
>With the procedural option
>PL/SQL Release 2.0.17.1.0 - Production
>
>SQLDBA> Connected.
>SQLDBA> ORACLE instance shut down.
>SQLDBA>
>SQL*DBA complete.
>ld.so: warning: /usr/5lib/libc.so.2.7 has older revision than expected 8
>ORA-03113: end-of-file on communication channel
>SQLDBA>
>
>and the process hangs. this was working fine until saturday nite.
>would anyone have any ideas why it works on the command line but
>fails in cron?

   My guess is that your cron script is not setting LD_LIBRARY_PATH to the same value as your regular shell setup scripts are.

• Doug --