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

My Top 10 to Tune In To at Google Cloud Next 21

Are you a developer wanting to integrate gamification for your colleagues’ reward strategy? Or a CEO focused on better ...

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

Python: Using Dataclasses to Model Your Data

Here at Pythian, we love our data. Our code is no exception (pun sort of intended), so I’ll be covering dataclasses in ...

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

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

How to Use DockerSlim to Reduce Image Sizes

Learn how to test the capabilities of docker-slim on Java and Python images and containerized Spring and Flask apps. If ...

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

SQL server distributed availability group with forwarder in Microsoft Azure

Architecture diagram To create a distributed availability group, you need two availability groups (AG) each with its ...

Exadata: Automating Compliance Checks

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

SQL Server AlwaysOn Availability Groups on Google Kubernetes Engine

This tutorial shows you how to configure SQL Server AlwaysOn availability groups (AG) using DH2i DxEnterprise and ...

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

How to Send Custom Emails and Notifications In Azure Data Factory

If you’ve used Azure Data Factory (ADF), you’ve probably sent email alerts. But these don’t provide any clarity or ...

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

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

Five Vital Questions to Ask Before Planning an SAP Migration

Last year, SAP announced another extension to its support deadline for legacy systems, pushing it from 2025 to the end ...

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