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
Date: Wed, 15 Jan 2003 22:37:50 -0800 (PST)
From: "Peter A. Castro" <doctor AT fruitbat DOT org>
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.LNX.4.21.0301152234030.6970-100000@gremlin.fruitbat.org>
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

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/