nohup usage..

charan81 · #1 (**permalink**) 05-20-2006

Hi,

I want to run the below 3 sql files parallely..I know adding a "&" at the end

of the command will make it run in background.But each sql file will take

a considerable time to execute so i want to apply "nohup" to this execution.

Help me how to use " nohup " to these...

echo $PASSWD | $ORACLE_HOME/bin/sqlplus -s dls_rep@$2 @$DM_DIR/$2/$1/JOB/dimA.sql &

echo $PASSWD | $ORACLE_HOME/bin/sqlplus -s dls_rep@$2 @$DM_DIR/$2/$1/JOB/dimB.sql &

echo $PASSWD | $ORACLE_HOME/bin/sqlplus -s dls_rep@$2 @$DM_DIR/$2/$1/JOB/dimC.sql &

Thanks.

jim mcnamara · #2 (**permalink**) 05-20-2006

Try something like this

Code:

nohup echo $PASSWD | $ORACLE_HOME/bin/sqlplus -s dls_rep@$2 @$DM_DIR/$2/$1/JOB/dimA.sql > log1 &
...
wait   # now you don't have to worry about disconnecting

Othwerwise all of the output from those three will be sprinkled into ./nohup.out

charan81 · #3 (**permalink**) 05-21-2006

Thanks!!

I have already directed the output to Logs folder like

LOGS=/ora05/fnfis/LOAD_logs; export LOGS

then i execute the 3 sql's and direct to > LOGS

You mean now if i dont redirect to log1 as you specified then

will it be redirected to nohup.out ??

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
nohup.out	ramky79	AIX	5	10-23-2007 06:28 AM
nohup - help!	bluemoon1	UNIX for Dummies Questions & Answers	9	10-11-2007 11:49 PM
Help on nohup	bobbyjohnz	UNIX for Advanced & Expert Users	3	10-18-2006 11:56 AM
Nohup	miwinter	UNIX for Dummies Questions & Answers	3	07-21-2006 05:20 AM
Monitor CPU usage and Memory Usage	Gajanad Bihani	High Level Programming	2	03-09-2005 07:35 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by