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

Top Three Use Cases for Google Cloud Spanner

Since its launch in 2017, Google Cloud Spanner has built a reputation that’s very different from traditional databases. ...

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

Making the Always On Availability Groups More Resilient to Transient Network Issues

More and more companies are adopting the Always On Availability Groups as their HA/DR architecture for the SQL Server ...

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

How to Migrate Oracle Applications 11.5.10.2 from on-premises SunOS fleet to Linux on AWS

It’s no secret that many companies have been moving existing on-premises environments to the cloud. They all have ...

Orchestrating dbt Pipelines With Google Cloud: Part 1

In my previous post I showed you how to use dbt to expedite data preparation tasks on Google BigQuery. This time, I’ll ...

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

Renewing the (Default) PMM Certificate

Introduction Recently one of our colleagues was struggling with the default self-signed SSL certificate that ships with ...

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

Oracle Exadata ASR General Troubleshooting

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

Automated Database Backups for Cloud Spanner Using Terraform

This post shows how to use cloudspannerecosystem/scheduled-backups to configure scheduled backups for your cloud ...

Practical Tips For Moving Indexes Between Tablespaces

From time to time, a simple request to reorganize space in a tablespace leads to a more complex solution. Here’s how we ...

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

Why Comprehensive Health Checks for MS SQL Servers Matter: Part 1

How you access and retrieve data is crucial to your database’s performance and resilience: the more transactional or ...

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

Licensing Oracle Enterprise Manager

What are the licensing considerations for deploying Oracle Enterprise Manager and using OEM for monitoring database ...