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...
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...
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...
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...
The ORA-00059 error can occur if you don't check the DB_FILES parameter before creating or cloning new PDBs in your CDB. Here are the steps to fix CDB when this error occurs. You can also proactively add this to your cloning Documentation to prevent the error from...
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...
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...
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...
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...
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...