DB13 CheckDb and Update Stats Error

[Former Member]

Hi,

I am getting below error in CheckDb and Update stats:

Update Stats:

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

'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPCRM"', TABNAME => '"WSSOAPPROP_DARK"', ESTIMATE_PERCENT => NULL, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1', DEGREE => NULL

ORA-20003: Specified bug number (5099019) does not exist

ORA-06512: at "SYS.DBMS_STATS", line 14537

ORA-06512: at "SYS.DBMS_STATS", line 14558

ORA-06512: at line 1

Check Db :

BR0301E SQL error -1031 at location BrDbdiffRead-1, SQL statement:

'PREPARE stmt_5 STATEMENT FROM'

'SELECT OBJNAME FROM "SAPSR3".DBDIFF WHERE DBSYS IN ('ORACLE', ' ') AND OBJTYPE = 'TABL' AND DIFFKIND IN ('02', '61', '99') ORDER BY OBJNAME'

ORA-01031: insufficient privileges

BR0806I End of BRCONNECT processing: ceeuoqja.chk 2010-12-17 06.30.46

BR0280I BRCONNECT time stamp: 2010-12-17 06.30.46

BR0804I BRCONNECT terminated with errors

Above both errors are of different System and both system are just get ready after System Copy of PRD Server.

Please suggest possible route cause of this error.

Shivam

[Former Member]

for update stats issue check Note 1417124 - Error ORA-20001 in statistics class CL_SDB_ORA_UPDATE_STATS

for DB check error go through note 400241

Please search before you post your thread on SDN