# What Do Oracle Audit Vault Collection Agents Do?

- URL: https://www.integrigy.com/oracle-security-blog/what-do-oracle-audit-vault-collection-agents-do
- Published: 2014-12-19
- Type: Blog Post
- Products: Oracle Database, Oracle Audit Vault and Database Firewall
- Focus areas: Auditing

The Oracle Audit Vault is installed on a server, and collector agents are installed on the hosts running the source databases. These collector agents communicate with the audit vault server.

If the collection agents are not active, no audit data is lost, as long as the source database continues to collect the audit data. When the collection agent is restarted, it will capture the audit data that the source database had collected during the time the collection agent was inactive.

![Audit Vault Agents on Oracle Database, MySQL and SQL Server hosts collect standard audit logs and send them to Oracle Audit Vault](https://www.integrigy.com/_astro/2292-1.BgdK1Zyg.png)

There are three types of agent collectors for Oracle databases. There are other collectors for third-party database vendors such as SAP Sybase, Microsoft SQL-Server, and IBM DB2.

<table>
<thead>
<tr>
<th colspan="3"><p><strong>Audit Value Collectors for Oracle Databases*</strong></p></th>
</tr>
<tr>
<th><p><strong>Audit Trail Type</strong></p></th>
<th><p><strong>How Enabled</strong></p></th>
<th><p><strong>Collector Name</strong></p></th>
</tr>
</thead>
<tbody>
<tr>
<td><p>Database audit trail</p></td>
<td><p><strong>For standard audit records:</strong> <code>AUDIT_TRAIL</code> initialization parameter set to: <code>DB</code> or <code>DB, EXTENDED</code>.</p>
<p><strong>For fine-grained audit records:</strong> The <code>audit trail</code> parameter of <code>DBMS_FGA.ADD_POLICY</code> procedure is set to: <code>DBMS_FGA.DB</code> or <code>DBMS_FGA.DB + DBMS_FGA.EXTENDED</code>.</p></td>
<td><p>DBAUD</p></td>
</tr>
<tr>
<td><p>Operating system audit trail</p></td>
<td><p><strong>For standard audit records:</strong> <code>AUDIT_TRAIL</code> initialization parameter is set to: <code>OS</code>, <code>XML</code>, or <code>XML, EXTENDED</code>.</p>
<p>For syslog audit trails, <code>AUDIT_TRAIL</code> is set to <code>OS</code> and the <code>AUDIT_SYS_OPERATIONS</code> parameter is set to <code>TRUE</code>.  In addition, the <code>AUDIT_SYSLOG_LEVEL</code> parameter must be set.</p>
<p><strong>For fine-grained audit records:</strong> The <code>audit_trail</code> parameter of the <code>DBMS_FGA.ADD_POLICY</code> procedure is set to <code>DBMS_FGA.XML</code> or <code>DBMS_FGA.XML + DBMS_FGA.EXTENDED</code>.</p></td>
<td><p>OSAUD</p></td>
</tr>
<tr>
<td><p>Redo log files</p></td>
<td><p>The table that you want to audit must be eligible.  See <a href="http://docs.oracle.com/cd/E23574_01/server.103/e16813/avusr_policies.htm#CHDGBICC">"Creating Capture Rules for Redo Log File Auditing"</a> for more information.</p></td>
<td><p>REDO</p></td>
</tr>
</tbody>
</table>

\*Note if using Oracle 12c; the assumption is that Mixed Mode Unified Auditing is being used

If you have questions, please contact us at <mailto:info@integrigy.com>

## Reference

- Integrigy Guide to Oracle Audit Vault [Integrigy Guide to Oracle Audit Vault](https://www.integrigy.com/security-resources/integrigy-guide-oracle-audit-vault)
- Presentation “Developing Value with Oracle Audit Vault [Developing Value with Oracle Audit Vault](https://www.integrigy.com/security-resources/developing-value-oracle-audit-vault)
