The following error messages appear together when an object or package is invalid. The name of the body may vary depending, specifically, on what is invalid.
ORA-04061: existing state of package body "SDE.ST_GEOMETRY_OPERATORS" has been invalidated
ORA-04065: not executed, altered or dropped package body "SDE.ST_GEOMETRY_OPERATORS"
Objects can become invalid during an ArcSDE upgrade or service pack installation when objects or packages are upgraded or replaced. Because of Oracle's object dependency model, when objects contain references to other objects or packages, other objects or packages that contain a dependency on the objects being modified during the installation are marked as invalid. Oracle sometimes recompiles invalid database objects automatically when referenced, but there are still cases when they are not automatically compiled.
SQL> SELECT object_name, object_type
WHERE STATUS = 'INVALID';
SQL> GRANT EXECUTE ON utl_recomp TO sde;
SQL> EXECUTE sys.utl_recomp.recomp_serial('SDE');
Get help from ArcGIS experts
Download the Esri Support App