Oracle 126.96.36.199 seems to be the “tracing” release without further patch or parameter treatments. After posting about MMON unconditional traces in Oracle 188.8.131.52 a day ago, I received a couple of comments either on the blog, via LinkedIn or Twitter regarding other trace facilities in Oracle Database 184.108.40.206.… [ Read More ]
I love visiting customers onsite. Last week I visited die Mobiliar in Bern, Switzerland. I received a list of open issues to discuss – which is very good to prepare a visit. And when we all were sitting together there was this “Ah, one final thing”. They have an issue with traces the databases writes every few seconds.… [ Read More ]
Underscore parameters are a wonderful thing in Oracle. They are treated like a secret. But you can view them of course. Everybody can. Make a guess how many underscore parameters exist in Oracle 220.127.116.11.0. You’ll find the answer at the end of this blog post. But why should you remove underscore parameters not only before you upgrade?… [ Read More ]
I did blog about several things-to-know with DBCA (Database Configuration Assistant) in the past. And one issue came up in our internal mailing list the other day. Be aware of database options selections for PDBs in DBCA. Missing one or the other “click” may bring you in trouble later on. I blogged about this already a while ago but this was only part of a larger post: Create Multitenant Databases with DBCA – Things to Know.… [ Read More ]
Opatch. A tool nobody really loves but everybody has to use (at least those of you who patch or aren’t in our cloud deployment). Opatch gets distributed via MOS. And you often can apply patches with an older version of OPatch. So why should you use the most recent version of OPatch?… [ Read More ]
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 18.104.22.168. 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 22.214.171.124 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 126.96.36.199 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 188.8.131.52 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 184.108.40.206 may alter the default local temporary tablespace.
Upgrade to Oracle 220.127.116.11: 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 ]