Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Applying 11.2.0.3 Windows Patch Bundle 25 or 26 causes DBMS_METADATA_INT, DBMS_METADATA_UTIL and XDB

edited Nov 21, 2013 2:29AM in Database Install/Upgrade/Opatch (MOSC) 4 commentsAnswered

Applying 11.2.0.3 Windows Patch Bundle 25 or 26 causes DBMS_METADATA_INT, DBMS_METADATA_UTIL and XDB_MIGRATESCHEMA to become invalid as Oracle accepted as being a bug in (Doc ID 1592638.1). However, this was supposedly fixed in PATCH 26. I tried this on multiple instances with same results. Running dbmsxdbschmig.sql and prvtxdbschmig.plb did not help. I ran catpprvt.sql to rebuild DBMS_METADATA_INT, DBMS_METADATA_UTIL which worked but this time invalidated DBMS_CDC_UTILITY in addition to XDB_MIGRATESCHEMA.

I am not seeing this error on the servers running Win2008 but worstations ranging from XP to Win7Ent have the same error. What causes these errors and how can I get these objects re-validated?

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