• 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…

  • GoldenGate How to handle replication with extra columns on source and target tables

    Case A – Additional Column on Target Table In this example the JOBS table on the target database oradb2 has an additional IDENTITY COLUMN called ID SQL> conn demo/oracle@oradb1Connected.SQL> desc jobsName Null? Type—————————————– ——– —————————-JOB_ID NOT NULL VARCHAR2(10)JOB_TITLE NOT NULL VARCHAR2(35)MIN_SALARY NUMBER(6)MAX_SALARY NUMBER(6)SQL> conn demo/oracle@oradb2Connected.SQL> alter table jobs add (ID…

  • Installation and Configuration of GoldenGate 19c Microservices on RAC

    In this note we will cover how to install and configure Oracle Goldengate 19c Microservices on an Oracle 19c RAC environment. We will then configure high availability for GoldenGate Microservices using Grid Infrastructure Agent XAG v10. Finally we will test the high availability by simulating a RAC node failure and…

  • Oracle Enterprise Manager Cloud Control 13.4 Patching

    This note shows the procedure used to apply the June 2020 patches to an OEM 13c Release 4 Cloud Control environment and also the work around adopted to overcome the error OMSPatcher failed with error code = 241 Download the note ….