oracle 后台执行sql,linux 后台运行sql脚本

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 <

@/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