#/bin/bash
# User specific environment
export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
DATE=`date +%Y%m%d`;
if [ -f ~/.bash_profile ];
then
. ~/.bash_profile
fi
${ORACLE_HOME}/bin/sqlplus "system/bill123@bill" << !
@run_bus.sql;
exit;
!
cd /home/oracle/bus/
cp bus_check.txt zlxt_${DATE}.txt
#-------------ftp file from master
#FTP_IP=202.98.123.186
#FTP_PORT=26580
#FTP_USER="zlxt"
#FTP_PWD="zlxT108.Com"
# ftp upload function
#function FTP_PRO ()
#{
#/usr/bin/ftp -i -n <
#put zlxt_${DATE}.txt
#bye
#EOF
#}
#FTP_PRO
ftp -i -n << !
open 202.98.123.186 26580
user zlxt zlxT108.Com
lcd /home/oracle/bus
put zlxt_${DATE}.txt
bye
# User specific environment
export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
DATE=`date +%Y%m%d`;
if [ -f ~/.bash_profile ];
then
. ~/.bash_profile
fi
${ORACLE_HOME}/bin/sqlplus "system/bill123@bill" << !
@run_bus.sql;
exit;
!
cd /home/oracle/bus/
cp bus_check.txt zlxt_${DATE}.txt
#-------------ftp file from master
#FTP_IP=202.98.123.186
#FTP_PORT=26580
#FTP_USER="zlxt"
#FTP_PWD="zlxT108.Com"
# ftp upload function
#function FTP_PRO ()
#{
#/usr/bin/ftp -i -n <
#put zlxt_${DATE}.txt
#bye
#EOF
#}
#FTP_PRO
ftp -i -n << !
open 202.98.123.186 26580
user zlxt zlxT108.Com
lcd /home/oracle/bus
put zlxt_${DATE}.txt
bye
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29076828/viewspace-1269982/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
单机goldengate单向复制搭建
下一篇：
sqlloder脚本
请登录后发表评论
登录
全部评论
