Menu
Home
Services
About
Training
GoldenGate
Resources
Log In
Log Out
Gavin's Oracle Knowledge Base
Search For
Search
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 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 →
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 →
Security
Oracle 23c Schema Level Privileges and Schema-Only Users
Upgrade Audit Vault and Database Firewall to release 20.6
Oracle 19c Data Vault Tutorial
Oracle 19c Database and Windows AD Integration
Oracle AVDF 20.4 and OCI Autonomous Database Auditing
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
Enterprise Manager Cloud Control 13c Release 5 Upgrade
Oracle Enterprise Manager Cloud Control (release 13.4) – installation and configuration on Windows
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
View all →
Oracle Cloud
How to configure a Distribution and Receiver path between two different OCI GoldenGate Cloud Service Deployments
Oracle GoldenGate Cloud Service for MS SQL Server
Oracle GoldenGate Cloud Service – Purge Trail Files using REST API
Resolving ORA-29003: SSL transport detected mismatched server certificate
Loading data from Oracle Cloud Autonomous Database to Snowflake using Oracle Data Integrator
View all →
Oracle 23c
Oracle 23c Lock-Free Reservations and GoldenGate 23c Replication support
Oracle Database 23c New Feature – Domains
GoldenGate23c Replication with Oracle Database New Feature – BOOLEAN Data Type
GoldenGate 23c Tutorial – Create a database connection
Install Oracle GoldenGate 23c Free Release (Part 2 – software install and Configuration Assistant)
View all →
Oracle 19c
Oracle 19c Data Vault Tutorial
Upgrading from 12c Release 2 to 19c using latest AutoUpgrade utility
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 18c
How to perform an Oracle 18c Container and Pluggable Database upgrade using dbupgrade
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
GoldenGate23c Replication with Oracle Database New Feature – BOOLEAN Data Type
GoldenGate 23c Tutorial – Create Pipelines
GoldenGate 23c Tutorial – Create a database connection
Install Oracle GoldenGate 23c Free Release (Part 2 – software install and Configuration Assistant)
Install Oracle GoldenGate 23c Free Release (Part 1 – using Docker)
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 →
Zero Downtime Migration
Oracle database 12c to 21c online migration using ZDM (Zero Downtime Migration) – Part 6
Oracle database 12c to 21c online migration using ZDM (Zero Downtime Migration) – Part 5
Oracle database 12c to 21c online migration using ZDM (Zero Downtime Migration) – Part 4
Oracle database 12c to 21c online migration using ZDM (Zero Downtime Migration) – Part 3
Oracle database 12c to 21c online migration using ZDM (Zero Downtime Migration) – Part 2
View all →