Component

After patching, Spatial Index creation fails with ORA-13249

Posted on August 4, 2021 by Flaws and Pitfalls 11

Thanks again to Peter Lehmann from T-Systems for highlighting this issue to me. After patching, Spatial Index creation fails with ORA-13249. And Peter’s customer was quite worried. But see what may have caused this, and how we fixed it.

After patching, Spatial Index Creation Fails with ORA-13249

Photo by Bill Oxford on Unsplash

What happened?

Peter patched a system from 19.10.0 to 19.11.0. This database has undergone an upgrade from 12.2.0.1 to 19.7.0 before, then got patched to 19.9.0 before. The database has the Oracle Locator only but no Spatial installed. The patching including datapatch worked fine. All seemed to be good. Until the customer tried to …

Continue reading...

ORA-1403 during TEXT / CONTEXT post upgrade

Posted on March 5, 2020 by Best Practice Flaws and Pitfalls 8

When you see an ORA-1403 during TEXT / CONTEXT post upgrade phase, regardless of using AutoUpgrade, dbupgrade, catctl or DBUA, no worries. Two people reported this to me this week. And my dear support colleague Klaus Herndl told me about the existing MOS note. But there is a bit more to explain, especially as the bug is non-public and the MOS note doesn’t tell you when this can happen.

ORA-1403 during TEXT / CONTEXT post upgrade

Photo by Moritz Schmidt on Unsplash

What happens?

This is the error pattern you may see during the post upgrade phase when Oracle Text is installed in your database:

Oracle Database
… Continue reading...

Oracle Multimedia is deprecated in Oracle 18c

Posted on August 10, 2018 by Deprecated / Desupported 4

While I was writing the blog post about Creating CDBs and non-CDBs with less options I realized that Oracle Multimedia is deprecated in Oracle 18c – but I haven’t mentioned this here yet.

Oracle Multimedia is deprecated in Oracle 18c

Oracle Multimedia was called Oracle Intermedia a long time ago when we introduced it back in the Oracle 8i days.

Oracle Multimedia is deprecated in Oracle 18c

I don’t know how many people really used it, but it is part of a standard installation if you didn’t explicitly turned it off or deinstalled it.

And from Oracle 18c on, Oracle Multimedia is deprecated. Meaning, it won’t develop …

Continue reading...
Mike Dietrich
Oracle Senior Director of Product Management for Database Upgrade, Migrations and Patching writing just another blog.

Opinions certainly are my own as is this page.

Archives

Categories

Upgrade @YouTube

Subscribe via Email

Join 8,090 other subscribers

Follow me on Twitter