Testing

Virtual Classroom: Performance Testing Using the Oracle Cloud for Upgrades and Migrations

Register here!

for Mar 17, 2021 – 10:00h CET

Virtual Classroom Web Seminar No.9:

Performance Testing Using the Oracle Cloud for Upgrades and Migrations

Everybody talks “cloud”, but what about the practicalities? We’ve already delivered a full 2-hour talk about how to migrate to the Oracle Cloud (“Move to the Cloud—Not Only for Techies”), and this time we’ll go beyond pure migration. How do you test? What are the best practices? And which special features can you expect in the various cloud deployments? We assume you have on-prem databases, and you either use the cloud for testing only, or …

Continue reading...

Upgrade Testing – Online Clone a PDB to 19c

In the past I wrote some articles about cloning PDBs to new environments. And I added a post about RELOCATE as well. But I realized that I have no specific blog post about a very typical scenario: Upgrade Testing – Online Clone a PDB to 19c.

Upgrade Testing - Online Clone a PDB to Oracle 19c

Photo by Jørgen Håland on Unsplash

My Setup

I have an Oracle 12.2.0.1 CDB with a PDB, and another Oracle 19.6.0 CDB. I will hot clone the PDB from 12.2.0.1 to the higher version CDB, and then upgrade the PDB.

Upgrade Testing - Online Clone a PDB to Oracle 19c

The motivation to do it this way is to allow testing for the application …

Continue reading...

Why people don’t patch and upgrade?!?

Please see the JAPANESE version of this blog post here!!

Discussing the topic “Why Upgrade” or “Why not Upgrade” is not always fun. Actually the arguments repeat from customer to customer. Typically we hear things such as:

  • A PSU or Patch Set introduces new bugs
  • A new PSU or Patch Set introduces new features which lead to risk and require application verification
  • Patching means risk
  • Patching changes the execution plans
  • Patching requires too much testing
  • Patching is too much work for our DBAs
  • Patching costs a lot of money and doesn’t pay out

And to be very honest sometimes it’s …

Continue reading...