ORA-20003 Specified Bug number ( 5099019 ) does not exist

[former_member207834]

Hi,

During SRM 7.0 installation ,we are facing below error during optimizer statistic. ( on Solaris SPARC ./ Oracle )

ORA-20003 Specified Bug number ( 5099019 ) does not exist

Below command list this bug.

SQL> select bugno from v$system_fix_control;

We tried to use fixcontrol parameter as per note :-1455168

but after that we got error the 'ORA-00940: invalid ALTER command' while starting database.

We also installed SAP® Bundle Patch 10.2.0.4.4 - 201007.

Please let me know if anybody has faced this problem?

Best Regards,

Tushar.

[Former Member]

Hi,

I am assuming that you are using Oracle 10g, and this error comes when your stats are not build for system tablespace, from oracle 10g there is no RBO as it is used to be in 9 version of Oracle for System tablespace. Onwards 10g everything is CBO even for System and Sysaux.

Call for creating Oracle dictionary statistics:

SQL> exec DBMS_STATS.GATHER_DICTIONARY_STATS

BRCONNECT calls GATHER_DICTIONARY_STATS as follows. Oracle dictionary statistics are thus created with the highest accuracy, and are active immediately.

SQL> 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;

Using BRTOOLS.

Creating Oracle system statistics (NOWORKLOAD) using brconnect

$ brconnect -u / -c -f stats -t system_stats

Creating Oracle system statistics (WORKLOAD) using brconnect

$ brconnect -u / -c -f stats -t system_stats -i <minutes>

I hope it will eliminate your issue....

All the best !

[former_member207834]

Hi Prateek,

SAPINST is trying to create statistics using below command.

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

Then we got 'ORA-20003 Specified Bug number ( 5099019 ) does not exist'

If we gather statistics as per note :- 838725 , will SAPINST be able to recognize that.?

We will gather statistics as per note 838725 as well.

Best Regards,

Tushar

[Former Member]

If you are able to login to oracle sql pls give this command, that bug is kind of when your stats are missing for system tbs.

SQL> exec DBMS_STATS.GATHER_DICTIONARY_STATS

Hope it will solve your issue !

[former_member207834]

Hi,

This problem is solved.

1.SAP released updated SAP bundle patches on the same day ( 21-07-2010 ) when we faced this problem.

We revoked patches & performed post installation instructions from README-PSU.html & bundle patch read me file.

Then we restarted SAPINST & then it worked.

Best Regards,

Tushar