My Oracle Support Banner

ORA-01031 at End of catpach.sql Execution in 9.2.0.x Patchset Installation (Doc ID 266325.1)

Last updated on MAY 21, 2021

Applies to:

Oracle Spatial and Graph - Version 9.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Run $ORACLE_HOME/rdbms/admin/catpatch.sql after having applied the patchset.

This results in an ORA-1031 'insufficient privileges' error for the Spatial (SDO) product.

BEGIN dbms_registry.loaded('SDO'); END;
    *
    ERROR at line 1:
    ORA-01031: insufficient privileges
    ORA-06512: at "SYS.DBMS_REGISTRY", line  82
    ORA-01403: no data found
    ORA-06512: at "SYS.DBMS_REGISTRY", line 263
    ORA-06512: at line 1

BEGIN dbms_registry.valid('SDO'); END;
    *
    ERROR at line 1:
    ORA-01031: insufficient privileges
    ORA-06512: at "SYS.DBMS_REGISTRY", line  82
    ORA-01403: no data found
    ORA-06512: at "SYS.DBMS_REGISTRY", line 199
    ORA-06512: at line 1


DBA_REGISTRY might look something like shown below for the Spatial product after an upgrade from 9.2.0.1:

COMP_NAME STATUS VERSION

------------------------------- --------------- ----------

Spatial                LOADED     9.2.0.1.0

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.