[oracle@vmrac1 ~]$ nohup sqlplus system/oracle@jtods < test.sql >> test.log &
[1] 3663
使用Linux下jobs或ps -ef|grep 3663查询
参考网友文档
linux 后台运行sql脚本2008年09月24日 星期三 10:15
tmp_xf_fb.sql
call fbadmin.SP_FEEDBACK_ALLSUM_DB1(&1);
-----------------
cat tmp_xf_fb.sh
#!/bin/sh
export ORACLE_SID=newcrm
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10.2
export PATH=$HOME/bin:$ORACLE_HOME/bin:/sbin:/bin:/usr/sbin:$PATH
export ORACLE_TERM=xterm
export NLS_LANG="AMERICAN_AMERICA.zhs16gbk"
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib
export LD_ASSUME_KERNEL=2.4.19
#. /home/oracle/.bashrc
date
$ORACLE_HOME/bin/sqlplus -S fbadmin/fbadmin <<EOF
@/home/oracle/worksh/tmp_xf_fb.sql $1
exit;
EOF
date
------------------
[oracle@crmtest worksh]$ nohup ./tmp_xf_fb.sh 0 &
[1] 10683
[oracle@crmtest worksh]$ nohup: appending output to `nohup.out'
[oracle@crmtest worksh]$ jobs
[1]+ Running nohup ./tmp_xf_fb.sh 0 &
[oracle@crmtest worksh]$ jobs
[1]+ Done nohup ./tmp_xf_fb.sh 0
------nohup.out
Wed Sep 24 10:12:59 CST 2008
old 1: call fbadmin.SP_FEEDBACK_ALLSUM_DB1(&1)
new 1: call fbadmin.SP_FEEDBACK_ALLSUM_DB1(0)
Call completed.
Wed Sep 24 10:13:07 CST 2008
-----------