Silent Rollback From an Out-of-Place Patching For Oracle 19c GI

My last post dealt with -->

My last post dealt with how to do an out-of-place patching for Oracle GI (Grid Infrastructure). The next thing I wanted ...

Oracle E-Business Suite Database Upgrade to 19c

Oracle E-Business Suite has been certified with Oracle Database 19c for over a year now. We've been seeing an uptick in ...

Scaling ProxySQL Rapidly in Kubernetes

Editor’s Note: Because our bloggers have lots of useful tips, every now and then we update and bring forward a popular ...

Oracle Database and 2FA Using Cisco Duo

Background Oracle Database connectivity using multi-factor (MFA) or two-factor (2FA) authentication is rather simple to ...

Testing the 19c Grid Infrastructure by Performing a Dry-Run Upgrade

Testing oracle grid infrastructure upgrades Editor’s Note: Because our bloggers have lots of useful tips, every now and ...

Where in a Modern Data Platform Should You Process Your Data?

Data warehouse or data lake? We break down the pros and cons of each In the book Designing Cloud Data Platforms, ...

Silent Out-of-Place Patching For Oracle 19c GI

Troubleshooting OCI automatic backups

I am going through a process of ...

Troubleshooting OCI automatic backups I am going through a process of patching an Oracle Grid Infrastructure (GI) from ...

Save Time With This Quick OCI CLI Installation

Editor’s Note: Because our bloggers have lots of useful tips, every now and then we update and bring forward a popular ...

TNS-12564 Errors and the Importance of LOCAL_LISTENER During a Data Guard Switchover

A couple of weeks ago a client of mine had a situation where a Data Guard (DG) ...

A couple of weeks ago a client of mine had a situation where a Data Guard (DG) switchover that should have taken five ...

How I Finished a Recovery From an Active Duplicate After Facing Errors ORA-19909 and ORA-01110

The other day I was doing a database cloning in 11.2.0.4 from an active duplicate, ...

The other day I was doing a database cloning in 11.2.0.4 from an active duplicate, and got the following error: ...

Embracing the New Normal with Google Workspace - Part One

“The only thing that is constant is change.” - Heraclitus, Greek Philosopher, 535 BCE to 475 BCE While change might be ...

Configuring MySQL in a Docker Container

Editor's Note: Because our bloggers have lots of useful tips, every now and then we update and bring forward a popular ...

Ansible Inventory Automation Using Consul and Orchestrator

Here at Pythian we get a lot of exposure to new technologies and implementation strategies via the work we do ...

Migrating Oracle Workloads to Google Cloud - PostgreSQL on Cloud SQL or GCE

When working with clients on database migration, there are a range of options we help them assess and evaluate. These ...

Best practice recommendations for Windows hosting SQL server on VMware

Did you know it's very important to ensure that your VMware environment is properly set when hosting SQL Server ...

Issues With Database Service Names Starting With Pluggable Database (PDB) Name

In this post I'll describe a problem which occurs when creating and using a database service name which starts with the ...

Create 19c Database in Archive Mode Using DBCA Silent

I wanted to export 11.2 database schema and import it into a 19c database; creating the database in archive mode to ...

Heart Disease Prediction Using Keras Deep Learning

Heart disease covers a range of different conditions that could affect your heart. It is one of the most complex ...

Converting Oracle Enterprise Manager Management Service (OMS) Repository from Legacy Non-CDB to CDB Architecture

The other day I was given the task of converting a single instance Oracle ...

The other day I was given the task of converting a single instance Oracle Enterprise Manager Management Service (OMS) ...

Automatic Flashback Of Standby Database in Oracle 19c

Oracle 19c Data Guard introduced a very cool feature — you can now automatically ...

Oracle 19c Data Guard introduced a very cool feature — you can now automatically flashback your standby if you ...

How I Finished a GI OOP Patching From 19.6 to 19.8 After Facing cluutil: No Such File or Directory and clsrsc-740 Errors

This past weekend I was doing a production grid infrastructure (GI) out-of-place ...

This past weekend I was doing a production grid infrastructure (GI) out-of-place patching (OOP) from 19.6 to 19.8 for a ...

Migrating Oracle Workloads to Google Cloud - BMS

In these challenging and ever-changing times, most organizations would welcome the opportunity to reduce overhead, ...

How to Fix the Status of the Oracle GI CRS After a Failed Upgrade

Editor's Note: Because our bloggers have lots of useful tips, every now and then we update ...