Skip to Content
0
Former Member
Sep 12, 2009 at 03:36 AM

ORA-20003 error on folowing job-brconnect -u / -c -f stats -t oradict_stats

443 Views

Hi all, When i am trying to run brconnect -u / -c -f stats -t oradict_stats .. i am getting the following errors & i have followed sap Note 838725 - Oracle Database 10g: New database statistics but however i am not cllear how should i iver come through this error.

sapql2:oraql2 1> brconnect -u / -c -f stats -t oradict_stats

BR0801I BRCONNECT 7.00 (16)

BR0805I Start of BRCONNECT processing: cebliuwm.sta 2009-09-11 23.25.28

BR0280I BRCONNECT time stamp: 2009-09-11 23.25.29

BR0807I Name of database instance: QL2

BR0808I BRCONNECT action ID: cebliuwm

BR0809I BRCONNECT function ID: sta

BR0810I BRCONNECT function: stats

BR0812I Database objects for processing: ORADICT_STATS

BR1314I Oracle dictionary statistics will be collected with default options

BR0126I Unattended mode active - no operator confirmation required

BR0280I BRCONNECT time stamp: 2009-09-11 23.25.29

BR1311I Starting collection of Oracle dictionary statistics...

BR0285I This function can take several seconds/minutes - be patient...

BR0280I BRCONNECT time stamp: 2009-09-11 23.25.30

BR0301E SQL error -20003 at location stats_oradict_collect-1, SQL statement:

'BEGIN DBMS_STATS.GATHER_DICTIONARY_STATS (ESTIMATE_PERCENT => NULL, METHOD_OPT

=> 'FOR ALL COLUMNS SIZE AUTO', GRANULARITY => 'ALL', CASCADE => TRUE, OPTIONS =

> 'GATHER', NO_INVALIDATE => FALSE); END;'

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

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

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

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

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

ORA-06512: at line 1

BR1313E Collection of Oracle dictionary statistics failed

BR0806I End of BRCONNECT processing: cebliuwm.sta 2009-09-11 23.25.30

BR0280I BRCONNECT time stamp: 2009-09-11 23.25.30

BR0804I BRCONNECT terminated with errors

regards,

rahul