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

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? 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 you may know this: https://mikedietrichde.com/hands-on-lab/hol-18c-upgrade/#TZ And you…

Install components in Multitenant ALWAYS with catcon.pl

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. How to install a component afterwards in Single-/Multitenant? I haven’t checked all the MOS Notes but I recognized that some MOS Notes explaining how to (re-)create a component such as JVM are not updated to deal with a Single and/or Multitenant environment as they simply call the scripts from SQL*Plus. But the key to script execution in such an environment is catcon.pl, the perl driver meant to execute database scripts not only in…

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

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 my colleague, Krishnakumar Kunka  🙂 -Mike