Solution : https://service.sap.com/sap/support/notes/541695 (SAP Service marketplace login required)
Summary :
This SAP Note addresses issues where Oracle's background processes such as LGWR, DBWR, PMON, ARCH, and SMON terminate unexpectedly, causing database stoppages documented in the Oracle alert log and R/3 syslog. The terminations are primarily due to errors (e.g., ORA-00470 to ORA-00485) that may follow initial errors noted in trace files or be caused by external factors like OS limits or software bugs, particularly in the Veritas cluster environment. Resolving these issues requires analyzing trace files and alert logs to pinpoint the cause and possibly adjusting OS configurations or updating software to prevent recurrence.
Key words :
file /oracle/<sid>/saptrace/background/lgwr_<pid>_<sid>, file /oracle/<sid>/saptrace/background/pmon_<pid>_<sid>, file /oracle/<sid>/saptrace/usertrace/ora_310834_p06, file /oracle/<sid>/saptrace/background/pmon_96024_p06, lgwr_<pid>_<sid>, pmon_<pid>_<sid>, errorthe lgwr process terminates due, pmon trace file pmon_96024_p06, oracle server session terminated, oracle background processes terminate
Related Notes :
| 789011 | FAQ: Oracle memory areas |
| 308880 | Database processes crash |
| 172747 | SAP on HP-UX: OS kernel parameter recommendations |
| 142019 | 3GB Memory and Oracle 8 on Windows (NT or 2000) |