DB13 update statistics fails - After systemcopy

[former_member199632]

Hi,

I have performed a homogeneous system copy from Production (PRD)  to Quality Server.(QAS)

(Restored from a PRD backup)

Post installation steps are done on QAS & system is functioning properly

But, when it executes the job  "Check and update optimizer statistics" on QAS ... after if seconds that job fails.

(Detail log file is attached. - log.txt)

(In PRD , it executes successfully)

--------------------------------------------------------

BR0817I Number of monitored/modified tables in schema of owner SAPSR3: 71016/16909

BR0280I BRCONNECT time stamp: 2014-01-09 11.19.11

BR0877I Checking and collecting table and index statistics...

BR0280I BRCONNECT time stamp: 2014-01-09 11.19.11

BR0881I Collecting statistics for table SAPSR3./BI0/D0PPM_VC11 with method/sample CH ...

BR0280I BRCONNECT time stamp: 2014-01-09 11.19.12

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

'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME => '"/BI0/D0PPM_VC11"', ESTIMATE_PERCENT => NULL, METHOD_OPT => 'FOR ALL COLUMNS SIZE 75', DEGREE => NULL

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

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

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

ORA-06512: at line 1

BR0886E Checking/collecting statistics failed for table SAPSR3./BI0/D0PPM_VC11

BR0280I BRCONNECT time stamp: 2014-01-09 11.19.12

BR0881I Collecting statistics for table SAPSR3./BI0/D0PPM_VC1P with method/sample CH ...

BR0280I BRCONNECT time stamp: 2014-01-09 11.19.12

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

'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME => '"/BI0/D0PPM_VC1P"', ESTIMATE_PERCENT => NULL, METHOD_OPT => 'FOR ALL COLUMNS SIZE 75', DEGREE => NULL

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

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

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

ORA-06512: at line 1

BR0886E Checking/collecting statistics failed for table SAPSR3./BI0/D0PPM_VC1P

--------------------------------------------------------

Number of Tables Without Statistics:	532
Number of Indexes Without Statistics:	159
Number of Tables Whose Statistics Were Deleted:	0
Number of Indexes Whose Statistics Were Deleted:	0
Number of Tables Whose Statistics Were Checked:	100
Number of Tables Selected After Check:	0
Number of Tables for Which Statistics Were Collected:	0
Number of Indexes for Which Statistics Were Collected:	0
Number of Indexes Whose Structure Was Checked:	0
Number of Indexes Whose Structure Was Checked:	0

I have tried with brconnect -u / -c -f stats -t all as well

But the same error pops up

What could be the reason for this.

regards,

zerandib

log.TXT.zip

[Former Member · Accepted solution]

Hi ,,

Try below will solve the issue.

SQL> @?/rdbms/admin/dbmsstat.sql

SQL> @?/rdbms/admin/prvtstas.plb

SQL> @?/rdbms/admin/prvtstat.plb

Rableen

[Former Member]

hi

Along with the above , please see the below thread !!

Thanks

Rishi

[Former Member]

Hi,

Please check the below note.

1431798 - Oracle 11.2.0: Database Parameter Settings

1667086 - ORA-20003 - Specified bug number (<number>) does not exist.

_FIX_CONTROL'5099019:ON'

Thanks

Rishi Abrol

[Former Member]

Hi,

Take a look at 1667086  - ORA-20003 - Specified bug number (<number>) does not exist.            

Search SDN/Google before posting a query (Suggestion).

Regards,

Nick Loy