Knowledge Base Categories

• Backup and Recovery

  • 19c Container Database Data Guard Configuration
  • Oracle 12c RMAN DUPLICATE Database
  • 12c Multitenancy Backup and Recovery
  • 12c RMAN New Feature – Cross Platform Data Transport Using Incremental Backups
  • Creating an Oracle 12c Data Guard Active Standby Database

  View all →

• Oracle 19c

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

  View all →

• Security

  • Oracle 19c Database and Windows AD Integration
  • Oracle AVDF 20.4 and OCI Autonomous Database Auditing
  • Auditing SQL Server 2019 with AVDF 20.4
  • Oracle GoldenGate and Audit Vault working together!
  • Database Firewall 20.4 – Block and Substitute SQL

  View all →

• Scripts

  • ASH and AWR Performance Tuning Scripts
  • DBUPGDIAG script to check integrity of database before 11g upgrade
  • Script – Check RMAN Backup Status
  • Script – Sessions with high physical reads
  • Script – Database structure and file location

  View all →

• RMAN

  • 19c Container Database Data Guard Configuration
  • Oracle 12c RMAN DUPLICATE Database
  • 12c Multitenancy Backup and Recovery
  • Restoring a ASM backup to non-ASM and restoring from RAC to single-instance
  • Performing a 32 bit to 64 bit migration using the Transportable Database RMAN feature

  View all →

• Real Application Clusters

  • Installation and Configuration of GoldenGate 19c Microservices on RAC
  • How to install and configure Oracle 12c Release 2 RAC environment on VirtualBox Part 3
  • How to install and configure Oracle 12c Release 2 RAC environment on VirtualBox Part 2
  • How to install and configure Oracle 12c Release 2 RAC environment on VirtualBox Part 1
  • Oracle 19c Grid Infrastructure Upgrade

  View all →

• Performance Tuning

  • Oracle 19c New Feature Compare Execution Plans with DBMS_XPLAN.COMPARE_PLANS
  • Oracle 19c New Feature Automatic Indexing
  • Oracle 19c New Feature Hint Usage Report
  • Oracle 19c New Feature High-Frequency Statistics
  • Oracle 19c New Feature Real-Time Statistics

  View all →

• Partitioning

  • Oracle 19c New Feature Hybrid Partitioned Tables
  • Oracle 18c New Feature – Online Partitioning Strategy Modification
  • Oracle 12c Release 2 Partitioning New Features
  • Oracle 12c Partitioning New Features

  View all →

• Oracle Fusion Middleware

  • Installing 11g Fusion Middleware Forms and Reports 11.1.2
  • Configuring APEX 4.2 and the APEX Listener on Oracle 11g WebLogic Server
  • Oracle 11g Fusion Middleware Installation on Linux
  • Cloning 10g Application Server Middle Tier
  • How To Migrate OID Users Between Two 10g iAS Environments

  View all →

• Oracle Enterprise Manager

  • Oracle Enterprise Manager Cloud Control 13.4 Patching
  • Installing and configuring the Exadata Database Machine plug-in for EM Cloud Control
  • Installing the Oracle GoldenGate monitoring plug-in (13.2.1.0.0) for Cloud Control 13c Release 2
  • PSU Patch Deployment using EM12c
  • Database Cloning and Provisioning using EM12c DBaaS

  View all →

• Oracle Cloud

  • Oracle AVDF 20.4 and OCI Autonomous Database Auditing
  • Exadata and the Oracle Cloud ATP Database
  • Oracle GoldenGate on Oracle Cloud Marketplace (Part 2)
  • Data migration to Autonomous Database using MV2ADB
  • Migrate data in real-time from OCI Classic to OCI using MV2ADB and Oracle Cloud Marketplace GoldenGate

  View all →

• Oracle 21c

  • Oracle 21c New Feature – MAX_IDLE_BLOCKER_TIME parameter
  • 21c New Feature – Expression based parameter values
  • 21c New Feature – Attention Log
  • 21c New Feature – Result Cache for Standby Database
  • 21c New Feature – Data Guard Broker Create Far Sync Instance

  View all →

• Oracle 18c

  • How to perform an Oracle 18c Container and Pluggable Database upgrade using dbupgrade

  View all →

