How to run @?/rdbms/admin/utlrp.sql from OEM?
80675Apr 17 2008 — edited May 27 2009After I make database changes I have to run utlrp.sql to compile all the invalid objects. I know how to do it from the host. But now I'm running this release from the OEM as sql jobs.
Is there any equivalent of @?/rdbms/sadmin/utlrp.sql running from OEM?
error msg:
DOC> 2. Query showing UTL_RECOMP jobs that are running
DOC> SELECT job_name FROM dba_scheduler_running_jobs
DOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%';
DOC>#
utl_recomp.recomp_parallel(threads);
*
ERROR at line 4:
ORA-06550: line 4, column 4:
PLS-00201: identifier 'UTL_RECOMP.RECOMP_PARALLEL' must be declared
ORA-06550: line 4, column 4:
PL/SQL: Statement ignored
Elapsed: 00:00:00.01
SELECT dbms_registry_sys.time_stamp('utlrp_end') as timestamp from dual
*
ERROR at line 1:
ORA-00904: "DBMS_REGISTRY_SYS"."TIME_STAMP": invalid identifier
Elapsed: 00:00:00.00
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.01
DOC> The following query reports the number of objects that have compiled
DOC> with errors (objects that compile with errors have status set to 3 in
DOC> obj$). If the number is higher than expected, please examine the error
DOC> messages reported with each object (using SHOW ERRORS) to see if they
DOC> point to system misconfiguration or resource constraints that must be
DOC> fixed before attempting to recompile these objects.
DOC>#
select COUNT(*) "OBJECTS WITH ERRORS" from obj$ where status = 3
*
ERROR at line 1:
ORA-00942: table or view does not exist