- 论坛徽章:
- 0
|
借问楼上的我这段shell执行老是报syntax error at line 20:'<<' is not matched.
#!/bin/sh
for i in *.csv
do
ip=$(echo $i|cut -d, -f 1)
temp=$(echo $i|cut -d, -f 2)
type=$(echo $temp|cut -d. -f 1)
if [ "$type" = "CPU Utilization Baseline" ]
then
lastline=$(tail -1 "$i"
tempdate=$(echo $lastline|cut -d, -f 1)
time=$(echo $lastline|cut -d, -f 2)
cpu_ut=$(echo $lastline|cut -d, -f 3)
date=$date|sed 's/"//g'
export ORACLE_BASE=/oracle/app
export ORACLE_SID=hpov
export ORACLE_HOME=/oracle/app/10.0.1
export PATH=$PATHORACLE_HOME/bin
su - oracle -c <<EOF
sqlplus /nolog
connect sim/hpsim@ov_net
set feedback off;
set pagesize 0;
alter session set nls_date_format='mm/dd/yy';
insert into permon (ip,permondate,permontime,cpuper) values ('$ip','$date','$time','$cpu_ut');
commit;
EOF
fi
done |
|