Querying CDB_* Views Generates Audit Records Mustafa, 2023-10-04 Hi, I would like to share a small problem I had on one of my databases. I had a common user on my CDBs to manage the databases (version is 19.20). On my databases, I use unified auditing and traditional audit is off. ORA_LOGON_FAILURES and ORA_SECURECONFIG policies are only enabled… Continue Reading
Audits are not Purged Mustafa, 2022-07-302022-07-30 Hello, This week I realized that some of my databases’ audit data are not purged and audit tables get bigger. I already have a scheduler job to purge my audit records but somehow job has been completed successfully but audit records are not deleted. This is 19.15 version, NON-CDB databases…. Continue Reading
Enable Unified Audit on Linux and Windows Mustafa, 2021-09-08 Hi, As you know, since 12c Oracle introduce Unified Auditing which has much more capabilities than standard auditing. Creating policies, audit conditions, top level auditing etc. By default Oracle uses “mixed” mode which allows you to run unified auditing commands and standard auditing. you can check if you are using… Continue Reading
ORA-00600 [kzan_open_osfile:ksfdread] while querying/purging unified audit Mustafa, 2021-08-08 Hi everyone, Lately, I hit and ORA-600 while querying unified_audit_trail on 19.8 Oracle database and same thing happens if you want to purge audit data too. the exact error message is: ORA-00600: internal error code, arguments: [kzan_open_osfile:ksfdread], [], [], [], [], [], [], [], [], [], [], [] Normally, I… Continue Reading