AIX下配置将ORACLE数据库audit日志发送到syslog服务器

最新推荐文章于 2021-08-11 05:56:23 发布

allway2

最新推荐文章于 2021-08-11 05:56:23 发布

阅读量2.9k

点赞数 1

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/allway2/article/details/90767062

本文详细介绍了在Oracle数据库中设置审计跟踪和系统日志级别，包括更改audit_trail参数为OS，启用系统操作审计，以及设定审计系统日志级别为local5.info的过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

# more /etc/syslog.conf
aso.notice /var/log/aso/aso.log rotate size 1m files 8 compress
aso.info /var/log/aso/aso_process.log rotate size 1m files 8 compress
aso.debug /var/log/aso/aso_debug.log rotate size 32m files 8 compress

caa.debug /var/adm/ras/syslog.caa rotate size 10m files 10 compress
*.emerg;*.alert;*.crit;*.err;*.warning;*.notice;*.info;*.debug @1.1.1.1

# su - oracle
[YOU HAVE NEW MAIL]
$ sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Tue Jun 4 12:42:31 2019

SQL> conn / as sysdba
Connected.
SQL> show parameter audit_trail

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_trail string NONE

SQL> alter system set audit_trail=OS scope=spfile;

System altered.

SQL> alter system set audit_sys_operations=TRUE scope=spfile;

System altered.

SQL> show parameter audit_syslog_level

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_syslog_level string

SQL> alter system set audit_syslog_level='local5.info' scope=spfile;

System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1.9241E+10 bytes
Fixed Size 2254496 bytes
Variable Size 3288336736 bytes
Database Buffers 1.5905E+10 bytes
Redo Buffers 45666304 bytes
Database mounted.
Database opened.
SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options