修改spfile和pfile能不能实现自动记录？

woshiyiziyu · 发表于 2009-8-28 18:14

问题又来了，http://yong321.freeshell.org/computer/logfile.html，我在我的AIX 5.1上没有nawk和perl命令，只有awk，在我的redhat linux 4上只有gawk，perl命令倒是有，但是执行不成功，老是提示“can't find string terminator ' " ' anywhere before EOF at -e line 1.之前我编脚本的时候用的是awk，没有用过nawk和perl，您的脚本能不能使用awk编写呢？虽然你的文章中指出If you're more comfortable with awk than perl, replace perl with nawk or gawk (but probably not awk in case it has a broken system command)。我自己尝试着用awk 编写，但是总是不成功，tail -f alert_ORCL.log | nawk '/^ORA-00600/ {system("mailx -s 'ORCL error' youremail < /dev/null")}'以前从没见过可以直接调用system命令的。

[ 本帖最后由 woshiyiziyu 于 2009-8-28 18:19 编辑 ]

woshiyiziyu · 发表于 2009-8-28 20:20

自己尝试写了个脚本
#!/bin/ksh
cd /oracle
a=`cat alert_orcl.log|grep 'alter'|wc -l`
b=`cat temp |wc -l`
if [ "$a" -ne "$b" ]
then
mailx -s "alter" oracle </dev/null
fi
cat alert_snpdb.log|grep 'alter' > temp
缺点是要安排在后台定时执行，不能实时查看。

Yong Huang · 发表于 2009-8-29 02:11

I strongly recommend you install Perl on the AIX box. Nowadays it's almost essential for system administration. On our AIX 5.3 server, our /usr/bin/perl comes from perl.rte Fileset or package.

I had an error in my note (which I just corrected). This string inside the "mail ..." command
'ORCL error'
should be changed to
\"ORCL error\"

I think that caused the error you got on your RHEL 4. If not, show me the exact command and error.

If you grep alert.log for a pattern, it completely defeats the purpose of using tail -f. Read the first paragraph of my note.

BTW, many people like to `cat somefile | grep pattern', not knowing `grep pattern somefile' is more efficient. Likewise, `grep -c pattern somefile' is much more efficient than `grep pattern somefile | wc -l'.

Yong Huang

[ 本帖最后由 Yong Huang 于 2009-8-28 12:26 编辑 ]