catcon.pl

A kill-switch terminates blocking sessions during patching

You will find a good number of datapatch posts on my blog. And with Oracle AI Database 26ai from RU 23.26.0.0.0 onward (the October 2025 RU), we introduce a new functionality when you run datapatch: A kill-switch terminates blocking sessions during patching.

A kill-switch terminates blocking sessions during patching

Photo by Yuko Tanaka on Unsplash

What is changing?

From Oracle AI Database 26ai onwards by default the invocation of datapatch will terminate any session currently holding a requested KGL X lock (Kernel Generic Library cache), an exclusive lock on an SQL or an PL/SQL procedure.

In reality this means:

You invoke

Does the PDB$SEED get “time zone” patched or not?

Posted on December 17, 2018 by Mike.Dietrich Single-/Multitenant Time Zone - DST 4

Today I received a question from a very experienced Oracle ACS engineer whether the PDB$SEED get time zone patched or not when a time zone patch gets applied. I’d say spontaneously “Of course, it does” but after thinking for a few seconds I started having doubts. Question is: Does the PDB$SEED get “time zone” patched or not?

Does the PDB$SEED get "time zone" patched or not?

Photo by Luis Cortes on Unsplash

Time zone scripts are in ?/rdbms/admin since Oracle 18c

First of all, since Oracle Database 18c the scripts to adjust time zone settings of the database are in ?/rdbms/admin. If you did our Hands-On Lab already …

Install components in Multitenant ALWAYS with catcon.pl

Posted on March 2, 2017 by Mike.Dietrich Single-/Multitenant 11

I did blog several times about how to remove an unwanted component from a database. But yesterday I came across this interesting scenario worth a blog post.

Upfront information – 2026

Dear Reader,

this blog post is from 2017 when Multitenant was relatively new, and when not all tools were really comfortably aligned yet.

Nowadays, almost 10 years later, I typically use DBCA to add missing options to PDBs. Since I wrote this blog post in 2017, I actually did not use a manual method anymore. And I did not verify the procedures again due to time constraints.

My …

New MOS Notes on Database Upgrades for 12c with or without Oracle Multitenant

Posted on January 13, 2015 by Mike.Dietrich MyOracle Support Oracle Database 12c Single-/Multitenant 1

Please find some new MyOracle Support (MOS) Notes about Database Upgrades to Oracle Database 12c, with or without Oracle Multitenant:

MOS Note: 1503653.1
Complete Checklist for Manual Upgrades to Oracle Database 12c Release 1 (12.1)
.
MOS Note: 1932762.1
Complete checklist for manual upgrade from 12.1.0.1 to 12.1.0.N (Full CDB Upgrade)
.
MOS Note: 1933391.1
Complete checklist for 12c R1 PDB upgrade (Upgrading single/multiple PDB)
.
MOS Note: 1932340.1
How to execute sql scripts in Multitenant environment (catcon.pl)
.
MOS Note: 1933011.1
Complete Checklist for DBUA Upgrade from 12.1.0.1 to 12.1.0.N
.

Credits for the CDB/PDB Notes go to

catcon.pl

A kill-switch terminates blocking sessions during patching

What is changing?

Does the PDB$SEED get “time zone” patched or not?

Time zone scripts are in ?/rdbms/admin since Oracle 18c

Install components in Multitenant ALWAYS with catcon.pl

Upfront information – 2026

New MOS Notes on Database Upgrades for 12c with or without Oracle Multitenant

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Recent Posts