Solution : https://service.sap.com/sap/support/notes/92537 (SAP Service marketplace login required)
Summary :
This SAP Note addresses issues such as lengthy database connection times, poor response times, various Oracle errors (ORA 7307, ORA 7337), SQL*Net errors (e.g., TNS 12164), and system instabilities including terminated links and bus errors with Oracle-based systems. The identified cause likely stems from Oracle trace being enabled in Oracle versions 7.3.* and 8.0.*. The recommended solution involves backing up all *.dat files in $ORACLE_HOME/otrace/admin to *.dat.OLD and subsequently deleting the original *.dat files to mitigate these performance and stability issues.
Key words :
symptom long database connect timespoor response time performanceora 7307, directory $oracle_home/otrace/admin, ora 7337sql net error, mount point $oracle_home, sqlplus / svrmgrltrace files, additional key words, hangbus error, links terminate, core dumps, oracle versions 7
Related Notes :
| 505630 | Composite SAP Note ORA-12547 |
| 437362 | Composite note ORA-12500 |
| 144011 | Current patch set 7.3.4.X |
| 131561 | Work processes sometimes abend during database connect |