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

Dear Honza,

I didn't run anythings beside oracle database.

rgds,
cung

At 02:08 AM 9/2/2008, you wrote:
>Hello Cung and All,
>
>have you started using any Java program in the last few days ? I had 
>bad expirience for example with Oracle Universal
>Installer. It crashed every time I started it on SMP machine. When I 
>disabled second CPU (or boot with non-SMP kernel),
>everything goes well. It had the same symptoms you described.
>
>Honza
>
>cung wrote:
> > 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

_______________________________________________
suse-oracle mailing list
[email protected]
http://listx.novell.com/mailman/listinfo/suse-oracle