Unix – Basics and Useful DBAS
Run scripts in background This was my 1st post ever, sometimes it’s is need to run long operations on the database, is recommendable to ran these task in command line on the server side. The nohup insures the OS will keep run the command even in the event we lose the network connection, Using “&” will send the command execution to “background”. Next, I’m showing two approaches to manage this. Run - nohup + background + foreground $ nohup sqlplus $UP @update_data.sql "&" [2] 155548 nohup: ignoring input and appending output to `nohup.out' $ jobs [1]+ Running nohup sqlplus $UP @update_data.sql "&" $ fg 1 nohup sqlplus $UP @update_data.sql Ctrl+C Run - nohup + grep + kill $ nohup sqlplus $UP @update_data.sql & [1] 294427 >oracle@rogerioantonio.com> nohup: ignoring input and appending output to `nohup.out' $ ps -ef | grep -i update_data.sql oracle 294427 80866 93 05:30 pts/1 00:00:16 sqlplus @upda