如何设置unified_audit_systemlog参数

wgz7747147820

于 2020-10-21 22:02:27 发布

阅读量315

点赞数

分类专栏： orale 文章标签： oracle

本文链接：https://blog.csdn.net/wgz7747147820/article/details/109210884

版权

orale 专栏收录该内容

207 篇文章

订阅专栏

06:48:20 SQL> alter system set unified_audit_systemlog='local7.info' scope=spfile;

System altered.

Elapsed: 00:00:00.07
如果是rac环境，需要在多个node上都设置
[root@scaqai06adm07 log]# cat /etc/rsyslog.conf | grep local7
local7.info                   /var/log/vault1audit.log

如果是rac环境，需要在多个node上都重启该service
重启rsyslog service

[root@scaqai06adm07 log]# service rsyslog restart
Redirecting to /bin/systemctl restart rsyslog.service

[root@scaqai06adm07 log]# tail -f vault1audit.log
Oct 21 06:37:59 scaqai06adm07 journal: Oracle Unified Audit[339117]: LENGTH: '197' TYPE:"4" DBID:"4222300165" SESID:"4236070957" CLIENTID:"" ENTRYID:"2" STMTID:"7" DBUSER:"SYS" CURUSER:"SYS" ACTION:"49" RETCODE:"0" SCHEMA:"" OBJNAME:"" PDB_GUID:"B1934BAC41113D74E0537885E50A3DD5"