Spatial

After patching, Spatial Index creation fails with ORA-13249

Posted on August 4, 2021 by Mike.Dietrich Flaws and Pitfalls 10

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.

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 …

Webinar: Converged databases and upgrade to Oracle Database 19c

Posted on April 14, 2021 by Mike.Dietrich 0

Registration Link

Webinar: Converged databases and upgrade to Oracle Database 19c

22 April 2021, Thursday11:00 – 13:45 CET

Join us to meet our experts and tech specialists!

We are pleased to invite you to the webinar where our experts will talk about the benefits of Oracle converged database and upgrade to Oracle Database 19c version.

For decades, the best global companies have relied on Oracle Database as an efficient tool for high performance, scalability, dependability, and operational and analytical database security. Fully compliant with convergence criteria, Oracle Database 19c will be the principal Oracle Database version in operation

Workaround for sdoloadj.sql errors with Datapatch in 19.9.0 and 19.10.0

Posted on March 2, 2021 by Mike.Dietrich Flaws and Pitfalls 6

The other week a customer from my hometown alerted me about an issue they saw when applying the 19.9.0 RU. A long sequence of errors in the datapatch run, all of them signaled from sdoloadj.sql. They opened an SR. And Support had an – understandable – recommendation the customer didn’t want to implement: Install JAVAVM. But thanks to my PM mate, Hans Viehmann (Mr Spatial), here is a simple Workaround for sdoloadj.sql errors with Datapatch in 19.9.0 and 19.10.0. And it may even apply to later releases, too.

Workaround for sdoloadj.sql errors with Datapatch in 19.9.0 and 19.10.0

Photo by Mael BALLAND on Unsplash

What happens?

Take …

APEX is invalid after upgrading to 12.2 – ORA-20001

Posted on February 11, 2020 by Mike.Dietrich APEX Flaws and Pitfalls 0

We are running the AutoUpgrade-for-RAC beta test since last week. And the first issue one customer encountered … is neither an AutoUpgrade nor a RAC issue. It has to do with APEX and SPATIAL, and missing grants. APEX is invalid after upgrading to 12.2 – ORA-20001

APEX is invalid after upgrading to 12.2 - ORA-20001

Photo by Aditya Vyas on Unsplash

What is happening?

You are doing an upgrade to Oracle Database 12.2.0.1. And you receive a number of errors during the component validation phase.

19:04:14 SQL> EXECUTE dbms_registry_sys.validate_components;
...(19:04:15) Starting validate_apex for APEX_180100
ORA-20001: MISSING GRANT: grant execute on "MDSYS"."SDO_DIM_ARRAY" to APEX_180100
ORA-20001: MISSING GRANT: grant execute on

Great License News: Spatial and Graph, Machine Learning

Posted on December 6, 2019 by Mike.Dietrich General 6

Just this week in Brighton at TechFest19 by UKOUG I’ve heard one of the common complaints about our license strategy. Something I can’t comment in my position. But even better that we are announcing some very good news now. Oracle is listening. It is a reaction to customer’s wishes.

Photo by pxoxo on Unsplash

Spatial and Graph

Effective December 5, 2019, Oracle Spatial and Graph (OSG) option will be included with Oracle Database. This will affect Enterprise Edition, SE2 and Database Cloud Service (DBCS) Standard Edition 2 and Enterprise Edition. This means, you can use Spatial and Graph in all …

Oracle Spatial (SDO) Clean Up in Oracle Database 11.2-19c

Posted on July 30, 2017 by Mike.Dietrich Removal 24

Oracle Spatial (SDO) clean up in Oracle Database 11.2-19c is mostly straight forward. You can do it with the database up and running in Oracle Database 12c. Nevertheless it is very important that you check beforehand if Spatial and/or Graph are in use.

Be positively aware:
Since December 5, 2019, Oracle Spatial and Graph are both included automatically in all database licenses back to Oracle 11.2.0.4, for EE as well as for SE2. Generally. Read more here: https://mikedietrichde.com/2019/12/06/great-license-news-spatial-and-graph-machine-learning/

Oracle Spatial (SDO) Clean Up in Oracle Database 11.2-19c

Oracle Spatial (SDO) Clean Up in Oracle Database 11.2-12.2 Oracle Spatial (formerly known as Spatial Data Option) and Graph are great …

Spatial

After patching, Spatial Index creation fails with ORA-13249

What happened?

Webinar: Converged databases and upgrade to Oracle Database 19c

Workaround for sdoloadj.sql errors with Datapatch in 19.9.0 and 19.10.0

What happens?

APEX is invalid after upgrading to 12.2 – ORA-20001

What is happening?

Great License News: Spatial and Graph, Machine Learning

Spatial and Graph

Oracle Spatial (SDO) Clean Up in Oracle Database 11.2-19c

Oracle Spatial (SDO) Clean Up in Oracle Database 11.2-19c

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Follow me on Twitter

Recent Posts