配置环境: 客户端 AIX 5.3 主机名aaaaaa 服务端 Centos 5.3 主机名bbbbbb
客户端配置:
在/etc/syslog.conf 中一增加一行 local0.info @bbbbbb
激活新的配置 kill -HUP `/bin/cat /etc/syslog.pid`
服务端配置:
修改/etc/sysconfig/syslog文件,更改SYSLOGD_OPTIONS="-m 0"为SYSLOGD_OPTIONS="-m 0 -r ",修改后重新启动 service syslog restart.
修改/etc/syslog.conf,增加一行:local0.info /tmp/kk.log ,并在前面 *.info 后面加上 ;local0.none,不然这一行也会记录local0.info,就重复了。
激活新的配置 kill -HUP `/bin/cat /var/run/syslogd.pid`
测试:
在客户端执行:
$ logger -p local0.info "test message"
$ tail -f /opt/oracle/admin/bass/bdump/alert_bass.log |logger -p local0.info
服务端执行:
[root@blade1 ~]# tail -f /tmp/kk.log
Sep 24 14:28:22 aaaaaa Message forwarded from aaaaaa: root: test messageSep 24 14:28:42 aaaaaa Message forwarded from uaibsdev: root: and to_char(b.paytodate, 'yyyy-mm-dd') <= '2009-06-04')),
Sep 24 14:28:42 uaibsdev Message forwarded from aaaaaa: root: ((select count(l.agentcode)
Sep 24 14:28:42 uaibsdev Message forwarded from uaaaaaa: root:
Sep 24 14:28:42 uaibsdev Message forwarded from aaaaaa: root: Wed Sep 23 23:15:43 2009
Sep 24 14:28:42 uaibsdev Message forwarded from aaaaaa: root: Thread 1 advanced to log sequence 35
Sep 24 14:28:42 uaibsdev Message forwarded from aaaaaa: root: Current log# 2 seq# 35 mem# 0: /oradata/bass/redo02.log
Sep 24 14:28:42 uaibsdev Message forwarded from uaibsdev: root: Thu Sep 24 06:00:00 2009
Sep 24 14:28:42 uaibsdev Message forwarded from uaibsdev: root: Unable to restore resource manager plan to '':
Sep 24 14:28:42 uaibsdev Message forwarded from uaibsdev: root: ORA-02097: parameter cannot be modified because specified value is invalid
Sep 24 14:28:42 uaibsdev Message forwarded from uaibsdev: root: ORA-00439: feature not enabled: Database resource manager
好了,现在在服务端随时可以看到oracle的alter_log了。
说明:
log类型和优先级的定义在 /usr/include/sys/syslog.h。
syslog也使用UDP协议,默认是开放514的udp端口。