PDB CDB

[Laurel]

Hi Dear Erman!
How are  you ?
Hope all is good!
after upgrade to EBS 12.2.13 + 19c  apparently
PDB has a higher version of timezone file than a  CDB
The violation report run did not report  any violations on timezone versions.
and I also found the info that PDB can have higher version of timezone file than CDB
Any expierience with that ?  
I think we take it next upgarde and sync then. WHat do you think ?

Thank You!
br, Laurel

[ErmanArslansOracleBlog]

Hi,

Thank you I'm fine. I hope everything is good on your side as well.

That difference may be related with patches, and patching mechanism..
You plugged your EBS DB to 19C CDB right?
So, this is probably related with your old EBS DB, when it was non-CDB

I mean; probably, your PDB (when it was not a PDB or a lets say non-CDB) was  patched for the timezone file before being migrated/plugged into the CDB as a PDB. This might be the case.

or

Your PDB inherited a higher version through a different patching mechanism or was cloned from a source with a higher version.

Even when your PDB TZ version is higher than the CDB, you can plug in..
Ref: https://mikedietrichde.com/2019/07/30/database-migration-from-non-cdb-to-pdb-the-time-zone-pitfall/

---

If TZ_VERSION of non-CDB or PDB is lower than CDB, you can plugin
If TZ_VERSION of non-CDB or PDB is equal to CDB, you can plugin
If TZ_VERSION of non-CDB or PDB is higher than CDB, you need to check in the CDB ( so still you can plug in, see below ->

Your CDB$ROOT can be on DST V.32 whereas a PDB you plugin can be already on DST V.33. But only if you fulfill one important requirement: The patch for DST V.33 must be installed into the CDB’s home. If you did that, you won’t see a warning.
----

Ayways, I recommend you to sync them, to use the same timezone version for the entire CDB-PDB environment.

Additional note: Time Zone Downgrade is not possible. Once you upgrade the time zone setting in your database, you can’t take it back.

[Laurel]

Hi!
Thx Erman!
Yes ->
PDB (when it was not a PDB or a lets say non-CDB) was  patched for the timezone file before being migrated/plugged into the CDB as a PDB.
The violation report did not say anything on the violation of timezone. :) And oracle  instrcutions did not have anything on that ( checke incompatib note with 19c)
Do you see some documnet how to sync those ?
Thx!
br,Laurel

[ErmanArslansOracleBlog]

Multitenant - CDB/PDB - Upgrading DST using scripts - 12.2 and above - ( With Example Test Case - 19.11 ) (Doc ID 2794739.1) -> CDB : Upgrade Window - Upgrading CDB DST by Applying DST Changes

&

Migrating and Upgrading Oracle Database 11g to 19c for Oracle E-Business Suite Release 12.2 with Oracle Base Database Service DB Systems (Doc ID 2758991.1)
--> part , 15.(Conditional) Upgrade the time zone in the container database if you applied a DST patch earlier.