19.7.0

ORA-29702 – and your instance does not startup in the cluster anymore

Posted on November 13, 2020 by Mike.Dietrich ASM / RAC / GI Flaws and Pitfalls Patch Recommendation 11

This is the right blog post for a Friday 13th. And please forgive me – I wanted to put this on the blog earlier as two of my customers hit this weeks ago already. But it must have fallen through the cracks. Still, now it is hopefully not too late to tell you what you should do if you hit ORA-29702 – and your instance does not startup in the cluster anymore. Especially when you tested a database upgrade – and after a restore, the database doesn’t want to start, no matter what you try.

ORA-29702 - and your instance does not startup in the cluster anymore

Photo by Nadine Shaabana

Special characters show junk in CLOB columns after upgrade to Oracle 19.7.0 with JDBC

Posted on June 22, 2020 by Mike.Dietrich Flaws and Pitfalls 29

When you’d copy & paste the above title into a search engine, you may come across a very similar sounding blog post I wrote two years ago. Today, my dear colleague Dirk asked me on behalf of a customer if it’s possible that this bug is back in 19.7.0. Of course, I said “No”, for sure not. Bug 26380097 was fixed in Oracle 18c already. Gladly, Dirk insisted. So I checked the SR his customer opened.

Special characters show junk in CLOB columns after upgrade to Oracle 19.7.0 with JDBC

Photo by Sven Brandsma on Unsplash

And now I can write an unplanned blog post about Special characters show junk in CLOB columns …

Do you love unexpected surprises? SYS_AUTO_STS in Oracle 19.7.0

Posted on May 28, 2020 by Mike.Dietrich Behavior Change Optimizer 42

Last week I recorded seminars – and I wanted to garnish the Performance part with demo recordings from our Hands-On Lab. I used the Hands-On Lab instructions we published. And while I edited a recording, I realized that there was something new I haven’t seen before. Do you love unexpected surprises? SYS_AUTO_STS in Oracle 19.7.0? Of course you do …!

Do you love unexpected surprises? SYS_AUTO_STS in Oracle 19.7.0

Photo by Pete Wright on Unsplash

What happened?

In my environment I run load against my database, I collect statements from AWR and from Cursor Cache into two separate SQL Tuning Sets (STS). And then I upgrade my …

DBMS_JOB one-off patch needed for Oracle 19.3.0 – 19.7.0

Posted on May 21, 2020 by Mike.Dietrich Behavior Change Patch Recommendation 16

A while ago I blogged already about this behavior change for DBMS_JOB in Oracle Database 19c. Many of you are aware of this. But today I learned something new about it. Kudos to Alexey Makhmutov for bringing this to my attention. There is a very important fix you will need on top in 19c to avoid performance issues. If you rely on jobs with the old job interface, take note: DBMS_JOB one-off patch needed for Oracle 19.3.0 – 19.7.0

DBMS_JOB one-off patch needed for Oracle 19.3.0 - 19.7.0

Photo by Christopher Burns on Unsplash

What is the problem?

As you can read from there is a internal …

19.7.0

ORA-29702 – and your instance does not startup in the cluster anymore

Special characters show junk in CLOB columns after upgrade to Oracle 19.7.0 with JDBC

Do you love unexpected surprises? SYS_AUTO_STS in Oracle 19.7.0

What happened?

DBMS_JOB one-off patch needed for Oracle 19.3.0 – 19.7.0

What is the problem?

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Follow me on Twitter

Recent Posts