Issue

Trying to run all of the sql scripts in one NOHUP command. Below is my code. But, it is not running in nohup mode based on the below. There are no errors either. How do I run all of the below in one NOHUP command??

nohup sqlplus -S /NOLOG << %EOF% > engine_error.log
WHENEVER SQLERROR EXIT 1;
@$Level2/passFile server05
@engine_check.sql $stroke1 $bore1 
@engine_start.sql 
%EOF% &

Solution

When you have a script that must start some background jobs, make a script that starts functions with & and nohup your script.
When your script startit.sh looks like

function f1 {
   echo "f1 start"
   sleep 2
   echo "f1 end"
}

function f2 {
   echo "f2 start"
   sleep 1
   echo "f2 end"
}

function f3 {
   echo "f3 start"
   sleep 1
   cat <<END
f3 start here
more f3
f3 end here
END
   echo "f3 end"
}

f1 &
f2
f3 &

call nohup startit.sh.

Answered By - Walter A

Answer Checked By - Willingham (WPSolving Volunteer)

Sunday, June 5, 2022

[SOLVED] unix nohup sqlplus not working

Issue

Solution