This is the mail archive of the cygwin@cygwin.com mailing list for the Cygwin project.


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]
Other format: [Raw text]

cron, Oracle, and sqlplus


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


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]