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
>
> Any suggestions?
> Thanks,
James,
Is sqlplus trying to open a window or access a network share? Try
checking the "Allow service to interact with the desktop" box for the cron
service,and see if it helps (having restarted cron, of course).
Igor
--
http://cs.nyu.edu/~pechtcha/
|\ _,,,---,,_ [EMAIL PROTECTED]
ZZZzz /,`.-'`' -. ;-;;,_ [EMAIL PROTECTED]
|,4- ) )-,_. ,\ ( `'-' Igor Pechtchanski
'---''(_/--' `-'\_) fL a.k.a JaguaR-R-R-r-r-r-.-.-. Meow!
Oh, boy, virtual memory! Now I'm gonna make myself a really *big* RAMdisk!
-- /usr/games/fortune
--
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/
