Subject: Re: SLES 10 and Oracle 10g R2, a lot of Oracle Process 2007-11-12 - By Alexei_Roudnev
Back
Are you awared of the strange Oracle bug - if system (!) uptime > 238 days,
sqlplus freeze for the next 238 days?
(It was fixed in 10.2.0.3 only).
-- -- Original Message -- --
From: "cung" <cung@(protected)>
To: <suse-oracle@(protected)>
Sent: Monday, November 12, 2007 4:21 AM
Subject: RE: [suse-oracle] SLES 10 and Oracle 10g R2, a lot of Oracle
Process
> Hi Yoav,
>
> No error message when i command sqlplus "/ as sysdba"
> Just blank command prompt.
>
> Listener still up.
>
> rgds,
> cung
>
>
> At 07:02 PM 11/12/2007, you wrote:
>>Hi
>>
>>Haven't seen your previous error so I will relates to what you have
>>added now .
>>
>>Firs t check id your listener on the STD is up and running AND
>>servicing your D global service . If not the archive will not be
>>sent by the Primary DB . (Std is not pulling , Primary is pushing )
>>.
>>
>>Which error message you get once you try to connect via sqlplus
>>?
>>
>>Yoav
>>
>>-- --Original Message-- --
>>From: cung [mailto:cung@(protected)]
>>Sent: Monday, November 12, 2007 1:51 PM
>>To: suse-oracle@(protected)
>>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
>
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
|
|
