Administrator Guide

9.9.3
- 9.9.4
- 9.9.2
- 9.9.1
- 9.9
- 9.8.4
- 9.8.3
- 9.8.2
- 9.8.1
- 9.8.0

Back Next

Audit Trail Reports

To generate audit trail reports, you use the

audit

command. You can generate standard or compact audit trail reports that use the detailed audit files as input.

For information about the

audit

command, see Audit.

Standard Audit Trail Report

The following example shows a sample standard audit trail report:

Date			   	      Address	User Name	      Type	        Path  Object Name Operation  Result   
Thu May 09 02:22:16 IST 2019 127.0.0.1  :: internal user :: OracleDatabase Site  o1	      add	    success

Attribute				Old Value 					 New Value 							Notes
name													o1
ssl													 false
ks.keyStore										     DefaultKeyStore
path													Site\o1
authorizations										  Authorizations owner=null,
instances.1.instanceName	 					       read=[null],
instances.1.instanceName							    write=[null]
instances.1.listenerAddress							 ins
instances.1.listenerPort							    add
													    1521

The following table describes the standard audit trail report fields:

Field	Description
Date	Date of the report in the format: MM/dd/yyyy HH:mm:ss.SS
Address	User host or IP address.
User Name	User name.
Type	Type of object: Domain Database Service Host Port Security Server Appender Logger
Path	Current location of the object.
Object name	Name of the object.
Operation	Audit trail operation: Add Backup Copy Edit Export Import License Lock Login Logout Move Network Password Port Reload Remove Rename Restore Shutdown Start Stop Support Unlock
Result	Status of the operation: success failure
Attribute	Attribute that was changed by the operation.
Old value	Previous value of the attribute. Depending on the operation, an attribute might have an old value or a new value, or both.
New value	New value of the attribute. Depending on the operation, an attribute might have an old value or a new value, or both.
Notes	Contains data from the audit trail log reference field and any warning messages.

Compact Audit Trail Report

The following example shows a sample compact audit trail report:

Date			             Address	User Name	       Type	       Path  Object Name Operation Result	Notes			
Thu May 09 02:22:16 IST 2019 127.0.0.1  :: internal user :: OracleDatabase Site  o1	      add	   success

The following table describes the compact audit trail report fields:

Field	Description
Date	Date of the report in the format: MM/dd/yyyy HH:mm:ss.SS
Address	User host or IP address.
User Name	User name.
Type	Type of object: Domain Database Service Host Port Security Server Appender Logger
Path	Current location of the object.
Object name	Name of the object.
Operation	Audit trail operation: Add Backup Copy Edit Export Import License Lock Login Logout Move Network Password Port Reload Remove Rename Restore Shutdown Start Stop Support Unlock
Result	Status of the operation: success failure
Notes	Contains data from the audit trail log reference field and any warning messages.

Rename Saved Search

Table of Contents

Administrator Guide

Administrator Guide

Audit Trail Reports

Audit Trail Reports

Standard Audit Trail Report

Compact Audit Trail Report