Re: SLES 10 and Oracle 10g R2, a lot of Oracle Process
"Alexei_Roudnev" <[email protected]>
| Newsgroups | gmane.linux.suse.oracle.general |
|---|---|
| Message-ID | <[email protected]> |
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" <[email protected]> To: <[email 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:[email protected]] >>Sent: Monday, November 12, 2007 1:51 PM >>To: [email 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: [email protected] >>For additional commands, email: [email protected] >>Please see http://www.suse.com/oracle/ before posting > -- To unsubscribe, email: [email protected] For additional commands, email: [email protected] Please see http://www.suse.com/oracle/ before posting