This is the mail archive of the
cygwin@cygwin.com
mailing list for the Cygwin project.
cron, Oracle, and sqlplus
- From: James Schnedar <jims at nmmcc dot com>
- To: cygwin at cygwin dot com
- Date: Thu, 09 Jan 2003 17:19:10 -0700
- Subject: cron, Oracle, and sqlplus
- Organization: NMMCC
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