Re: cron, Oracle, and sqlplus

["Peter A. Castro" <doctor at fruitbat dot org>]

On Thu, 9 Jan 2003, James Schnedar wrote:

> I am experiencing a problem with running Oracle sqlplus within a shell
> script using cron.  The shell script runs correctly from the command
> line, but once I add it to cron, the shell script will execute up until
> the sqlplus command.  Therefore, cron is working correctly as well, but
> the addition of the sqlplus command causes it to hang.  The sqlplus
> session has started, but appears hung.
> 
> ps -ef yields:
> 
>      UID     PID    PPID TTY     STIME COMMAND
>   SYSTEM    3296     552   ?  14:53:00 /usr/sbin/cron
> Administ    3312    3296   ?  14:53:00 /usr/bin/sh
> Administ    3388    3312   ?  14:53:00 /usr/bin/sh
> Administ    3472    3296   ?  14:53:01 /usr/sbin/ssmtp
> Administ    3508    3388   ?    Dec 31
> /cygdrive/d/ORACLE/806/bin/sqlplus

sqlplus is a native windows app, so perhaps you are trying to invoke it
with a cygwin-ized path to a command file?  If you can send us a section
of your shell script, where it's invoking sqlplus, perhaps we can figure
out what's going on.  Also, there are some environmental variables that
can effect sqlplus execution, and cron doesn't invoke things in a full
environment.

> Any suggestions?
> Thanks,

-- 
Peter A. Castro <doctor@fruitbat.org> or <Peter.Castro@oracle.com>
	"Cats are just autistic Dogs" -- Dr. Tony Attwood


--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/