Skip to Main Content

Enterprise Manager

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to run @?/rdbms/admin/utlrp.sql from OEM?

80675Apr 17 2008 — edited May 27 2009
After 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 24 2009
Added on Apr 17 2008
4 comments
60,650 views