标题: 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
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.