Solution : https://service.sap.com/sap/support/notes/521264 (SAP Service marketplace login required)
Summary :
SAP Note describes hang situations in Oracle databases during start-up, operation, and shutdown processes. It categorizes the issue into distinct scenarios, such as hanging during login due to DLL issues, nonresponsive system startups across various OS such as HP-UX and SOLARIS, and hanging during operational events like logging changes and CPU overload in multiple Oracle versions. Troubleshooting suggestions include examining error messages, particularly the Oracle alert log, and diagnosing using ORADEBUG tool. Solutions range from adjusting incorrect Oracle DLLs, ensuring proper OS patching, disabling resource managers, and correctly setting database parameters to address potential hangs. Reference to other Notes is frequently made for specific fixes and deeper problem understanding.
Key words :
process <pid> user 'ora<sid>' program, online index build cleanup loop, large smon process space transactions, system issued informative error messages, smon process consumes 100% cpu, active source code areas, missing hp-ux patches, \oracle\<sid>\saptrace\background, dba mlock oper mlock, shutdown hangs andactive call
Related Notes :
| 1120875 | Shutdown immediate may take a long time > Oracle 9208/10202 |
| 908727 | Oracle 9 hangs on Windows 2003 64-bit and Service Pack 1 |
| 904662 | Database standstill on Oracle Rel >= 9.2.0.5 and MS 64-bit |
| 869521 | Oracle <= 10g: TM locks with REBUILD ONLINE / CREATE ONLINE |
| 825653 | Oracle: Common misconceptions |
| 745639 | FAQ: Oracle enqueues |
| 659946 | FAQ: Temporary tablespaces |
| 656809 | DB appears to hang if background_dump_dest incorrect |
| 618868 | FAQ: Oracle performance |
| 613872 | Oracle traces with ORADEBUG |
| 604176 | Performance deteriorates due to activated table monitoring |
| 603041 | High CPU consumption and AWE |
| 557447 | ORA-4031 After upgrade to Oracle 8.1.x.x |
| 528527 | Shutdown immediate takes longer than expected (>10 min) |
| 515080 | Importing Support Packages hangs. Work process with SEM -17 |
| 514758 | ORA-4031 and database hang after upgrade to 8.1.7.3 |
| 507254 | ORA-4031 and ORA-3113 when processing large IN lists |
| 445275 | shutdown normal does not work (NT) |
| 441802 | Reorganization with sapdba hangs during freespace check |
| 431881 | SAPDBA and BR tools hang on HP-UX 11 64-bit |
| 407314 | SAP kernel 6/7.x ORACLE: Released operating systems |
| 354080 | Note collection for Oracle performance problems |
| 329741 | Shutdown/startup hangs aft. 248 or 24,8 days uptime |
| 214995 | Oracle locally managed tablespaces in the SAP environment |
| 186119 | Restricting DB access to specific hosts |
| 156548 | Released operating systems for SAP kernel 4.6x ORACLE |
| 128726 | Hanging off-line Backup Oracle 8.0.4/8.0.5 on NT |
| 79341 | Checkpoint not complete |
| 391 | Archiver stuck |