8. Oracle Audit Vault and Database Firewall Installation Guide (Audit Vault Server 12.2.0.4)

 

Oracle Audit Vault and Database Firewall Installation Guide (Audit Vault Server 12.2.0.4)

Introduction

Oracle Audit Vault and Database Firewall (AVDF) is a comprehensive security solution that monitors and audits Oracle and non-Oracle database traffic, helping organizations meet regulatory compliance requirements. It provides a centralized platform for collecting, managing, and analyzing audit data from databases across the enterprise.

The installation of AVDF 12.2.0.4 involves two distinct components:

  1. Audit Vault Server — Collects and stores audit data

  2. Database Firewall — Monitors and controls database traffic

This guide focuses on the installation of the Audit Vault Server only. A separate guide covers the Database Firewall installation and the integration between the two components.

⚠️ Critical Note: The Audit Vault Server and Database Firewall server are software appliances. You must not make any changes to the Linux operating system through the command line on these servers unless following official Oracle documentation or under guidance from Oracle Support. Unauthorized changes can compromise the appliance's integrity and supportability.


Overview of the Installation Process

PhaseActivityDescription
1Media DownloadObtain the installation media from Oracle eDelivery
2PrerequisitesPrepare the host machine and guest VM
3InstallationInstall the Audit Vault Server software
4Post InstallationConfigure users, passwords, and settings

Audit Vault and Database Firewall Architecture

The AVDF architecture consists of the following components:

ComponentRole
Audit Vault ServerCentral repository for audit data; provides reporting and analysis
Database FirewallMonitors and controls database traffic; captures audit events
AgentsCollect audit data from monitored databases
Web ConsoleBrowser-based interface for administration and reporting

Note: This guide covers only the Audit Vault Server installation. The Database Firewall and integration steps are covered in separate guides.


Phase 1: Media Download

Download the installation media from Oracle eDelivery:

  1. Log in to eDelivery:

    • Navigate to Oracle eDelivery

  2. Search for the Required Media:

    • Search for Oracle Audit Vault and Database Firewall 12.2.0.4

  3. Download the Media:

    • The total media size is approximately 12.6 GB

    • Ensure you have sufficient disk space and a stable internet connection

Note: The media includes multiple disks (ISO files). You will need all of them for the installation.


Phase 2: Prerequisites

Host Machine Requirements

ComponentRequirement
ProcessorLatest and fast processors
MemoryAt least 8 GB
Operating SystemWindows/Linux 64-bit
Disk SpaceAt least 100 GB free HDD
VirtualizationOracle VirtualBox pre-installed
NetworkHost machine should be able to access the guest machine

Guest Machine (AV Server) Requirements

ComponentValue
IP Address192.168.56.68
Subnet Mask255.255.255.0
Gateway192.168.56.1

Phase 3: Installation

Step 1: Set Up the Virtual Machine

  1. Create a New Virtual Machine:

    • Click the New icon in VirtualBox

    • Give a name for the Audit Vault Server

  2. Configure the VM Type:

    • Type: Linux

    • Version: Oracle (64-bit)

    • Click Next

  3. Specify Memory Size:

    • For testing purposes, 2 GB should work

    • In this example, 3072 MB was allocated (the host had 12 GB RAM)

    • Click Next

  4. Add a Virtual Hard Disk:

    • Select Create a virtual hard drive now

    • Click Create

  5. Select Hard Drive File Type:

    • Select VMDK (Virtual Machine Disk)

    • Click Next

    • This file type allows splitting files into sizes less than 2 GB

  6. Configure Storage:

    • Select Dynamically Allocated

    • Select Split into files of less than 2 GB

    • Click Next

  7. Set File Location and Size:

    • Review the file location

    • Enter 220 GB as the size

    • Click Create

⚠️ Critical: If the size of the virtual hard disk is less than 220 GB, the installation will terminate.

  1. Review VM Details:

    • Review the details of the virtual machine

    • Use the Settings icon to modify any settings if necessary

Step 2: Configure the Virtual Optical Disk

  1. Select the ISO File:

    • Choose Disk 1 of the Audit Vault ISO image file V840182-01

Step 3: Set the Network Adapter

  1. Configure Network:

    • Select Attached to: Host-only Adapter

    • Click OK

Note: The Host-only Adapter allows the host machine to communicate with the guest machine directly.

Step 4: Start the Installation

  1. Start the VM:

    • Click the Start button

  2. Begin Installation:

    • Select Install in the flash screen

    • Press Enter

  3. Follow the Installation Prompts:

