Solution : https://service.sap.com/sap/support/notes/743555 (SAP Service marketplace login required)
Summary :
SAP systems using Oracle RAC might face buffer synchronization issues due to the use of the NOORDER option by default for creating the DDLOG sequence (DDLOG_SEQ). This configuration can disrupt the sequential order of events, impacting buffer synchronization as it depends on sequence numbers that represent temporal event ordering. The remedy involves halting all R/3 application servers, cleaning up the DDLOG table and sequence, and recreating the sequence with the ORDER option to ensure proper event sequencing. After these adjustments, the system can be rebooted to restore normal operations.
Key words :
create sequence ddlog_seq minvalue -2147483640 maxvalue 2147483640 increment, tab_grp -> dbatab_name -> dba_sequenceswclause -> sequence_name = 'ddlog_seq', higher sequence numbers belong, drop sequence ddlog_seq, lower numbers belong, real application cluster, sap database user, 1 cache 50 order nocycle, truncate table ddlog, buffer synchronization relies
Related Notes :
| 1171095 | Information about Oracle RAC 10.2 |
| 1092553 | Error in the buffer synchronization in the RAC environment |
| 527843 | Oracle RAC support in the SAP environment |