RE: NOHUP SQLPLUS

From: Jenkins, Michael <Michael.Jenkins_at_Nextel.com>
Date: Mon, 04 Feb 2002 12:01:51 -0800
Message-ID: <F001.004054F8.20020204115559@fatcity.com>

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 <ewilliams_at_brownco.com>
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: ewilliams_at_brownco.com

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: 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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: dgoulet_at_vicr.com

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

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