PromptAction
Insert Disk 2 (V840183-01.iso)Select OK, press Enter
Insert Disk 1 (V840182-01.iso) againSelect OK, press Enter
Enter the installation passphraseType a strong passphrase, press Enter
Confirm the passphraseRe-enter the passphrase, press Enter

Passphrase Requirements: The passphrase should be 8 characters or more and contain:

  • At least one uppercase letter

  • At least one lowercase letter

  • At least one digit

  • At least one punctuation mark

Example: Temp237_4O

Important: This passphrase will be used later to change other system passwords. Note it securely for future reference.

  1. Installation Successful:

    • A screen confirming "Oracle Audit Vault Installation Successful" appears

    • Press Enter to continue

Step 5: Configure the Management Interface

  1. Select Management Interface:

    • Choose one of the available interfaces as the Management Interface

    • This will be used to connect to the Audit Vault Server via SSH, PuTTY, etc.

    • Press Enter to make the selection

  2. Select Ethernet Device:

    • Select an available ethernet device

    • Press Enter

  3. Specify IP Address:

    • Enter IP address, subnet mask, and gateway for the management interface:

SettingValue
IP Address192.168.56.68
Subnet Mask255.255.255.0
Gateway192.168.56.1
  • Press Enter to complete the installation and reboot the server

Step 6: First Reboot

⚠️ Important: The first reboot of the server could take up to an hour depending on the machine's configuration. There is nothing to do here other than wait until the installation completes.

Step 7: Installation Complete

After the reboot, the final screen appears, confirming that the Audit Vault Server installation is complete.

  • Use the Up/Down arrow keys to make selections

  • Press Enter to confirm


Phase 4: Post Installation

Step 1: Log In to the Database Vault Web Console

  1. Open a Web Browser:

    • On your host machine, open a web browser

  2. Navigate to the Console:

    • Enter the following URL:

      text
      https://192.168.56.68
  3. Handle the Security Certificate:

    • Click Add Exception

    • Confirm Security

Step 2: Enter the Installation Passphrase

  • Type the installation passphrase created during installation

  • Click Login

Step 3: Set Usernames and Passwords

Set the passwords for the Audit Vault Server users:

UserPurpose
Super AdministratorAdministrative user
Super AuditorAuditor user
RootRoot OS user
SupportSupport user

