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

[Former Member]

Greetings to everyone,

We come across the following error while we run 'oradict_stats' string below. On having surveyed the internet we haven't hit on anything confirm or compeling with resolution for this error. There is also another line where in it say its a bug # 5099019. On the basis of the search on the internet in this direction, it seem that if we use "set "_fix_control"='5099019:ON'" may rectify this bug.

Our question is will the line "set "_fix_control"='5099019:ON'" for sure do the trick & resolve both the error. "bug # 5099019 & ORA-06512: at "SYS.DBMS_STATS", line 14611".

Our current environment is ECC5.0 Production server on AIX 5.3 / Oracle 10.2.0.4

brconnect -u / -c -f stats -t oradict_stats

BR0280I BRCONNECT time stamp: 2009-09-11 17.35.11

BR1311I Starting collection of Oracle dictionary statistics...

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

BR0280I BRCONNECT time stamp: 2009-09-11 17.35.24

BR0301E SQL error -20003 at location stats_oradict_collect-4, 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 14611

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

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

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

ORA-06512: at line 1

BR1313E Collection of Oracle dictionary statistics failed

Will appreciate if anyone can share there inputs to resolve this error.

Thanks in advance

gab

[Former Member]

Hi ,

See the note

Note 838725 - Oracle 10.2: Dictionary and system statistics

It is released recently & have the solution for same error message.

Thanks,

Shambo

[Former Member]

check #761745

Nesimi

[Former Member]

Hello Gab

how you fix this problem?

I have the same error

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

I have installed the patch but if I set the oracle parameter "_fix_control"='5099019:ON'" the DB didn´t start by oracle error ORA-00940 invalid ALTER command

thanks

Hernando