Quick Reference for Common Tasks

This section lists some of the common tasks performed using Oracle Audit Vault and Database Firewall.

About this Quick Reference

This chapter is intended for users who are familiar with Oracle Audit Vault and Database Firewall (Oracle AVDF), and who want to locate step-by-step instructions for common tasks. If you are new to Oracle AVDF, then we recommend that you read the documentation to understand the product and plan your configuration.

See Summary of Configuration Steps to understand the workflows for configuring Oracle Audit Vault and Database Firewall

Audit Vault Server

System Settings

"Specifying the Server Date, Time, and Keyboard Settings"

"Changing the Primary Audit Vault Server Network Configuration"

"Changing the UI (Console) Certificate for Audit Vault Server"

"Configuring or Changing the Audit Vault Server Services"

"Configuring Audit Vault Server Syslog Destinations"

"Configuring Email Notifications"

"Testing Audit Vault Server System Operations"

"Data Encryption on Upgraded Instances"

Archiving and Retrieving

"Defining Archive Locations"

"Creating Archive and Retention Policies"

"Deleting Archive and Retention Policies"

"Starting an Archive Job Manually"

"Retrieving Oracle Audit Vault and Database Firewall Audit Data"

High Availability Configuration of Audit Vault Servers

"Configure the Designated Standby Audit Vault Server"

"Configure the Designated Primary Audit Vault Server"

"Checking the High Availability Status of an Audit Vault Server"

"Post High Availability Pairing Steps"

"Disabling or Enabling Failover of the Audit Vault Server"

AVCLI (Command Line Interface)

"Downloading the AVCLI Command Line Utility and Setting JAVA_HOME"

"About Logging in to AVCLI"

"Displaying Help and the Version Number of AVCLI"

"Running AVCLI Scripts"

"Specifying Log Levels for AVCLI"

"AVCLI Commands Reference"

Other Operations

"Backup and Restore of Audit Vault Server"

"Rotating the Master Key for Repository Encryption"

"Changing the Keystore Password"

"Enabling Oracle Database In-Memory for the Audit Vault Server"

"Monitoring Jobs"

"Checking Server Status and System Operation"

"Accessing the Audit Vault Server Certificate and Public Key"

"Restarting or Powering Off the Audit Vault Server"

"Changing the Keyboard Layout"

"Running Diagnostics Checks for the Audit Vault Server"

Database Firewall

Firewall System Settings

"Configuring Network Settings for Oracle Database Firewall"

"Configuring Network Services for Oracle Database Firewall"

"Setting the Date and Time in Database Firewall"

"Specifying the Audit Vault Server Certificate and IP Address"

"Viewing the Status and Diagnostics Report for Database Firewall"

Firewall Network Configuration

"Configuring Network Settings"

"Configuring the Database Firewall As a Traffic Proxy"

"Viewing Network Traffic for a Database Firewall"

Managing Database Firewalls in the Audit Vault Server

"Registering Database Firewall in Audit Vault Server"

"Restarting or Powering Off Database Firewall"

"Removing Database Firewall from Audit Vault Server"

"Fetching an Updated Certificate from Database Firewall"

High Availability Pairing of Database Firewalls

"High Availability for Database Firewall in Host Monitor Agent or Out of Band Modes"

"Swapping Roles Between Primary and Standby Database Firewalls"

"Unpair Primary and Standby Database Firewalls"

Hosts

"Registering Hosts on the Audit Vault Server"

"Changing Host Names"

"Deleting Hosts from Audit Vault Server"

"Deploying Plug-ins and Registering Plug-in Hosts"

"Removing Plug-ins"

Agent

Agent Deployment

"Steps Required to Deploy and Activate the Audit Vault Agent"

"Deploying the Audit Vault Agent"

"Activating and Starting the Audit Vault Agent"

"Unregistering the Audit Vault Agent as a Windows Service"

"Stopping and Starting the Agent on Unix Hosts"

"Stopping and Starting the Agent on Windows Hosts"

"Changing the Logging Level for the Audit Vault Agent"

"Deactivating and Removing Audit Vault Agent"

Updating Agent

"Updating Audit Vault Agent"

Host Monitor Agent

Host Monitor Agent Installation

"Registering the Host Machine That Will Run the Host Monitor Agent"

"Deploying the Host Monitor Agent on a Windows Host Machine" or "Deploying the Host Monitor Agent on a Unix Host Machine"

"Creating a Target for the Host-Monitored Database"

"Creating a Monitoring Point for the Host Monitor Agent"

Host Monitor Agent Operations

"Starting the Host Monitor Agent"

"Stopping the Host Monitor Agent"

"Changing the Logging Level for a Host Monitor Agent"

"Checking the Status of a Host Monitor Agent Audit Trail"

"Uninstalling a Host Monitor Agent (Unix Hosts Only)"

Updating

"Updating a Host Monitor Agent (Unix Hosts Only)"

Host Monitor Agent Security

"Using Mutual Authentication for Communication Between the Database Firewall and the Host Monitor Agent"

Targets

Registering and Managing

"Registering Targets"

"Removing Targets"

"Creating a Target Group"

"Managing User Access Rights to Targets and Groups"

Auditing

Preparing for Auditing

"Preparing Targets for Audit Data Collection"

"Using an NTP Service to Set Time on Targets"

"Ensuring that Auditing is Enabled on the Target"

"Setting User Account Privileges on Targets"

"Scheduling Audit Trail Cleanup"

Audit Trails

"Adding Audit Trails with Agent-Based Collection"

"Stopping, Starting, and Autostart of Audit Trails in Oracle Audit Vault Server"

"Checking the Status of Trail Collection on the Audit Vault Server"

"Deleting an Audit Trail"

"Running the XML Transformation Utility for MySQL Audit Formats"

Monitoring with Database Firewall

Database Firewall Monitoring Points

"Creating and Configuring a Database Firewall Monitoring Point"

"Modifying a Database Firewall Monitoring Point"

"Starting, Stopping, or Deleting Database Firewall Monitoring Points"

"Viewing the Status of Database Firewall Monitoring Points"

"Finding the Port Number Used by a Database Firewall Monitoring Point"

Native Network Encrypted Traffic Monitoring

"Configuring Advanced Settings for Database Firewall"

"Changing the Database Firewall Host Name"

"Configuring Database Firewall for Databases That Use Native Network Encryption"

"Monitor Native Network Encrypted Traffic Through Database Firewall for Oracle Databases"

"Disabling Encrypted Traffic Monitoring for Oracle Databases"

Other Administrator Tasks

"Downloading the Oracle Audit Vault and Database Firewall SDK"

"Monitoring and Adding Server Tablespace Space Usage"

"Monitoring Server Archive Log Disk Space Use"

"Monitoring Server Flash Recovery Area"

"Backup and Restore of Audit Vault Server"

Reference Information

Plug-ins

About Plug-ins

Summary of Data Collected for Each Audit Trail Type

Scripts for Oracle AVDF Account Privileges on Targets

Audit Trail Cleanup

Target Locations (Connect Strings)

Audit Collection Attributes

Audit Trail Locations

Other Reference Information

AVCLI Commands Reference

Transaction Log Audit Data Collection for Oracle Database

Ports Used by Oracle Audit Vault and Database Firewall

Troubleshooting Oracle Audit Vault and Database Firewall

Oracle AVDF 20 Cookbook

Cookbook: Oracle Audit Vault and Database Firewall 20 for Beginners