Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

invalid objects running utlu11i.sql

edited Jan 30, 2012 5:01AM in Database Install/Upgrade/Opatch (MOSC) 2 commentsAnswered
 oracle support strongly recommends that I perform an out of place upgrade from 11.1 to 11.3

first step is to run utlu11i.sql and resolve issues.

I've got everything resolved except for 2 issues:

1. stale optimizer stats
2. invalid objects

for the stats I ran DBMS_STATS.GATHER_DICTIONARY_STATS and DBMS_STATS_GATHER_SCHEMA_STATS for the 2 schemas shown with stale stats: SYS and SYSMAN

However, after running, upon re-running utlu11i.sql the stats were still classed as stale.

Question-  what did I do wrong and how important is this?

Mike



for invalid objects when I look at schemas that have invalid objects using Toad I was able to resolve (recompile) all except WKSYS,WMSYS, PUBLIC and PERFSTAT

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