Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Subscribe: <mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive: <http://sources.redhat.com/ml/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-help AT cygwin DOT com>, <http://sources.redhat.com/ml/#faqs>
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Delivered-To: mailing list cygwin AT cygwin DOT com
X-Authentication-Warning: slinky.cs.nyu.edu: pechtcha owned process doing -bs
Date: Thu, 9 Jan 2003 20:37:07 -0500 (EST)
From: Igor Pechtchanski <pechtcha AT cs DOT nyu DOT edu>
Reply-To: cygwin AT cygwin DOT com
To: James Schnedar <jims AT nmmcc DOT com>
cc: cygwin AT cygwin DOT com
Subject: Re: cron, Oracle, and sqlplus
In-Reply-To: <3E1E117E.F8C2E56E@nmmcc.com>
Message-ID: <Pine.GSO.4.44.0301092033000.10883-100000@slinky.cs.nyu.edu>
Importance: Normal
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

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 AT cs DOT nyu DOT edu
ZZZzz /,`.-'`'    -.  ;-;;,_		igor AT watson DOT ibm DOT 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


--
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/