Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center