• Data Guard

  • 21c New Feature – Result Cache for Standby Database
  • 21c New Feature – Data Guard Broker Create Far Sync Instance
  • Oracle 21c New Feature – Prepare Database for Data Guard
  • 19c FSFO Observer – some findings
  • Data Guard Observer 19c – Observe Only Mode new feature

  View all →

• Oracle 12c

  • Upgrading from 12c Release 2 to 19c using latest AutoUpgrade utility
  • Applying the July 2019 Database Release Update Patch
  • Oracle Database 12.2 New Feature – Pluggable Database Performance Profiles
  • Oracle 12c Resource Manager – CDB and PDB resource plans
  • Oracle Grid Infrastructure Patch Set Update 12.1.0.2.2 (Jan 2015)

  View all →

• Oracle 11g

  • RMAN 11g new feature – Backup Fast Recovery Area (FRA) to Disk
  • Diagnosing and Repairing Failures with 11g Data Recovery Advisor
  • Upgrading 11gR2 RAC Grid Infrastructure to 11.2.0.3
  • Oracle 11g Cross Platform Active Standby – Windows Primary database and Linux Active Standby
  • Upgrading to 11g Release 2 and DST Updates

  View all →

• News

  • Oracle GoldenGate and Oracle 12c Online Training Commencing January 2017
  • Now an Oracle 12c Certified Master Database Cloud Administrator
  • Presenting at AUSOUG and AIOUG Conferences in November

  View all →

• Multitenancy

  • 19c Container Database Data Guard Configuration
  • Oracle 12c to 19c Data Guard Upgrade with 19c Container Database
  • Upgrade Oracle 12c non-CDB to Oracle 19c and plugin to CDB
  • Pluggable Database Cloning using Snapshot Copy
  • Oracle 18c Multitenancy New Features – Snapshot Carousel, CDB Fleet and Container Maps

  View all →

• Installation

  • Cloning an Oracle 19c Oracle Home
  • How to install the Oracle 18c RPM-based database software
  • Oracle 18c RPM Based Software Installation
  • 12c Release 1 database software installation on Linux
  • Using the oracle-validated RPM to install Oracle 11g on Linux

  View all →

• High Availability

  • Minimal Downtime Cross Platform Migration and 12c Database Upgrade using Data Guard
  • Plugging an Oracle 12c pluggable database into a Data Guard container database
  • Creating an Oracle 12c Data Guard Active Standby Database
  • Minimal downtime rolling database upgrade to 12c Release 1
  • 11g Data Guard Cascading Standby Database

  View all →

• GoldenGate

  • GoldenGate How to handle replication with extra columns on source and target tables
  • Installation and Configuration of GoldenGate 19c Microservices on RAC
  • Oracle GoldenGate on Oracle Cloud Marketplace (Part 2)
  • Oracle GoldenGate on Oracle Cloud Marketplace (Part 1)
  • Oracle GoldenGate 18c New Features

  View all →

• E-Business Suite

  • Upgrading the 10g E-Business Suite database to 11.2.0.3
  • Migrating the 11i E-Business Suite database to Linux
  • Using the adodfcmp and FndXdfCmp utilities to manually create and verify 11i database objects

  View all →

• Database Upgrade

  • Upgrading from 12c Release 2 to 19c using latest AutoUpgrade utility
  • Oracle 21c AutoUpgrade (Part 2)
  • Oracle 21c AutoUpgrade (Part 1)
  • Oracle 12c to 19c Data Guard Upgrade with 19c Container Database
  • Upgrade Oracle 12c non-CDB to Oracle 19c and plugin to CDB

  View all →

• Database Administration

  • Oracle 21c New Feature – MAX_IDLE_BLOCKER_TIME parameter
  • 21c New Feature – Expression based parameter values
  • Cloning an Oracle 19c Oracle Home
  • Applying the July 2019 Database Release Update Patch
  • Oracle 18c New Feature Private Temporary Tables

  View all →

• Unix

  • Unix – tar and gzip commands
  • Unix for the Oracle DBA – Part 1
  • Performance Tuning Tips and Techniques
  • Data Guard Log Shipping Report
  • Add color to the Unix PS1 prompt

  View all →