RE: Remote SQL*Loader session won't die

Just a guess, but could your STDIN be redefined in the method that doesn't work and it's waiting for you to enter your username or something silly? Perhaps you could post the command(s) you're trying to use.

Rich

Rich Jesse                           System/Database Administrator
rjesse_at_qtiworld.com                  Quad/Tech Inc, Sussex, WI USA

> -----Original Message-----
> From: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM]
> Sent: Wednesday, November 12, 2003 4:10 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Remote SQL*Loader session won't die
>
>
> We are creating some Unix (DEC/Compaq/HP) ksh scripts to move
> data to a
> remote system and then execute SQL*Loader (Oracle 8.1.6).
> Logging in on the
> remote system, this works fine. If the commands are executed from the
> command line using rsh, it works fine. But when SQL*Loader is executed
> through rsh, within a script, the load works fine, but the
> process doesn't
> terminate, just hangs. To add another wrinkle, going to a
> different machine
> works fine also, but the system administrator says there isn't any
> difference between the machines. And executing anything other than
> SQL*Loader works fine. I'm stumped and would welcome any ideas.
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).