ORA-04045: errors during recompilation/revalidation of MDSYS.SDO_GEOR_ADDL_TRIGGER ORA-01031: insufficient privileges

ERROR¶

Environment: windows server 2008 ORACLE 11.2.0.4 single instance

Add data file hint

ORA-04045: errors during recompilation/revalidation of MDSYS.SDO_GEOR_ADDL_TRIGGER
ORA-01031: insufficient privileges

Query mos says that it needs to authorize mdsys, the command is as follows

grant administer database trigger to mdsys;

The result is still no permission.

SOLUTION¶

After many twists and turns, it was finally solved. Turn on the Oracle hidden permissions and use it with caution. You can also delete things that cannot be deleted when you turn off.

alter system set "_system_trig_enabled"=falese scope=both;

After closing, recompile the trigger or close the trigger. Then change the hidden parameters

alter system set "_system_trig_enabled"=true scope=both;

Or try the following method, the method has not been tested, and I don’t know the result. The above method is available for pro test

sysdbaexecutes ORACLE_HOME/rdbms/admin/utlrp.sql script
   There are also two ways to compile invalid objects:
       1 Use alter **** compile statement to compile
       2 Use the DBMS_UTILITYpackage to compile .