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. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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 [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED] 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. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Remote SQL*Loader session won't die
I have no idea why the same command would work differently on different machines if all other things are the same. Just a shot in the dark here: Sometimes rsh must be used with -n option (see man page.) Of course, you know using r commands is in hideous opposition to politically correct security and auditing requirements ... you know ... like the requirement that people to log in as CISTUM rather than SYSTEM. -Original Message- 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).