Re: [suse-oracle] Server Hang, Program or HW?

Dear Alexei,

Thank for your information.
Sorry my e-mail is problem from last weeks

rgds,
cung

At 12:53 AM 9/4/2008, you wrote:
>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: <mailto:[email protected]>cung
>To: <mailto:[email protected]>Alexei_Roudnev ; 
><mailto:[email protected]>[email protected]
>Cc: <mailto:[email protected]>[email protected] ; 
><mailto:[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: <mailto:[email protected]>cung
>>To: <mailto:[email protected]>[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