Re: SLES 10 and Oracle 10g R2, a lot of Oracle Process

I tried standby on SLES10 SP1(beta) with Oracle 10.2.0.3 some time ago, and 
it worked fine except  it sometimes lost log shipping stream (async io error 
on network) so it lost syncronization and then resyncronized by FAL (as a 
result, we did a negative conclusion and used SLES9 SP3 for oracle, not 
SLES10).

But it worked, under the average load, without any problems.

PS. What do you mean 'standby server can't transport the archive_log from 
primary server'? It is primary server which
send logs to standby. Standby can fetch logs from primary, usig FAL, only if 
some logs have not been delivered because of network error or any other 
reason.

So what exactly did you tried to do? (How did you created Standby - another 
question. The only _reliable_ way to do it is to use OEM or at least data 
guard. If you created standby manually, there is 50% chance of configuration 
errors, in our experience).


----- Original Message ----- 
From: "cung" <[email protected]>
To: <[email protected]>
Sent: Monday, November 12, 2007 3:50 AM
Subject: [suse-oracle] SLES 10 and Oracle 10g R2, a lot of Oracle Process


> Dear all,
>
> This is new error beside the other one I already posting.
>
> I have configure stand by database on fujitsu tx200 s2, memory 2 GByte.
> The error is arise on standby server.
>
> The standby server can't transport the archive_log from primary server.
> I can't run sqlplus "/ as sysdba" command on the standby server.
>
> Using top a lot of oracle process over there.
>
> Did someby have encounter this problem?
>
> Rgds,
> cung
>
>
> This the result from top and vmstat 5
>
>
> top - 18:15:15 up 49 days, 19:35,  1 user,  load average: 17.65, 17.75, 
> 17.73
> Tasks:  77 total,  20 running,  57 sleeping,   0 stopped,   0 zombie
> Cpu(s): 36.6%us, 63.4%sy,  0.0%ni,  0.0%id,  0.0%wa,  0.0%hi,  0.0%si, 
> 0.0%st
> Mem:   2075132k total,  2026616k used,    48516k free,   163232k buffers
> Swap:  4200988k total,   978532k used,  3222456k free,  1747852k cached
>
>   PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
> 18815 oracle    25   0 1210m 2988 2884 R 11.0  0.1   9:42.05 oracle
> 18795 oracle    25   0 1210m 4604 4428 R 10.0  0.2   9:42.46 oracle
> 18797 oracle    25   0 1210m 2952 2848 R 10.0  0.1   9:42.15 oracle
> 18799 oracle    25   0 1210m 3024 2916 R 10.0  0.1   9:42.34 oracle
> 18801 oracle    25   0 1242m 7212 7096 R 10.0  0.3  17:06.28 oracle
> 18803 oracle    25   0 1210m 3116 3004 R 10.0  0.2   9:42.13 oracle
> 18805 oracle    25   0 1210m 4484 4320 R 10.0  0.2   9:43.93 oracle
> 18811 oracle    25   0 1210m 2976 2872 R 10.0  0.1   9:42.13 oracle
> 18803 oracle    25   0 1210m 3116 3004 R  9.0  0.2   9:42.03 oracle
> 18815 oracle    25   0 1210m 2988 2884 R  9.0  0.1   9:41.94 oracle
>     1 root      16   0   716  112   80 S  0.0  0.0   0:02.57 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 R  0.0  0.0   0:00.15 ksoftirqd/0
>     4 root      10  -5     0    0    0 S  0.0  0.0   0:02.72 events/0
>     5 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 khelper
>     6 root      10  -5     0    0    0 S  0.0  0.0   0:00.00 kthread
>     8 root      10  -5     0    0    0 S  0.0  0.0   0:00.55 kblockd/0
>
>
> procs -----------memory---------- ---swap-- -----io---- -system-- 
> -----cpu------
>  r  b   swpd   free   buff  cache   si   so    bi    bo   in   cs us
> sy id wa st
> 18  0 978532  46772 164148 1747976    0    0     0     4  269   39 33
> 67  0  0  0
> 17  0 978532  46772 164148 1747976    0    0     0     0  266   30 35
> 65  0  0  0
> 18  0 978532  46772 164148 1747976    0    0     0     0  266   36 34
> 66  0  0  0
> 18  0 978532  46772 164148 1747976    0    0     0     1  264   31 36
> 64  0  0  0
> 18  0 978532  46772 164148 1747976    0    0     0     0  266   34 35
> 65  0  0  0
> 17  0 978532  46772 164148 1747976    0    0     0     0  264   33 36
> 64  0  0  0
> 18  0 978532  46260 164148 1747976    0    0     0     1  268   45 36
> 64  0  0  0
> 


-- 
To unsubscribe, email: [email protected]
For additional commands, email: [email protected]
Please see http://www.suse.com/oracle/ before posting