重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: No Sys Audit *.aud OS Files Being Created [打印本页]

作者: 刘泽宇    时间: 2023-7-30 10:59
标题: No Sys Audit *.aud OS Files Being Created
现象:
no sys audit OS files are being created

All directories are empty; no expected files seen ( _ora__<date_id>.aud )


原因:
On ODA, the database has by default pure unified auditing enabled

"Oracle Database Appliance release 18.7 enables unified auditing for databases created in new database homes."
https://docs.oracle.com/en/engin ... 6-A220-F2106330A25B


处理方法:
When the DB has:

SQL> select parameter,value from v$option where parameter = 'Unified Auditing'; ===> TRUE

that means that the Database is using Pure Unified Auditing, and when it happens, will ignore any pre-existing audit trail parameter including .aud files.


When Audit Records Are Written to the Operating System:
In situations where the database table is unable to accept unified audit records, these records will be written to operating system spillover audit files (.bin format). The default location for these external files is the $ORACLE_BASE/audit/$ORACLE_SID directory.






欢迎光临 重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/) Powered by Discuz! X3.2