Re: CTX server problems

From: Guy Dallaire <gd-newsgroups_at_spamex.com>
Date: Mon, 1 Dec 2003 15:14:13 -0500
Message-ID: <qiNyb.21$_I6.1808@news20.bellglobal.com>

We had the same sort of problems with 8.1.7.x on solaris 32 bits. There was no fix at oracle. SOlution was to monitor the process from the OS side and restart as necessary. One of our database instance exhibitd the problem, the other one was not, but it was not as heavily used. Looks like some sort of cursor leakage (opened but never closed).

Be warned that the ctxsrv process will be phased out. I think it is not even available in 9i. Instead take a look on metalink for the CTX_SCHEDULE package. It uses dbms_job to submit index resyncs from time to time (programmable)

Intermedia is NOT designed to index stuff "on the fly". Normally, you refresh the text indices from time to time. (Updates and inserts to indexed columns are queued in some tables) But, normally, users want to see their changes "immediately" you will have to design around this and/or educate your users.

We have some indexes here that are refreshed every 15 minutes. This is the minimum time we can give our users. Otherwise, your system will always be indexing and that's not a good idea.

"AK" <ak_at_ak.org> a écrit dans le message de news:s1Axb.712$hX1.21638_at_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 Mon Dec 01 2003 - 14:14:13 CST