Skip to Content
avatar image
-1
Former Member

Oracle 12c Error DBSTATC on RedHat 7

Hello,

i have installed a new system based on EHP8 for SAP ERP 6.0 RHEL7 / Oracle 12c.

I have installed the latest Oracle Bundle Patch and latest SAP Kernel 749.

When I execute the update statistic I can view this error:

BR0280I BRCONNECT thread 5 time stamp: 2017-03-05 04:43:24 BR0844E 100 errors occurred in thread 5 - terminating processing in the thread... BR0280I BRCONNECT thread 11 time stamp: 2017-03-05 04:43:24 BR0881I Collecting statistics for table SAPSR3.TCP02 with method/sample C ... BR0280I BRCONNECT thread 9 time stamp: 2017-03-05 04:43:24 BR0301E SQL error -6521 in thread 9 at location stats_tab_collect-66, SQL statement: 'EXECUTE stmt_1a' 'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME => '"TCOKO"', ESTIMATE_PERCENT => NULL, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1', DEGREE => NULL, CASCADE => TRUE, NO_INVALIDATE => FALSE); END;' ORA-06521: PL/SQL: Error mapping function ORA-06512: at "SYS.DBMS_STATS", line 34634 ORA-06512: at line 1 BR0886E Collecting statistics failed for table SAPSR3.TCOKO BR0280I BRCONNECT thread 9 time stamp: 2017-03-05 04:43:24 BR0881I Collecting statistics for table SAPSR3.TCP03 with method/sample C ... BR0280I BRCONNECT thread 8 time stamp: 2017-03-05 04:43:24 BR0301E SQL error -6521 in thread 8 at location stats_tab_collect-66, SQL statement: 'EXECUTE stmt_1a' 'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME => '"TCORW"', ESTIMATE_PERCENT => NULL, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1', DEGREE => NULL, CASCADE => TRUE, NO_INVALIDATE => FALSE); END;' ORA-06521: PL/SQL: Error mapping function ORA-06512: at "SYS.DBMS_STATS", line 34634 ORA-06512: at line 1 BR0886E Collecting statistics failed for table SAPSR3.TCORW

Have you an idea ?

I have search any solution on Oracle and SAP support, but ...

cdt,

Mohamed

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Mar 04, 2017 at 02:47 PM

    Hello all,

    I solved my issue. For that i have re-compile the DBMS_STATS object:

    sqlplus "/ as sysdba";
    
    @?/rdbms/admin/dbmsstat.sql
    @?/rdbms/admin/prvtstas.plb
    @?/rdbms/admin/prvtstat.plb
    
    After that I have run the catproc.sql and utlrp.sql
    
    
    Regards.
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Hello Christian,

      I confirm, this bug is on the last Bundle Patch...
      I tryed same installation without this bundle Patch, and the error not appair.

      So, I waitting the next patch for the next bug :)

      regards,

      Mohamed.