Mailing List
Home
Forum Home
Oracle List - by freelists.org
Oracle on SUSE Linux - Runing Oracle on SUSE Linux
Oracle database error code ...
www.freelists.org
Subjects
ORA 12540: TNS:internal limit restriction exceeded
ORA 12838 please : Is possible to append two times to the same table befo
ORA 12838 please : Is possible to append two times to the same table before
ora 04031
ora 12500 on windows
ORA 32004: obsolete and/or deprecated parameter(s) specified
ORA 01925: maximum of 30 enabled roles exceeded
ORA 01925: maximum of 30 enabled roles exceeded
ora 12500 on windows
ORA 01650, one idea
ORA 01650
ORA 4030
ORA 12838 please : Is possible to append two times to thesametable before do
ORA 12838 please : Is possible to append two times to thesame table before d
ORA 01536
ORA 03113 end of file on communication channel
ORA 32004: obsolete and/or deprecated parameter(s) specified
ORA 00600:
ORA 00020: maximum number of processes (%s) exceeded
ORA 01925: maximum of 30 enabled roles exceeded
ORA 3113 while creating a cluster database 9201 RAC on Linux with OCFS
ora 12500 on windows
ora 12500 on windows
ora 12500 on windows
ORA 01650, one idea
ora 12500 on windows
ora 12500 on windows
ora 12500 on windows
ORA 2000 Error Using DBMS STATS GATHER SCHEMA STATS
ORA 01650, one idea
ORA 01650, one idea
ORA 01650, one idea
ORA 01650
ORA 01650
Subject: ora 01031
ORA 4030
ORA 4030
ORA 06502: PL/SQL: numeric or value error: Bulk Bind: Truncated Bind
Subject: Re: ORA 01722 invalid number
 
Subject: SLES 10 and Oracle 10g R2, a lot of Oracle Process

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

2007-11-12       - By cung

 Back
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