- 论坛徽章:
- 0
|
目的:建表
create table my_os_stat(stat_date date,r number,b number,
swpd number,free number,buff number,cache number,
si number,so number,bi number,bo number,
"in" number,cs number,us number,sy number,
id number,wa number);
然后用如下将信息插入,却报错,百度了一下,结果几种方法都不行
此脚本为在linux rhel4上用EMACS生产
[oracle@localhost ~]$ cat -v tian.sh
#!/bin/bash
vmstat 3 8|sed 1,3d|tr -s " "|{
sqlplus system/cjc<<EOF
insert into my_os_stat values(sysdate,$a1,$a2,$a3,$a4,$a5,$a6,$a7,$a8,$a9,$a10,$a11,$a12,$a13,$a14,$a15,$a16);
commit;
exit
EOF
[oracle@localhost ~]$ /bin/sh
sh-3.00$ tian.sh
sh: ./tian.sh: 权限不够
sh-3.00$ chmod 755 tian.sh
sh-3.00$ tian.sh
./tian.sh: line 8: syntax error: unexpected end of file
尝试使用如下解决方法还是不行:
[oracle@localhost ~]$ dos2unix tian.sh
dos2unix: converting file tian.sh to UNIX format ...
[oracle@localhost ~]$ /bin/sh tian.sh
tian.sh: line 8: syntax error: unexpected end of file
请高手指教一下,问题在哪里?谢谢啦 |
|