• Oracle 19c Database and Windows AD Integration

    This step-by-step tutorial demonstrates how to configure Kerberos-based authentication in an Oracle 19c database and also how to configure Centrally Managed Users (CMU). CMU is the integration of the Oracle database with Microsoft Active Directory to allow centralized authentication and authorization of users. Download the note below.

  • Oracle AVDF 20.4 and OCI Autonomous Database Auditing

    This note describes the process used to configure and deploy Oracle Audit Vault and Database Firewall 20.4 in Oracle Cloud Infrastructure OCI via Cloud Marketplace. The note also covers the installation of the AVDF Agent on an OCI compute node and enabling auditing of an Autonomous Transaction Processing 19c database…

  • Auditing SQL Server 2019 with AVDF 20.4

    In this note we will see how we can add the MS SQL Server 2019 Adventure Works database to be a target in AVDF 20 Release 4. Enable auditing for the HumanResources.EmployeePayHistory table in SQL Server Adventure Works database. Access the HumanResources.EmployeePayHistory table and note that the audit file with…

  • Oracle GoldenGate and Audit Vault working together!

    The Oracle GoldenGate Integrated Extract process will capture changes from the transaction logs (in the case of Oracle database, the redo log files) and then these are written to GoldenGate trail files in XML format. Oracle Audit Vault and Database Firewall Transaction Log collector will forward transaction log records from…

  • Database Firewall 20.4 – Block and Substitute SQL

    The Database Firewall analyzes and inspect SQL statements before they reach the database and based on the firewall policy which we configure, we can decide whether to allow, log, alert, substitute, or block the particular SQL statement. In this example, the sensitive SALARY column is blocked and the database firewall…

  • AVDF – Configure Alerts

    This note describes how to create AVDF Critical and Warning alerts. We will generate an alert when failed login attempts exceeds a defined threshold and also an alert when a privileged user like the DBA modifies data in a table marked as ‘sensitive’. Open the Policies menu and click on…

  • AVDF Configure Sensitive Data Report

    This note describes the process of granting the AVDF_ADM user the AV_SENSITIVE database role and executing the Sensitive Data report via the AVDF console. Execute the av_sensitive_role script Connect via SSH to the Audit Vault server as the support user login as: supportAudit Vault Server 20.3.0.0.0DO NOT CHANGE ANY CONFIGURATIONS…

  • Install AVDF Agent and Register Target

    Connect as AVDF_ADM user Click on Register Enter the name and IP Address of the server where the AVDF agent is being deployed Click on Save and make a note of the Activation Key – we will need this later Download the Audit Vault Agent Copy the downloaded AVDF agent…

  • Oracle Audit Vault & Database Firewall 20.4 (Part 2)

    This note describes the various steps taken to install and configure Database Firewall (AVDF) version 20.4 on VirtualBox. This follows Part 1 where we have installed Audit Vault release 20.4. Install Database Firewall 20.4 Create a VirtualBox Linux VM with a VDI file of at least 225 GB Attach the…

  • Oracle Audit Vault & Database Firewall 20.4 (Part 1)

    This note describes the various steps taken to install and configure Oracle Audit Vault version 20.4 on VirtualBox. Download AVDF (Audit Vault and Database Firewall) 20.4 from https://edelivery.oracle.com     Install Audit Vault 20.4 Create a VirtualBox Linux VM with a VDI file of at least 225 GB Attach the…

  • Oracle 21c New Feature – MAX_IDLE_BLOCKER_TIME parameter

    One of the new features in Oracle 21c is the MAX_IDLE_BLOCKER_TIME parameter. So if a “blocking” session is pretty much idle, all the other possibly many “blocked” sessions do not have to keep waiting until the blocker session issues a commit or rollback. In Oracle Database 19c we could specify…

  • 21c New Feature – Expression based parameter values

    New in Oracle 21c is the ability to use an expression to derive the value of an initialization parameter. Oracle 21c allows us to base the value of a particular parameter which is derived from the existing value of some other parameter – or even based on the value of…

  • 21c New Feature – Attention Log

    Another new feature in Oracle 21c is the attention.log file. The database alert.log contains lots of information – but a lot of the content of the alert log is just “informational” in nature. Very often the DBA needs to process or interpret only information which requires his urgent attention. Rather…

  • 21c New Feature – Result Cache for Standby Database

    Oracle 21c introduces the ability to improve the performance of queries executed on the read-only active Standby Database by enabling the use of the Result Cache feature to store query results for recurring use- so not just enabled on the Primary database, but the Standby database as well. The new…

  • 21c New Feature – Data Guard Broker Create Far Sync Instance

    A new feature in Oracle 21c is the ability to create a Data Guard Far Sync Instance via Data Guard Broker. The DGMGRL command CREATE FAR_SYNC automates the entire process of creating the Far Sync database instance for a Data Guard Configuration. It internally runs the RMAN DUPLICATE TARGET DATABASE…

  • Oracle 21c New Feature – Prepare Database for Data Guard

    The Data Guard Broker PREPARE DATABASE FOR DATA GUARD command configures a database to be used as a Primary Database in a Data Guard Broker configuration. It enables and sets a number of database parameters like LOG_BUFFER, DG_BROKER_START, STANDBY_FILE_MANAGEMENT, DB_BLOCK_CHECKSUM etc. It also enables FLASHBACK and ARCHIVELOG for the database…

  • Upgrading from 12c Release 2 to 19c using latest AutoUpgrade utility

    This note describes the process of upgrading an Oracle 12c Release 2 Non-Container Database to Oracle 19c and also converting the Non-CDB database to a Pluggable Database (PDB). The entire upgrade process is automated using the latest Oracle autoupgrade utility – autoupgrade.jar which is part of the new Oracle 12c…

  • Oracle 21c AutoUpgrade (Part 2)

    This note describes the steps used to upgrade an Oracle 19c Pluggable Database (PDB) to Oracle 21c using the unplug/plug method via the new Autoupgrade utility. Source Container Database: ORCLCDB (19c ) Target Container Database: DB21C (21c ) ################################################################################################### 19c Pluggable Database ORCLPDB1 is hosted in 19c Container Database ORCLCDB…

  • Oracle 21c AutoUpgrade (Part 1)

    This note describes the steps used to upgrade an Oracle 19c database to Oracle 21c as well as convert the 19c Non-CDB database to a Pluggable Database (PDB) hosted in an Oracle 21c Container Database. Source Database: ORCL (19c Non-CDB ) Target Database: DB21C (21c CDB) ########################################################################### Create Auto Upgrade…

  • Exadata and the Oracle Cloud ATP Database

    Both the Oracle Autonomous Databases Serverless (ATP-S) as well as Dedicated (ATP-D) are built on Oracle Exadata back-end infrastructure. These features shown below are unique to Oracle Exadata and our ATP databases in the Oracle Cloud are able to provide the high performance because of the underlying Oracle Exadata platform…