Mailing-List: contact cygwin-help@cygwin.com; run by ezmlm List-Subscribe: List-Archive: List-Post: List-Help: , Sender: cygwin-owner@cygwin.com Mail-Followup-To: cygwin@cygwin.com Delivered-To: mailing list cygwin@cygwin.com Message-ID: <3E1E117E.F8C2E56E@nmmcc.com> Date: Thu, 09 Jan 2003 17:19:10 -0700 From: James Schnedar Organization: NMMCC X-Accept-Language: en MIME-Version: 1.0 To: cygwin@cygwin.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@nmmcc.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/