SLES 10 and Oracle 10g R2, a lot of Oracle Process 2007-11-12 - By Alexei_Roudnev
Back
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" <cung@(protected)>
To: <suse-oracle@(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: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
|
|
