I use "nohup" all the time to run jobs when I'm in fear of losing my
connection. It seems to work fine for me in Solaris 2.51/2.6. I would
suggest that you make a shell script that looks something like this:
sqlplus -s /nolog<<EOF
connect username/password
...
{Insert Your SQL}
...
exit
EOF
This will avoid showing the username/password in the "ps -ef" command.
Also, you will need to start the script in the background for "nohup" to
have any impact:
nohup myscript &
Good luck.
--Michael
-----Original Message-----
Sent: Monday, February 04, 2002 2:31 PM
To: Multiple recipients of list ORACLE-L
Erik,
In my experience a nohup will die with your terminal session. Best bet
would be to use 'at'.
Dick Goulet
____________________Reply Separator____________________
Author: Erik Williams <[EMAIL PROTECTED]>
Date: 2/4/2002 11:12 AM
I am going to be executing a long running job this weekend from home. I am
going to VPN into the corp network and telnet to the server. I am affraid of
loosing my telnet terminal session and the job dying mid way through. The
plan is to use 'nohup sqlplus system/***** @long_running.sql'. Has anyone
used this or run into issues using it? Every time I assume something will
'just work', IT DOESNT!
Thanks
Erik
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Erik Williams
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jenkins, Michael
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
