Subject: cron, Oracle, and sqlplus
From: James Schnedar <[email-masked]>
To: [email-masked]
Date: Thu, 09 Jan 2003 17:19:10 -0700

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
[email-masked]

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