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
Message-ID: <3E1E117E.F8C2E56E@nmmcc.com>
Date: Thu, 09 Jan 2003 17:19:10 -0700
From: James Schnedar <jims AT nmmcc DOT com>
Organization: NMMCC
X-Accept-Language: en
MIME-Version: 1.0
To: cygwin AT cygwin DOT com
Subject: cron, Oracle, and sqlplus
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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,

-- 
-Jim Schnedar
New Mexico Mutual Casualty Company
jims AT nmmcc DOT com

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