Issue:
******
One of the DBMS JOB failed and recorded error in the alertlog as
From ORCL database alert log file /ORCL/ORCLDB/10.2.0/admin/ORCL_ctloraerp06/bdump/alert_ORCL.log
9:ORA-12012: error on auto execute of job 282253
10:ORA-04063: ORA-04063: package body "SYS.DBMS_STATS" has errors
Observation:
************
SYS.DBMS_STATS Package Body is Invalid.
select object_name,object_type ,owner, status from dba_objects where object_name='DBMS_STATS';
OBJECT_NAME OBJECT_TYPE OWNER STATUS
-------------------- ------------------- ------------------------------ -------
DBMS_STATS PACKAGE SYS VALID
DBMS_STATS PACKAGE BODY SYS INVALID
DBMS_STATS SYNONYM PUBLIC VALID
Solution
*********
Rebuild/ Re-compile the DBMS_STATS Objects as
connect / as sysdba
@?/rdbms/admin/dbmsstat.sql
@?/rdbms/admin/prvtstas.plb
@?/rdbms/admin/prvtstat.plb
Tuesday, June 3, 2008
DBMS_STATS becomes INVALID after Refresh/Database Upgrade.
Posted by M A D A N M O H A N at 10:04 AM
Labels: POST DB UPGRADE ISSUES
Subscribe to:
Post Comments (Atom)
2 Comments:
Hi Mohan,
This is something unrelated to this post. Can you tell me whether I have to resign the jars that are loaded while opening Oracle Apps(ie, fndewt, fndforms, fndutil etc) if I use my own jar in a custom form? My custom jar has been signed with my own identity.
I
was curious if you ever thought of changing the layout of your blog?
Its very well written; I love what youve got
to say. But maybe you could a little more in the way of
content so people could connect
with it better. Youve got an awful lot of text for only having 1 or 2
pictures. Maybe you could space it out better?
Also visit my weblog; View Here
Post a Comment