I can just repeat what I’m saying not for almost a year: When you patch, please use UPDATES – and not REVISIONS. Updates (or Release Updates – short: RU) and Revisions (or Release Update Revisions – short: RUR) are patch bundles for the Oracle Database since Oracle 126.96.36.199. There are no PSUs (Patch Set Updates) anymore.… [ Read More ]
More than 10 years ago I was invited to work several weeks in Redwood Shores at the Oracle HQ for Lawrence To‘s MAA team together with Ray Dutcher, one of the greatest persons I have ever met and worked with in my over 20 years at Oracle. We had to work out a doable process for smooth rolling upgrades utilizing a physical standby database.… [ Read More ]
Interesting case Roy came across a week ago with a customer in the US. The customer received a plugin violation because of different
DB_BLOCK_SIZE between the source and the destination database. This happened regardless of unplug/plug or plugging in a non-CDB into a CDB. Hence the question came up: Can you have different block sizes when you plugin?… [ Read More ]
We read and listen to your comments. And that’s why my team mate Byron has added a new preupgrade.jar and changes to MOS Note:884522.1. One reader commented that MOS Note:884522.1 (How to Download and Run Oracle’s Database Pre-Upgrade Utility) does not explain how to “run” the preupgrade tool even though it mentions this in the note’s title.… [ Read More ]
This is not a database knowledge article. I more or less see this as a information collection and discussion point. An important topic for me at the moment, besides all the usual upgrade and migration things, is about the effect of GDPR / DS-GVO on blogs and other pages.… [ Read More ]
A week ago, Roy and I returned from a 1+ week trip to Korea and Japan. It was wonderful but of course strenuous (as always). As today is a public holiday in many European countries including Germany I’d like to take the chance and write a non-technical short article about our Korea and Japan visit – Recap and Thank You!… [ Read More ]
I was quite surprised when I spotted the Update (RU) Oracle 18.2.0 mid of April in my OCI Classic (DBCS, DBaaS) account. Of course I was thrilled immediately and started the patching to Oracle 18.2.0 in the Oracle Cloud (OCI Classic).
Patching to Oracle 18.2.0 in the Oracle Cloud (OCI Classic)
The April 2018 Updates (and Bundle Patches and Patch Set Updates for Oracle releases below 12.2) got released on April 17, 2018.… [ Read More ]
Today is a sunny day. A wonderful beautiful spring day. Flowers are blooming. Trees are getting green. Birds are singing. All fine. And then I find this email in my inbox. A customer wants to migrate between two Big Endiann platforms with a important ERP system. Nothing special – until I read this: The ERP system is currently on Oracle 10.2.0.4 – and it should stay on Oracle 10.2.0.4.… [ 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 188.8.131.52 will go out of Waived Extended Support by end of 2018.… [ Read More ]
Most of you may not care about the checks our Pre Upgrade Check tool preupgrade.jar does. But some may. Especially in cases where you plan to run a command line upgrade unattended via a script. Therefore this List of PREUPGRADE checks executed by preupgrade.jar may help you.
List of PREUPGRADE checks executed by preupgrade.jar
As a result of a joint initiative between our Upgrade Development team and the Support group dealing with upgrade-related SRs we released this MOS Note:
- MOS Note: 2380601.1
Database Preupgrade tool check list
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.… [ Read More ]
It’s already mid of April again. One year after IOUG Collaborate 2017. And I was soooo sick last year. This time Roy will fly to Las Vegas and provide an upgrade talk and a lab. Last year for the planning we agreed that this year I would do the RMOUG conference, and Roy instead fly to Nevada.… [ Read More ]
Thanks to Connor McDonald (Mr. AskTom) I learned today that one topic is not clear from our patches
readmes: Do you have to execute “
datapatch” when you create a new database? And it’s true. It does not get explained in the readme anywhere.
Do you have to execute “datapatch” when you create a new database?… [ Read More ]
The parallel upgrade
catctl.pl can resume once an upgrade has stopped for unexpected reasons. Before Oracle 12.2 you can restart it with the
-p option specifying the phase it stopped. And since Oracle 12.2 you can only use the
-R option to resume it. This blog post will give you a bit more insights in monitoring catctl.pl progress during upgrades.… [ Read More ]
It’s time for the next Office Hours session with the Upgrade Development Team. The Upgrade and Migration Office Hours on April 19, 2018 features the topic “Fallback Strategies“. Roy will prepare a short slide intro. And afterwards we’ll happily take your questions.
What are “Office Hours”?
This is a new interactive format we really like.… [ Read More ]
As you may or may not know, Germany has quite a few public holidays. On the Easter days I took the chance to sort my folders (real paper, not on any computer or in any cloud). And when you do such things, you may find some rare gems. When I found an old invoice I realized: Time flies – my first computer in 1990 did cost a real fortune.… [ Read More ]
A while ago I blogged about Fallback Strategy: Flashback Database to Guaranteed Restore Points. I included a recommendation that you must not change the
COMPATIBLE setting. But I should have been a bit more clear and precise about Guaranteed Restore Points and
COMPATIBLE parameter settings.
Guaranteed Restore Points and COMPATIBLE parameter
PDB_PLUG_IN_VIOLATIONS is a strange view in the Oracle database universe. It does not follow Oracle naming conventions – and it has too many underscores in its name. Furthermore I get always annoyed by the fact that it doesn’t get purged automatically. In addition it accumulates a massive number of useless information over time.… [ Read More ]
There’s been silence for a while – but today I’d like to show you how to unplug a 184.108.40.206 PDB and plugin into 18c in the Cloud. I’m doing this exercise because I’ve seen questions already. And I was curious if it works as I’d expect it.
Unplug a 220.127.116.11 PDB and plugin into 18c in the Cloud
One of the reasons why I have this blog is simply to stay in touch with smart people using Oracle and telling me about issues I haven’t seen before. Thanks to Tyler Van Vierzen I learned that an upgrade to Oracle 18.104.22.168 may alter the default local temporary tablespace.
Upgrade to Oracle 22.214.171.124: Check your DEFAULT temporary tablespaces
Tyler did contact me on Twitter:
“Curious if you’ve seen this… Seeing new “local temp tablespace” set to SYSTEM for some users after 12.2 upgrade.… [ Read More ]
When will Oracle Database 18c be available on-prem? Some of you will answer: It is available already, isn’t it? And you are right. But I don’t want to blog just a marketing message but some facts. Others may ask: When will it be generally available on-premises?
When will Oracle Database 18c be available on-prem?… [ Read More ]
In case you plan to upgrade a database to Oracle Database 18c: A new preupgrade.jar is available for download from MyOracle Support (MOS).
Oracle Database 18c: A new preupgrade.jar is available
The same MOS note will get you also the most recent versions of the preupgrade.jar for Oracle Database 126.96.36.199 upgrades.… [ Read More ]
The first Office Hours Session was just a month ago. It was a very good experience and based on the feedback we received from customers it was very helpful. You don’t believe it? Then you may watch the recording. But now it’s time for our second Upgrade and Migration Office Hours on March 21, 2018.… [ Read More ]
I blogged about
upuserxt.lst lists Oracle Supplied User Schemas and Roles a while ago. But I thought it’s time to refresh this blog post a bit and adjust it to be more useful.
upuserxt.lst displays the Oracle Supplied User Schemas and Roles since Oracle Database 188.8.131.52.
upuserxt.lst lists Oracle Supplied User Schemas and Roles
You can access
upuserxt.lst simply with an external table.… [ Read More ]