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

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 ...

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 ...

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 ...

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 ...

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 ...