Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> anyone using linux ops cluster as production database?
We have a suse7/oracle 81701 database cluster, and it seems not quite
stable. After one week or two, one of the ops instance will down, and
made the whole node reboot. Most of the time, it is the lmon process
that made the oracle down, thus the node down. I suspect whether my ops
instance parameter is ok:
lm_locks integer 67414 lm_ress integer 66487 The two node has 2 cpu and 1 g memory each. Can someone here using the linux ops post your configuration parameter? Thanks. alert log: Thread 1 advanced to log sequence 153 Current log# 3 seq# 153 mem# 0: /dev/raw13 Fri May 17 02:44:18 2002 LMON: terminating instance due to error 29702 Instance terminated by LMON, pid = 573
The following is the trace file of lmon: *** 2002-04-04 20:59:48.511 kgxggps: proposing substate 5 kgxggcs: Setting state to 8 5. *** 2002-04-04 20:59:51.610 Reconfiguration started Synchronization timeout: 600 sec List of nodes: 0,1, Lock DB frozen Non-local Process blocks cleaned out Non-local Group blocks cleaned out Resources and locks cleaned out Resources remastered 21667 Active sendback threshold = 8180 (tkts) Traffic controller Initialized Communication channels reestablished Submitted all rdomain info Submitted all remote-lock requests Update rdomain variables Dwn-cvts replayed, VALBLKs dubious *** 2002-04-04 21:06:29.540 All grantable locks granted *** 2002-04-04 21:06:29.578 Reconfiguration complete *** 2002-05-17 02:44:18.002 CM:CMRPC: read error occurred: errno=4, rcRead=0, bytesRead=0
kgxggpoll: skgxn error (12 CMGroupGetLiÛRPC failed status(1) respMsg->status(0)) Return code from kjxggpoll: 10 error 29702 detected in background process
-- an oracle fan, an oracle beginner Posted via dBforums http://dbforums.comReceived on Tue May 28 2002 - 01:14:12 CDT