Home > Oracle > Invalid Objects after wrong utlrp.sql

Invalid Objects after wrong utlrp.sql

June 24th, 2009

Be extra careful with the location of your utlrp.sql script when you decide to recompile the invalid objects for the entire database as sys.
The utlrp.sql script resides in the ORACLE_HOME/rdbms/admin and in CLIENT_HOME/rdbms/admin folders.
It is utterly wrong to use and recompile with the script in the client home folder.
After such a mistake of me the SYSMAN schema got completely corrupt.
I restored the SYSMAN using the steps described in my previous post OracleDBControl .

The remaining invalid objects are as follows:

select owner, object_name from all_objects where status='INVALID';

OWNER OBJECT_NAME
PUBLIC DBA_HIST_FILESTATXS
PUBLIC DBA_HIST_SQLSTAT
PUBLIC DBA_HIST_SQLBIND
PUBLIC DBA_HIST_SYSTEM_EVENT
PUBLIC DBA_HIST_WAITSTAT
PUBLIC DBA_HIST_LATCH
PUBLIC DBA_HIST_LATCH_MISSES_SUMMARY
PUBLIC DBA_HIST_DB_CACHE_ADVICE
PUBLIC DBA_HIST_ROWCACHE_SUMMARY
PUBLIC DBA_HIST_SGASTAT
PUBLIC DBA_HIST_SYSSTAT
PUBLIC DBA_HIST_SYS_TIME_MODEL
PUBLIC DBA_HIST_OSSTAT
PUBLIC DBA_HIST_PARAMETER
PUBLIC DBA_HIST_SEG_STAT
PUBLIC DBA_HIST_ACTIVE_SESS_HISTORY
PUBLIC DBA_HIST_TABLESPACE_STAT
PUBLIC DBA_HIST_SERVICE_STAT
PUBLIC DBA_HIST_SERVICE_WAIT_CLASS
PUBLIC STATS$SGA
PUBLIC STATS$SGASTAT
PUBLIC STATS$SHARED_POOL_ADVICE
PUBLIC STATS$SNAPSHOT
PUBLIC STATS$SNAPSHOT_ID
PUBLIC STATS$SQLTEXT
PUBLIC STATS$SQL_PLAN
PUBLIC STATS$SQL_PLAN_USAGE
PUBLIC STATS$SQL_STATISTICS
PUBLIC STATS$SQL_SUMMARY
PUBLIC STATS$SQL_WORKAREA_HISTOGRAM
PUBLIC STATS$STATSPACK_PARAMETER
PUBLIC STATS$SYSSTAT
PUBLIC STATS$SYSTEM_EVENT
PUBLIC STATS$TEMPSTATXS
PUBLIC STATS$UNDOSTAT
PUBLIC STATS$WAITSTAT
PUBLIC STATSPACK
PUBLIC STATS$DATABASE_INSTANCE
PUBLIC STATS$DB_CACHE_ADVICE
PUBLIC STATS$DLM_MISC
PUBLIC STATS$ENQUEUE_STAT
PUBLIC STATS$FILESTATXS
PUBLIC STATS$IDLE_EVENT
PUBLIC STATS$INSTANCE_RECOVERY
PUBLIC STATS$LATCH
PUBLIC RCL_SEQ
PUBLIC STATS$BG_EVENT_SUMMARY
PUBLIC STATS$BUFFER_POOL_STATISTICS
PUBLIC STATS$LATCH_CHILDREN
PUBLIC STATS$LATCH_MISSES_SUMMARY
PUBLIC STATS$LATCH_PARENT
PUBLIC STATS$LEVEL_DESCRIPTION
PUBLIC STATS$LIBRARYCACHE
PUBLIC STATS$PARAMETER
PUBLIC STATS$PGASTAT
PUBLIC STATS$PGA_TARGET_ADVICE
PUBLIC STATS$RESOURCE_LIMIT
PUBLIC STATS$ROLLSTAT
PUBLIC STATS$ROWCACHE_SUMMARY
PUBLIC STATS$SEG_STAT
PUBLIC STATS$SEG_STAT_OBJ
PUBLIC STATS$SESSION_EVENT
PUBLIC STATS$SESSTAT

Will post the fix for those synonyms when done..

Cheers,

St0ma

Categories: Oracle Tags:
Comments are closed.