OCI Database Cloud Patching of Database & Infrastructure With CLI

Oracle Patching of Databases (DB) and Grid Infrastructure (GI) is a routine and recommended process for any Oracle ...

OCI Database Cloud Service Patching of Database and Grid Infrastructure Using OCI CLI

Tips for Better Capacity Planning on Exadata

Exadata X8-2 comes with up to 3 Petabytes (PB) of raw disk capacity. This post briefly explains the basics of capacity ...

Part Six: Deploying High Availability Applications in Oracle Cloud Infrastructure

This is the sixth in a series of blog posts, that covers the details to deploy the Oracle Management Servers for a high ...

Statspack vs. AWR: Wrong number of SQL Executions

This post is about a Statspack anomaly I discovered while analyzing execution trends of a particular SQL on one of our ...

ExaCC vs. ExaCS – Which One is Right for You?

Exadata has been Oracle’s gold standard platform for running mission-critical Oracle databases for over a decade. ...

Fixing the Failed Status of imageinfo on Exadata Compute Node

Background I was conducting regular OS patching of all the Exadata components when one of compute nodes caused ...

RAC – Clusterware Intermittently Fails to Start

While working on a new Grid Infrastructure installation on Red Hat V8.4, we had some issues testing a new cluster: The ...

Part Five: Deploying High Availability Applications in Oracle Cloud Infrastructure— SSL Certificates and Load Balancer Setup

This is the fifth in a series of blog posts that covers setting up the load balancer for a high available setup of ...

Restoring a Dropped Oracle PDB Without a CDB Backup

Background I ran into a situation where we needed to restore just one dropped (and recreated) pluggable database (PDB) ...

OEM 12.5: Tablespace Allocation Metric Not Collected—Agent Is Running but Not Ready

Background I ran across an interesting case within OEM 12 (Oracle Enterprise Manager) Release 5. A client reported the ...

Database Upgrade Fails With “unexpected error in validate_credentials”

This is a blog post about an issue that can occur during a database upgrade and produces a misleading error message. If ...

Exadata: Automating Compliance Checks

Introduction to Autonomous Health Framework (AHF) I wanted to share a brief summary–a cheat sheet–to highlight the ...

Oracle Scheduler Job is Not Running as Expected After Bouncing Databases

Background One of our clients had issues with their scheduler jobs in DEV and PROD databases and all scheduler jobs ...

Migration and Upgrade from EC2 to RDS Using DBMS_FILE_TRANSFER

Performing a simple manual migration and upgrade from EC2 to RDS without using S3 Object Storage: Here I will give a ...

Oracle Exadata ASR General Troubleshooting

Context Oracle Auto Service Request (ASR) is a secure, scalable, customer-installable software feature of warranty and ...

How to Resize Exadata Grid Disks Without an Outage

As you might know, each Exadata cell contains 12 physical disks with a fixed size. If you want to increase the ASM disk ...

ORA-19665: Size in File Header Does Not Match Actual File Size of String

I received the above message related to an ORA-7445 on my 11.2.0.4 database: ORA-07445: exception encountered: core ...

Adding DML Parallelization to Oracle Jobs

Intro When investigating why an Oracle job is taking a long time to execute, normally the DBA will identify the DML ...

Exadata Health Check: My Top 5 Tools and Features

From ORAchk/EXAchk/ODAchk, Database Security Assessment Tool (DBSAT) and Hang Manager, to Cluster Health Advisor (CHA), ...

Part Three: Deploying High Available Applications in Oracle Cloud Infrastructure – Instance Clone and Linux Storage Appliance

This is the third in a series that covers the details to deploy a high-available setup of Oracle Enterprise Manager ...

EBS: Access the PDF Outputs After the Migration to AWS

During the Oracle E-Business Suite migrations from on-premise to AWS Cloud (similar to any cloning exercise), you may ...

Part Four: Deploying High Availability Applications in OCI—OEM 13.5 Setup

This is the fourth in a series of blog posts that covers the details to deploy a high available set up of Oracle ...

CVE-2021-44228 and Your Oracle E-Business Suite/Fusion Middleware Systems

For many of us, the recent log4j vulnerability (CVE-2021-44228) became a severe headache this past weekend. I thought ...