error occurs during the update stats

[Former Member]

Hi Experts ,

We are facing the error in our BW system while running the update stats (error message as per below).Kindly help us to resolve the issue .database is 10.2.0.2.0 on AIX enviornment .

BR0301W SQL error -4063 at location BrTabModifRead-1, SQL statement:

'BEGIN DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO; END;'

ORA-04063: package body "SYS.DBMS_STATS" has errors

ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_STATS"

ORA-06512: at line 1

BR0280I BRCONNECT time stamp: 2009-04-08 04.02.28

BR0877I Checking and collecting table and index statistics...

BR0280I BRCONNECT time stamp: 2009-04-08 04.02.28

BR0881I Collecting statistics for table SAPR3./BI0/0P00000111 with method/sample E/P10 ...

BR0280I BRCONNECT time stamp: 2009-04-08 04.02.28

BR0301E SQL error -4063 at location stats_tab_collect-20, SQL statement:

'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPR3"', TABNAME => '"/BI0/0P00000111"', ESTIMATE_PERCENT => 10, METHOD_OPT => 'FOR ALL

ORA-04063: package body "SYS.DBMS_STATS" has errors

ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_STATS"

ORA-06512: at line 1

BR0886E Checking/collecting statistics failed for table SAPR3./BI0/0P00000111

BR0280I BRCONNECT time stamp: 2009-04-08 04.02.28

BR0881I Collecting statistics for table SAPR3./BI0/0P00000129 with method/sample E/P10 ...

BR0280I BRCONNECT time stamp: 2009-04-08 04.02.28

BR0301E SQL error -4063 at location stats_tab_collect-20, SQL statement:

[Former Member]

Hi,

also check sap note 633914 - Error when executing DBMS_STATS

Thanks,

Sushil

[Former Member]

Hello Parul

This error is generally caused due to inconsistent DDIC,you will have to import Catalog.sql and catproc.sql scripts to remove this error

*Refer to Note 582427

*it will give you solution for your problem

Let me know of any questions

Rohit