Solution : https://service.sap.com/sap/support/notes/534729 (SAP Service marketplace login required)
Summary :
This SAP Note addresses a range of Oracle errors such as ORA-03106, ORA-03108, and ORA-03113, indicating intermittent network issues as likely causes. Errors like ORA-03113 and ORA-03114 stem from separate issues. The document suggests network analysis and adjustment, using SAP's NIPING tool for diagnostics. Recommendations include setting network to FULL DUPLEX and modifying TCP/IP parameters in registry settings. For persistent errors on Windows, checking AWE usage is advised. The note also suggests potential software bugs on specific platforms, like AIX, influencing ORA-03113.
Key words :
components bc-net network infrastructure priority recommendations / additional info category, ------- times ----- avg 59053 usecs max 65033 usecs min 54342 usecs bw 992, incorrect ora_nls33 335199 ora-3113 collective note 198752 tcp delay problem, hkey_local_machine\system\currentcontrolset\services\tcpip\parameters, customer component bc-db-ora oracle, sap notes 997336 interrupted network connections 952388 kernel <= 6, 9i client software 653690 composite sap note, __%pdfstyle%__ / } symptom ora-03106, 30000the niping output appears approximately, bw 198752 tcp delay problem
Related Notes :
| 997336 | Interrupted network connections |
| 952388 | Kernel <= 6.40:UNIX error due to 9i Client software |
| 930818 | ORA-3106 after installing 9.2.0.7 + Patch 3, 5, or 6 (WIN32) |
| 653690 | Composite SAP note: ORA-24365 |
| 618861 | Composite SAP Note: ORA-01013 |
| 500235 | Network Diagnosis with NIPING |
| 393620 | Problems through incorrect ORA_NLS33 |
| 335199 | ora-3113 collective note |
| 198752 | TCP delay problem under Oracle 8.1.x |
| 180605 | Oracle database parameter settings for BW |
| 135942 | ora 12571 and 3113 on NT INTEL ( Oracle 7.3 + 8.X ) |
| 124361 | Oracle parameterization (R/3 >= 4.x, Oracle 8.x/9.x) |