Oracle 12c Error DBSTATC on RedHat 7

[MKI]

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

[MKI]

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.

[Former Member]

Hi,

we get same issue at NW7.01, SLES 12/Oracle 12c with latest bundle patch SAP_Bundle_Patch_12.1.0.2.170117_-_201702. Issue solved with your solution. Big THX.

regards

[MKI]

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.