Symptom
During the Oracle database check / update optimizer, you are getting below error (You can find the error from transaction code DB13 or DB14).
BR0925I Public synonym SAP_SDBAH created successfully for table SAPSR3.SDBAH
BR0925I Public synonym SAP_SDBAD created successfully for table SAPSR3.SDBAD
BR0280I BRCONNECT time stamp: 2013-01-24 16.36.38
BR0301W SQL error -980 at location brc_dblog_open-1, SQL statement:
'INSERT INTO SAP_SDBAH (BEG, FUNCT, SYSID, OBJ, RC, ENDE, ACTID, LINE) VALUES
('20130124163632', 'chk', 'ARA', 'DATABASE', '9999', '7.20 (23) check')'
ORA-00980: synonym translation is no longer valid
BR0324W Insertion of database log header failed
Solution
Execute transaction code SE14. Check and verify below tables are exists on the SAP system. If not, please create them accordingly.
• SDBAC
• SDBAD
• SDBAH
• SDBAP
• SDBAR
