Re: [suse-oracle] Server Hang, Program or HW?
"Alexei_Roudnev" <[email protected]>
| Newsgroups | gmane.linux.suse.oracle.general |
|---|---|
| Message-ID | <[email protected]> |
Yes and no. yes, k. 244 can be used and if you dont run aio, I am not aware of any particular problems. Not, because as any 'release' or 'sp*' kernel, this kernel had some problems (at least in some scsi cases such as iSCSI) and so it's always better to upgrade at least 1 kernel ahead. For now, 2 kernels (and consistant upgrades) are known as a very stable k. 287 - last kernel in SP3 upgrades k. 312 - current kernel in SP4 upgrade. In all cases when I mean 'kernel' I mean full system uprade with all rpm's consistant to YOU repository. Keep in mind, that your problem can be not in the kernel or SuSe. For example, it can be in the wrong interface card or in the incompatible SCSI driver. PS. We use, with an excellent stability: SLES9 SP3 x86_64, iSCSI, kernel 287, reiserfs + lvm + 'SETALL' filesystemio setting. Less stability but system is a lab system so it's difficult to count it on the Linux: SLES9 SP3 k. 286, iSCSI, ASM, RAC cluster. Some problems caused by the low memory conditions (system runs 5 developers databases so it is oversubscribed, and servers are junk level DELL workstations, x86_64). I know about dozen other systems, most SLES9 SP3 k. 287, scsi , ext3 or reiserfs, oracle 10.2.0.3 and 10.2.0.4, very stable (performance labs and development systems). ----- Original Message ----- From: cung To: Alexei_Roudnev ; [email protected] Cc: [email protected] ; [email protected] Sent: Wednesday, September 03, 2008 4:58 AM Subject: Re: [suse-oracle] Server Hang, Program or HW? Dear Alexei, After I check and read your next e-mail for this case. My Async I/O status is oracle 10.2.0.2 : filesystemio_options = none disk_asynch_io=true <- don't care because i used reiserfs linux : # cat /proc/slabinfo | grep kio kioctx 63 90 256 15 1 : tunables 120 60 8 : slabdata 6 6 0 kiocb 0 0 128 30 1 : tunables 120 60 8 : slabdata 0 0 0 My conclusion that aio is running on Server but Oracle don't used it. Is that still any problems if I used SLES9 + SP3 2.6.5-7.244-bigsmp with out update on kernel? And is this case of that problems? My server hang, without any notification. best regards, cung At 01:44 AM 9/3/2008, Alexei_Roudnev wrote: Kernel 244 had a vew aio problems, and (in addition) was not stable enough for the productionm use. Upgrade to the kernel 287, or uporade the whole system to SLES9 SP4 and tpo the online-update kernel 312. (Dont use SLES9 SP4 with default kernel and aio). ----- Original Message ----- From: cung To: [email protected] Sent: Monday, September 01, 2008 1:08 AM Subject: [suse-oracle] Server Hang, Program or HW? Dear all, I need sugestion for my problem. My server installed using SLES 9 Patch 3, 2.6.5-7.244-bigsmp, Memory 4 GByte, Xeon Quad Core. Oracle Database Server 10.2.0.2. My Server for 3 days until now, always Hang, every 1,5 - 3 hours. Monitor blank, keyboard dan mouse not responding. No error log appear in alert log oracle or messages Linux. Here I copy the top and vmstat -S M 5. Thank you for your kindness, cung in top wait: 99%, 100%, 100% in vmstat bo: 0 0 18 9 top - 14:18:41 up 2:35, 6 users, load average: 4.39, 1.74, 0.84 Tasks: 188 total, 1 running, 187 sleeping, 0 stopped, 0 zombie Cpu0 : 0.0% us, 1.0% sy, 0.0% ni, 0.0% id, 99.0% wa, 0.0% hi, 0.0% si Cpu1 : 0.0% us, 0.0% sy, 0.0% ni, 100.0% id, 0.0% wa, 0.0% hi, 0.0% si Cpu2 : 1.0% us, 0.0% sy, 0.0% ni, 0.0% id, 99.0% wa, 0.0% hi, 0.0% si Cpu3 : 0.0% us, 0.0% sy, 0.0% ni, 0.0% id, 100.0% wa, 0.0% hi, 0.0% si Mem: 4143104k total, 3991088k used, 152016k free, 103696k buffers Swap: 8393952k total, 71036k used, 8322916k free, 3466772k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 7994 oracle 15 0 1792 1004 724 S 1.0 0.0 1:16.01 top 10265 oracle 15 0 1400m 21m 19m S 1.0 0.5 0:00.27 oracle 1 root 16 0 588 244 208 S 0.0 0.0 0:05.91 init 2 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/0 3 root 34 19 0 0 0 S 0.0 0.0 0:00.01 ksoftirqd/0 4 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/1 5 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/1 6 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/2 7 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/2 8 root RT 0 0 0 0 S 0.0 0.0 0:00.00 migration/3 9 root 34 19 0 0 0 S 0.0 0.0 0:00.00 ksoftirqd/3 10 root 5 -10 0 0 0 S 0.0 0.0 0:00.45 events/0 11 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/1 12 root 5 -10 0 0 0 S 0.0 0.0 0:00.00 events/2 2 1 52 148 134 3355 0 0 8942 12619 2109 10712 35 4 54 7 2 1 52 148 121 3366 0 0 9190 10144 1752 11633 29 3 65 3 1 0 55 149 110 3372 0 0 20309 6128 2297 10333 31 4 50 15 3 0 57 148 113 3372 0 0 8996 16897 2166 10030 29 3 55 12 1 2 64 148 113 3368 0 0 7898 11498 1769 9712 26 3 68 3 2 1 66 148 112 3374 0 0 12456 4963 1830 16411 30 4 58 8 1 0 66 149 112 3373 0 0 7154 13906 2079 19759 30 4 60 6 1 0 66 148 111 3375 0 0 7369 9350 1869 21321 26 4 64 6 procs -----------memory---------- ---swap-- -----io---- --system-- ----cpu---- r b swpd free buff cache si so bi bo in cs us sy id wa 2 0 66 148 110 3375 0 0 4517 6998 1848 47302 27 6 60 7 1 0 66 148 110 3383 0 0 109 5064 1831 81058 25 8 64 3 2 0 66 149 110 3380 0 0 110 4549 1680 80622 23 8 66 2 2 0 66 148 110 3386 0 0 113 3326 1560 106683 22 9 67 3 1 1 66 148 110 3386 0 0 2 3042 1170 96202 24 9 67 0 3 0 67 148 109 3388 0 0 9398 1696 1862 14269 26 3 67 4 1 3 68 148 109 3382 0 0 9194 12387 1663 13343 27 3 35 35 1 4 68 149 108 3386 0 0 9227 42 1201 12562 29 4 16 51 1 5 68 148 107 3388 0 0 9226 18 1143 12297 26 3 41 31 2 5 68 148 105 3388 0 0 9328 0 1143 12513 27 3 27 43 1 5 69 148 104 3388 0 0 9329 0 1142 13124 27 3 18 51 3 5 69 148 101 3386 0 0 23138 18 1303 13582 29 4 24 43 1 9 69 148 101 3385 0 0 2870 9 1073 4620 10 1 38 51 -------------------------------------------------------------------------- _______________________________________________ suse-oracle mailing list [email protected] http://listx.novell.com/mailman/listinfo/suse-oracle _______________________________________________ suse-oracle mailing list [email protected] http://listx.novell.com/mailman/listinfo/suse-oracle