Username Requirements

  • The first character is alphabetical

  • Each remaining character is alphanumeric or an underscore (_), dollar sign ($), or number sign (#)

Password Requirements

For Unicode characters (non-English):

  • Between 8 and 30 characters long

For English-only ASCII printable characters:

  • Between 8 and 30 characters long

  • Contain at least one of each:

    • Lowercase letters: a-z

    • Uppercase letters: A-Z

    • Digits: 0-9

    • Punctuation marks: , . + : ! _

  • Not contain double quotes ("), backspace, or control characters

Oracle also recommends:

  • Not be the same as the username

  • Not be an Oracle reserved word

  • Not be an obvious word

  • Not contain repeating characters

Configure the Users

  1. Super Administrator:

    • Enter the administrator username

    • Enter the password and confirm it

    • Click Validate username

  2. Super Auditor:

    • Enter the auditor username

    • Enter the password and confirm it

    • Click Validate username

  3. Repository Encryption:

    • Enter the Keystore Password

    • Audit event data is automatically encrypted using Oracle Database Transparent Data Encryption (TDE)

    • The keystore password is required to reset the TDE master key

  4. Root Password:

    • Enter the password for root

    • Confirm it in the Re-enter New Password field

  5. Support User Password:

    • Enter the password for the support user

    • Confirm it in the Re-enter New Password field

Step 4: Set the Audit Vault Server Time

Strongly Recommended: Configure the time settings.

  1. Time Setup:

    • Select Set Manually

⚠️ DNS Setup Note: Set Audit Vault Server DNS server values only if the network has DNS servers. Otherwise, system performance will be impaired.

  1. Save the Configuration:

    • Click Save in the upper right corner

Step 5: Log In to the Audit Vault Server Console

  1. Redirect to Login Page:

    • After clicking Save, the server redirects to the Login page

  2. Provide Credentials:

    • Enter the username and password

    • Click Login

  3. Audit Vault Home Page:

    • After a successful login, the server redirects to the Audit Vault Server console home page

Result: Congratulations! Audit Vault Server 12.2.0.4.0 installation is now complete.


The Complete Installation Flow

text
┌─────────────────────────────────────────────────────────────────┐
│  1. MEDIA DOWNLOAD                                              │
│     Download from Oracle eDelivery (~12.6 GB)                   │
└──────────────────────────┬──────────────────────────────────────┘
                           │
                           ▼
┌─────────────────────────────────────────────────────────────────┐
│  2. PREREQUISITES                                               │
│     Host: 8GB RAM, 100GB HDD, VirtualBox                        │
│     Guest: IP 192.168.56.68, Subnet 255.255.255.0               │
└──────────────────────────┬──────────────────────────────────────┘
                           │
                           ▼
┌─────────────────────────────────────────────────────────────────┐
│  3. INSTALLATION                                                │
│     Create VM → Configure disks → Start installation            │
│     Insert disks → Set passphrase → Configure network           │
│     Wait for first reboot (~1 hour)                             │
└──────────────────────────┬──────────────────────────────────────┘
                           │
                           ▼
┌─────────────────────────────────────────────────────────────────┐
│  4. POST INSTALLATION                                           │
│     Web console → Set passwords → Configure time → Login        │
└─────────────────────────────────────────────────────────────────┘

Key Configuration Summary

ItemValue
AV Server IP192.168.56.68
Subnet Mask255.255.255.0
Gateway192.168.56.1
Web Console URLhttps://192.168.56.68
Disk Size220 GB minimum
Memory (Test)2 GB minimum (3 GB recommended)
Media Size~12.6 GB

Best Practices

PracticeDescription
Do Not Modify the OSNever make unauthorized changes to the appliance OS
Use Strong PassphrasesFollow the password complexity requirements
Document Passwords SecurelyStore passwords in a secure password manager
Set the TimeConfigure the server time accurately for audit accuracy
Avoid DNS If Not NeededOnly configure DNS if your network has DNS servers
Allocate Sufficient DiskEnsure at least 220 GB for the virtual disk
Be Patient with First RebootThe first reboot can take up to an hour
Back Up ConfigurationBack up the AVDF configuration after setup
Follow Oracle DocumentationAlways refer to official Oracle documentation

Troubleshooting Common Issues

IssuePossible CauseSolution
Installation terminatesVirtual disk < 220 GBRecreate the VM with at least 220 GB
Cannot access web consoleNetwork misconfigurationVerify IP, subnet, and gateway settings
Certificate warningSelf-signed certificateClick "Add Exception" and confirm
Passphrase rejectedWeak passphraseUse a stronger passphrase meeting requirements
First reboot takes too longLarge configurationBe patient—it can take up to an hour
Web console won't loadService not startedWait for the reboot to complete
Username validation failsInvalid charactersUse only allowed characters in the username
Password validation failsMissing complexityInclude uppercase, lowercase, digit, and punctuation

Summary

Installing Oracle Audit Vault Server 12.2.0.4 involves the following key phases:

  1. Media Download: Obtain the installation media from Oracle eDelivery (~12.6 GB)

  2. Prerequisites: Prepare the host machine and guest VM with adequate resources

  3. Installation: Create the VM, configure disks, run the installer, and set the passphrase

  4. Post Installation: Configure users, passwords, time settings, and log in to the web console

Key Points to Remember

  • The Audit Vault Server is a software appliance — do not modify the OS

  • The virtual disk must be at least 220 GB or the installation will terminate

  • The installation passphrase must meet complexity requirements and be stored securely

  • The first reboot can take up to an hour — be patient

  • The web console is accessed at https://192.168.56.68

  • DNS should only be configured if your network has DNS servers

  • User passwords must meet strict complexity requirements

  • Repository encryption uses Oracle TDE for audit data protection

Why This Matters

Oracle Audit Vault and Database Firewall is essential for:

  • Regulatory Compliance: Helps meet SOX, HIPAA, PCI-DSS, and GDPR requirements

  • Database Security: Monitors and controls database traffic in real time

  • Centralized Auditing: Collects audit data from multiple databases into one repository

  • Threat Detection: Identifies suspicious database activity

  • Audit Reporting: Provides comprehensive reports for auditors and administrators

  • Separation of Duties: Separates the auditor role from the administrator role

By mastering the installation of Oracle Audit Vault Server, you can build a robust database security and auditing infrastructure that protects your organization's most critical data assets.


References

  • Oracle Documentation: Oracle Audit Vault and Database Firewall Installation Guide

  • Oracle Documentation: Oracle Audit Vault and Database Firewall Administrator's Guide

  • Oracle eDelivery: Oracle Audit Vault and Database Firewall 12.2.0.4 Media

  • My Oracle Support: Oracle Audit Vault and Database Firewall Certification Matrix

  • Related Articles: Oracle Database 19c Installation, Oracle GoldenGate Installation

No comments:

Post a Comment