My team mates are really quick. We received an information early this week about a missing or wrong DV check in the preupgrade – and they implemented it within a day or so. The September 2018 version of the improved preupgrade.jar for Oracle 12.2 and 18c is available for download.
Improved preupgrade.jar for Oracle 12.2 and 18c
What’s new in this version:
It adds a recycle bin check when the autofixup for dictionary statistics is run
It’s time for the next Office Hours: Upgrade and Migrations – September 20, 2018. This time Roy and Bill will run it as I’m traveling. And they’ve set it on purpose to a convenient time for the Americas. Roy has prepared a few slides upfront – and then it’s your time for questions.… [ Read More ]
Have you ever had a post-conference blues? This is the mood which makes you feel like sitting in a dark cage surrounded just by nothing as silence. And I’m still in post-conference blues – or 5 days after POUG2018.
Worst post-conference blues ever?
Actually my worst post-conference blues wasn’t after POUG2018.… [ Read More ]
Sometimes development groups change default parameter settings because it fits well for a specific feature. This has happened with _cursor_obsolete_threshold in Oracle Database 12.2. But there’s now an official recommendation for Oracle 12.2 and higher: Set _cursor_obsolete_threshold to old default.
What is _cursor_obsolete_threshold?
First of all, this is obviously an underscore parameter.… [ Read More ]
I know it got delayed a bit. But there’s a good reason for the delay. In addition, my post is a bit late as well but I was on vacation. Anyway, you can download it since Aug 22, 2018. Oracle Database 18c on-prem for MS Windows is available.
Oracle Database 18c on-prem for MS Windows is available
You can download it from oracle.com and eDelivery:
I‘m back from vacation. With 900 or so emails in my inbox. And messages on LinkedIn and Twitter, comments on the blog etc. So plenty of things to do for the next days. The event I’m really looking forward is my upcoming visit of the POUG – Pint with the Oracle User Group in Sopot, Poland.… [ Read More ]
I posted several blog posts about Unified Auditing in the past. And recently a large customer in the UK alerted me about their upgrades with PDBs from 12.1 to 12.2 taking much longer when Unified Auditing policies were enabled. It looks like as if Unified Auditing policies can slow down the upgrade.… [ Read More ]
I really don’t want to turn this blog into an accumulation of issues and flaws. But as I explained many times before, the blog for me is also a way to dump information I likely will need the sooner or later again.
We had several discussions on the internal mailing lists the other day about cloning with Pluggable Databases in Oracle 18c (or 188.8.131.52). And I blogged about this topic a while ago but realized I may need to refresh this a bit.
I wanted to write up this blog post a long time ago. When Helen Vanderheide did ask me a few weeks ago if she can omit catoctk.sql during the creation of the database, I realized that I should update my previous blog posts about Creating CDBs and non-CDBs with less options.… [ Read More ]
That’s a question I have gotten several times already: How long can you provision database version X in the Cloud? Meaning, is there a fixed date when you’ll be unable to provision an instance containing Oracle Database 184.108.40.206 for instance?
How long can you provision database version X in the Cloud?
Thanks to my team mates, Cindy and Hector, who alerted me on this newly detected issue. When your database has been upgraded from release to release, it could happen that a public synonym XMLCONCAT exists. And before you upgrade to Oracle 12.2.01 or Oracle 18c you must drop this public synonym to avoid upgrade errors.… [ Read More ]
Monday morning, another way-too-hot July day. Summer is crazy this year in Europe. We all enjoy nice sunny weather but nobody does enjoy a serious drought. Nowhere. While going through my inbox I spot this statement: ““Why should we go to 18.x with support till 2020?“. And this is not an unusual question.… [ Read More ]
As Oracle Database 18c is now available on Linux on premises, I blogged about the installation already. And the next logical step is the Oracle Database 18.3.0 Upgrade on premises. In this case I will show an upgrade on the command line from Oracle 220.127.116.11 to Oracle 18.3.0. A DBUA upgrade will follow in a separate blog post later.… [ Read More ]
This is a Friday morning blog post. And actually I had no intention to write it. I don’t mean it offensive. But yesterday I received an interesting email from Frits Hoogland from Enkitec/Accenture. Frits asked me about the July RUR and some unlogic things on MOS. Once I had answered his email, the next question came in.… [ Read More ]