Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » suse oracle »

RE: [suse-oracle] SLES 10 and Oracle 10g R2, a lot of Oracle
Process

cung

2007-11-12


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
©2008 dba.5341.com - Jax Systems, LLC, U.S.A.