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.