As a database professional with over 20 years of managing Oracle environments, I've seen firsthand how database security has evolved from a checkbox task to a mission-critical discipline. With threats becoming increasingly sophisticated and auditors relying more...
Oracle Blog Posts
Resolving Oracle Patch Issues: Troubleshooting ORA-20001 and Applying Datapatch
Keeping your Oracle database up to date with patches is crucial for both security and performance. However, patching issues can arise, leading to errors such as ORA-20001. In this blog, we'll walk through a real-world troubleshooting scenario where an Oracle 19c...
Using Oracle Cloud Storage with RMAN for Backups
Oracle Cloud Infrastructure (OCI) provides a secure and scalable Object Storage solution for storing database backups. By integrating Oracle Recovery Manager (RMAN) with Oracle Cloud Infrastructure (OCI), organizations can achieve efficient, cost-effective, and...
Restoring Database from OCI Cloud Storage (Standard Cloud Account)
Oracle Recovery Manager (RMAN) is a powerful tool for database backup and recovery. When integrated with Oracle Cloud Infrastructure (OCI) Object Storage, RMAN provides a seamless way to store and restore backups. This blog will guide you through the process of...
Where Is On-Premise Oracle 23ai?
Oracle Database 23ai marks a significant pivot in Oracle's product strategy, emphasizing a "Cloud-First, Developer-First" approach. This shift prioritizes cloud-native development and AI integration, leading to a notable absence of traditional on-premises releases. As...
Creating and Sizing the Oracle Fast Recovery Area
When creating the fast recovery area, place it on a separate disk from the database binaries and data files. For this example, I am using the C drive because this is on a VM, which is what is available. The size of your fast recovery will also depend on several...
Understanding Transparent Application Failover in Oracle Database
What is Transparent Application Failover (TAF)? TAF is a feature in Oracle that helps maintain database availability by automatically reconnecting client applications to a different database server when a failure occurs (such as a network failure or server crash) or...
Create Temporary Tablespace in Oracle and Make It the Default Temporary Tablespace
This article covers the steps to create a temporary tablespace in Oracle and make it the default temporary tablespace for the database. Step-By-Step This method works for both regular Oracle databases and multitenant databases. Each PDB and CDB has its own separate...
How to Upgrade Oracle Database to 19c
Below is a step-by-step guide to walk you through how to upgrade oracle database to 19c. Step 1 Download the Oracle 19c binaries, the latest version of OPatch, How To Download And Install The Latest OPatch (6880880) Version (Doc ID 274526.1) and the AutoupGrade Tool...