CTX server problems

From: AK <ak_at_ak.org>
Date: Fri, 28 Nov 2003 04:19:36 GMT
Message-ID: <s1Axb.712$hX1.21638@news.optus.net.au>

Hi,

I'm running a 8.1.7 Oracle database on TRU64. Some of the applications that use this database are running free text searches. I have noticed that the CTX service processes keep dying. I started logging stdout to a file upon starting up the ctx server and saw that two of three servers started die within about 4 minutes of startup with this error:

RG-50857: oracle error in drueixe
oracle error in drueixe

ORA-20000: interMedia Text error:
DRG-10204: server update failed
ORA-01000: maximum open cursors exc

14:01:35 11/24/03 === Server shutting down ===

I have looked at the alert log around this time and cannot find anything   that shows me that max open cursors are exceeded, and no trace file to look up to see what in fact caused this.

The third CTX server that I start (two die as above) continues for over a day and then reaches max open cursors and shuts down.

I am wondering whether others have seen a CTX server that is maxing out open cursors and whether it is an application running that is causing the CTX server to max out.

Can someone please suggest how I can figure this one out?

thanks,
-AK Received on Thu Nov 27 2003 - 22:19:36 CST