This is part of a blog post serious where I install Oracle 18c on-premises in our Hands-On Lab and upgrade the Multitenant 220.127.116.11 database as well. But in order to safe space, deinstalling Oracle Database 18.104.22.168 is my next task. You find all the blog posts connected to each other here:
I’m currently refreshing our Hands-On Lab and will exchange Oracle 22.214.171.124 with Oracle 18.2.0. This blog post series is about how to Upgrade to Oracle 126.96.36.199 to Oracle Database 18c on-premises. There are other blog posts available you may use by yourself if you plan to refresh the lab by yourself until we uploaded a newer version.… [ Read More ]
Roy just uploaded a newer version of our Upgrade Hands-On Lab – Oracle Database 188.8.131.52 – May 2018.
The previous version had – I believe – and early drop of Oracle 184.108.40.206 installed. And recently somebody complained that certain Multitenant operations such as Hot Cloning with Oracle Database 220.127.116.11 don’t work but result in errors.… [ Read More ]
Well, time really flies. And I just realized this morning: It’s time to promote our next session for the Upgrade Office Hours: June 20, 2018 – 14:00 CET – The New Release Model. Yes, Wednesday next week. Time to let us know your questions upfront. BE AWARE: WE HAD TO CHANGE THE BEGIN TIME FROM 11:00 CET to 14:00 CET
Upgrade Office Hours: June 20, 2018 – 14:00 CET – The New Release Model
Roy, Bill and I have taken a decision to alter the begin dates for the upcoming Office hours.… [ Read More ]
This was an interesting question I received from Alain Fuhrer a couple of weeks ago: “Why can’t I drop a tablespace in a PDB whit a Guaranteed Restore Point being active?”. It’s important to note that the GRP is not active in the same but in another PDB.
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 18.104.22.168.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 22.214.171.124. 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 ]
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 ]
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:
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 ]