Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> CTX server problems
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
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