If you’d ever attended one of Roy’s or my workshops, you know that we talk about time zone adjustments after the database upgrade. We explain why this is important. But as everything, it depends if you really need to apply and adjust. In our workshops we recommend one single note for time zone adjustments: MOS Note:412160.1 . This note has been updated and republished. It contains DST V.32 and DST V.33 links and references. Amit Grover from AWS contacted me and told me about a potential dependency of DST patches to the Oracle Update such as RU 18.4.0 or 18.5.0.… [ Read more ]
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 … [ Read more ]
Roberto Valsania asked this question once he read my blog post about whether you have to execute
datapatch after creating a new 12c database: Do you have to execute
catbundle.sql when you create a new 11g database?
I’d bet you all are aware that Oracle Database 18.104.22.168 will go out of Waived Extended Support by end of 2018. But that doesn’t answer the question. So I did a quick experiment and created a fresh 22.214.171.124 database to answer the question.
Do you have to execute catbundle.sql when you create a new 11g database?
First of all, let me clarify … [ Read more ]
Patching is fun, isn’t it? And you may have heard already that the April 2018 patch bundles got released on April 17, 2018. And I thought I share a little bit of fun with you with a quick guide to patching my databases with the April 2018 PSU, BP and RU. For this exercise I use our Hands-On Lab with Oracle 126.96.36.199, Oracle 188.8.131.52 and Oracle 184.108.40.206 installed.
Prerequisites for patching my databases with the April 2018 PSU, BP and RU
First of all, in my VBox environment, I shutdown the databases for each release before patching them – … [ Read more ]
The first RU (Release Update) for Oracle 12.2 is available on most platforms since July 18, 2017. And of course I started applying the first RU for Oracle Database 220.127.116.11 as soon as it got released.
Download the RU 18.104.22.168.170718 for Linux
First of all I downloaded the Database RU 22.214.171.124.170718 Patch 26123830 for Linux from MyOracle Support. To my absolute surprise it was very small compared to previous Proactive Bundle Patches such as the April 2017 one. It has just 40 MB in size (no typo!).… [ Read more ]
This question was in my inbox this morning raised by a customer via a colleague.
“Can I apply a BP on top of a PSU? Or vice versa?”
Our feeling said:
Yes, but you’ll have to deinstall the PSU first before applying the BP.
Having a feeling is one thing, knowing the truth is better. And as I have so much fun by applying PSUs and BPs back and forth since two weeks I thought “let’s give it a try”. So here we go …
Apply a BP on top of a PSU
This is my starting point – Oracle … [ Read more ]
Usually I don’t post twice a day but as my post scriptum for the previous blog post got longer and longer I decided to write an entry about it – maybe simply because I feel soooo happy that my patch application succeeded flawless.
For many of you the following steps may look very boring as you have done this many times. But I use the blog also to brain-dump information for myself 😉 And for those who’d like to play with it, I summarized the steps fitting exactly into our Hands-On-Lab environment.
I downloaded the following patches:
- Database Proactive