This is the mail archive of the
cygwin@cygwin.com
mailing list for the Cygwin project.
Re: cron, Oracle, and sqlplus
- From: Igor Pechtchanski <pechtcha at cs dot nyu dot edu>
- To: James Schnedar <jims at nmmcc dot com>
- Cc: cygwin at cygwin dot com
- Date: Thu, 9 Jan 2003 20:37:07 -0500 (EST)
- Subject: Re: cron, Oracle, and sqlplus
- Reply-to: cygwin at cygwin dot com
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/
|\ _,,,---,,_ pechtcha@cs.nyu.edu
ZZZzz /,`.-'`' -. ;-;;,_ igor@watson.ibm.com
|,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