10.monitor web data script

定時監控網頁資料的簡單指令碼

[mon@oracle6 ~]$ more /home/mon/source/mon_data
#!/bin/bash
export ORACLE_BASE=/u01/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export ORACLE_SID=xxxxxdb

res=`curl xxxx.xxxxx.xxx/xxxxxxxx | grep "xxxxxxxxxx" | grep "xx" | awk '{print $2}'`
datetime=`date +"%Y/%m/%d %H:%M:%S"`
echo $res
echo $datetime
$ORACLE_HOME/bin/sqlplus -S mon/mon << EOF
  insert into mon_data values('$datetime','$res');
  commit;
exit;
EOF


[mon@oracle6 ~]$ crontab -l
###############mon xxxxxx.xxx data################################
11 * * * * /home/mon/source/mon_data >> /home/mon/log/mon_data.log