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

OPatchAuto Bug on 19.3 GI/RDBMS When Patching to 19.6

Background

The other day I was doing a fresh install of Oracle 19.3. I ...

Background The other day I was doing a fresh install of Oracle 19.3. I was using the binaries from edelivery, doing ...

Setting up MySQL Monitoring With New Relic Infrastructure Pro

Intro If you have a New Relic Infrastructure Pro license, and unmonitored MySQL servers, there's now an easy solution ...

ProxySQL Query Rules: Notes From Production

Query Statspack's "SQL ordered by" Sections Over a Time Period

In this post, I'll present the statspack_top_sqls.sql script, which returns SQL performance statistics by mining the ...

Mining Statspack and AWR Repositories for Historical Trends

There are various ways that we can approach the analysis of a past database performance problem. The initial steps ...

Postgres Security Patches Related to the Search Path

There were some security patches released this month for Postgres, to put further restrictions on pathways that ...

Resolving Error ORA-28353: Failed to Open Wallet

Troubleshooting TDE wallet failures after october 2018 patching

Full ...

Troubleshooting TDE wallet failures after october 2018 patching Full disclosure: this is a post I've had in draft mode ...

Overcoming ORA-01722 Error While Doing an Upgrade With Different DST Versions

This will be a short entry, but hopefully, it will help if you face the error "ORA-01722: ...

This will be a short entry, but hopefully, it will help if you face the error "ORA-01722: invalid number" while doing ...

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

Postgres partial indexes on email address domains

When I first heard of Postgres partial indexes, I knew immediately that this would have solved a problem I had in MySQL ...

Using SQLCODE Function

The idea of this post is to show how to handle errors using SQLCODE function. That function shows the code error for ...

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

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

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

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

Cassandra Vulnerability - CVE-2020-13946 - Apache Cassandra RMI Rebind Vulnerability

On September 1, 2020, Apache disclosed a security vulnerability for Apache Cassandra. Summary: It's possible for a ...

CreateGoldImage Followup - Is CreateGoldImage Required for Cloning Oracle Home?

Comparing CreateGoldImage and Traditional Tar Cloning On October 31, 2019, I blogged about How To Use CreateGoldImage ...

Leading Through Crisis – What Ernest Shackleton Can Teach Us About the COVID Pandemic

In January 1915, polar explorer Ernest Shackleton’s ship became trapped in ice near Antarctica. For the next two years, ...

Management and Troubleshooting Features: Data Guard Command-Line Interface (DGMGRL) 19c

With Oracle Data Guard promising high availability, data protection and disaster recovery for enterprise data, it's ...

Exadata's InfiniBand Switch: Incorrect NTP settings Leading to Evictions, and Patching Recommendations

Overview This post describes a recent outage during a routine Exadata (X7-2) patching to the 19.2.12.0.0.200317 release ...

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

EM 13c: Patching Oracle Enterprise Manager With Release 4 Update 6 (13.4.0.6)

This week I had the opportunity to patch Oracle Enterprise Manager (EM) 13c with ...

This week I had the opportunity to patch Oracle Enterprise Manager (EM) 13c with Release 4, Update 6: RU6 (13.4.0.6). I ...

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