Mail Archives: cygwin/2003/01/16/01:38:13
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 AT fruitbat DOT org> or <Peter DOT Castro AT oracle DOT 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/
- Raw text -