Should I re-install the database server due to mysterious missing program units?
Hi,
This morning the EM console reported numerous warning alerts on invalid object counts. There were 242 invalid objects consisting of prodecure, type body, package, package body from ctxsys, dbsnmp, exfsys, flows_030000, mdsys, olapsys, oracle_ocm, ordplugins, ordsys, sys, sysman, wksys, and xdb.
When I installed the database server, I ran the sql script utlrp.sql and found NO errors. So, I re-ran the script again and hoped to re-validate those objects and found the remaining 79 invalid objects. Below is the output:
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
$ sqlplus "/ as sysdba" SQL*Plus: Release 11.1.0.6.0 - Production on Fri Jun 26 14:02:10 2009 Copyright (c) 1982, 2007, Oracle. All rights reserved. 　 Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> @?/rdbms/admin/utlrp.sql TIMESTAMP -------------------------------------------------------------------------------- COMP_TIMESTAMP UTLRP_BGN 2009-06-26 14:02:51 DOC> The following PL/SQL block invokes UTL_RECOMP to recompile invalid DOC> objects in the database. Recompilation time is proportional to the DOC> number of invalid objects in the database, so this command may take DOC> a long time to execute on a database with0