SAP Issues And How To Resolve Them

DB13 CheckDB – BRCONNECT errors with the following:

BR0301E SQL error -1031 at location BrDdartRead-1
ORA-01031: insufficient privileges

See SAP note:
Note 900525 - BRCONNECT fails with ORA-01031 at location BrDdartRead-1

Essentially:
Re-run SQL file sapdba_role.sql from \usr\sap\SID\SYS\exe\run





Long running BBP/SRM job BBP_GET_STATUS_2:

See SAP note:
Note 521857 - Selection parameters for BBP_GET_STATUS/BBP_GET_STATUS_2

In DB13 – Table tablename has no statistics:

See SAP note:

Essentially:
SQLPLUS> Alter table sapr3.tablename monitoring;