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

[Former Member]

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

[Former Member]

Hello Rahul,

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

[former_member204746]

simply do not set 5099019 at all, that's means no OFF or ON.

[Former Member]

Hi There,

Be careful while setting the fixcontrol parameter. you can decide its values by 830576 or by executing a script attached to it.

To know the list of patches applied on your database, go to Opatch directory in dbs ($oracle_home/dbs/OPatchi think) and then do

opatch -lsinventory > list.txt

This will create a txt file list.txt with the information about the patches applied. Based on this you can set this

However, SAP recomends not to set this in OLTP systems unless it is obsolute

Thanks

[Former Member]

Hi Honrao,

Please see OSS Note 1233458 - Error during startup: ORA-00940: invalid ALTER command

Thanks,

Shambo

[Former Member]

Hello,

How could you resolve this issue at last. I am having the same error now..

Thanks,

Bharath

[Former Member]

Hello,

I was also facing same issue while upgrading ECC6.0 from EHP5 to EHP6 (SUM) with Oracle 11.2.0.1 in Check Phase.

ERROR - _______________________________________________________________________________

BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME => '"DD02L"', ESTIMATE_PERCENT => 10, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1', DEGREE => NULL, CASCADE => TRUE, NO_INVALIDATE => FALSE); END;'

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

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

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

ORA-06512: at line 1

BR0886E Collecting statistics failed for table SAPSR3.DD02L

_________________________________________________________________________________

I upgraded my Oracle version from 11.2.0.1 to 11.2.0.3 and repeat the phase.

After upgrade the database my issue has been resolved.

Thanks

Nitin Joshi

[Former Member]

Hi Rahul,

I can imagine 2 reasons for this error:

1. You have applied the latest optimizer merge fix from note #1165319 but forgot to do all the postinstallation steps that are mentioned in the readme. There is a section that tells you to execute dbmsstat.sql, prvtstas.plb and prvtstat.plb.

2. After the installation of the merge fix no relink was done for whatever reason.

Best Regards,

Michael

[Former Member]

Look at note 830576

Does list there that the parameter need to be set.

FIXCONTROL

'5099019:ON' (10.2.0.4 with fix 5099019 from Note 1165319)

Do review the associated notes and implement the parameter

Pravin

[Former Member]

Hello,

i guess, the fixcontrol parameter was already set by the op as described in the mentioned note which is then also most likely the reason why the error occured. The ability to set certain fixcontrol values is delivered with the Oracle patches and if those are not completly applied you can run into error like this one.

Best Regards,

Michael