定时监控网页数据的简单脚本
[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
[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
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/24237320/viewspace-2118598/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- [Linux7] HA Package Yum源配置
- [ASM] ORA-15032 ORA-15260
- [RAC] Oracle11g RAC禁止DB自动启动
- [Oracle] Device Checks for ASM - This is a pre-check........
- [Linux7] Centos7 multipath 盘权限绑定.
- [Linux7] zabbix 3.2.11安装
- [Oracle] Error in invoking target 'agent nmhs' of makefile
- [Linux] 查看环境变量
- [HPUX] HP Unix server vg自动激活
- [HPUX] UX:vxfs mount: ERROR: V-3-21264
