ORA-04088: error during execution of trigger 'MDSYS.SDO_NETWORK_DROP_USER'
Oracle 12.1.0.2 SE2 on Oracle Linux 6.
Real simple. I was adding a new 'standard' user to all of my databases. Same script on all, a simple CREATE USER, specifying default and temp TS. No privs, no objects, just a user.
After adding the user I realized my script had mis-spelled the name, so I went back to DROP the user and recreate it. On one and only one database the DROP USER returned
Failed to process SQL command - ORA-04088: error during execution of trigger 'MDSYS.SDO_NETWORK_DROP_USER' ORA-00604: error occurred at recursive SQL level 1 ORA-04063: package body "MDSYS.SDO_UTIL" has errors ORA-06512: at line 7