Home » Server Options » Text & interMedia » CREATE INDEX ... as ctxsys.context fails with DRG-11422, DRG-00100, DRG-11208
CREATE INDEX ... as ctxsys.context fails with DRG-11422, DRG-00100, DRG-11208 [message #75980] Thu, 29 August 2002 05:21 Go to next message
Michael
Messages: 61
Registered: October 1999
Member
Hello,
I have a problem creating an index of type ctxsys.context. When i issue the command
create index ix_w_fulltext on w_fulltext( text ) indextype is ctxsys.context
i always get the error
ORA-29855: Fehler bei Ausführung der Routine ODCIINDEXCREATE
ORA-20000: interMedia Text-Fehler:
DRG-11422: Initialisierung der linguistischen Dienste nicht erfolgreich
DRG-00100: internal error, arguments : [[52100]],[[drxs.c]],[[553]],[[gxtopen]],[[1]]
DRG-11208: ORACLE_HOME wurde nicht eingestellt

ORA-06512: in "CTXSYS.DRUE", Zeile 126
ORA-06512: in "CTXSYS.TEXTINDEXMETHODS", Zeile 78
ORA-06512: in Zeile 1
(which is German, sorry, but apparently some task thinks that ORACLE_HOME has not been set, and therefore some linguistic services cannot be initialized.)

We have running Oracle 8.1.7.0.0 under Windows 2000 Server.
On this machine a previously installed Oracle 8.0 Client exists, therefore i thought that there maybe is a mess with the different settings of ORACLE_HOME. but i checked the registry into detail, explicitly set ORACLE_HOME, ORACLE_SID as system wide environment variables, found out that from version 8.1.7 the context servers run as an Oracle shadow process, found out that TEXT_ENABLE in init.ora is obsolete, played around with the EXTPROC / IPC sections of tnsnames.ora and listener.ora, although i read that for 8.1.7 this isn't necessary any more - but i didn't want to miss the chance -...

by the way, the user with which i want to create the index is member of the role CTXAPP.

the context service itself seems to run ok, cos i issued the command
exec ctx_output.start_log( 'log' )
and logging started without problems.

is there any place left where i could set ORACLE_HOME? i really have no idea which task still could need this setting, as Oracle 8.1.7 under Windows is said to contain almost all external processes in one task.

Thank you in advance,
Michael
Re: CREATE INDEX ... as ctxsys.context fails with DRG-11422, DRG-00100, DRG-11208 [message #75989 is a reply to message #75980] Thu, 26 September 2002 06:21 Go to previous messageGo to next message
ivermes
Messages: 1
Registered: September 2002
Junior Member
Hi,
the problem was in the lexer,
try the solution from http://www.experts-exchange.com/Databases/Oracle/Q_20188799.html,
it worked for me
regards
Ilona
Re: CREATE INDEX ... as ctxsys.context fails with DRG-11422, DRG-00100, DRG-11208 [message #75991 is a reply to message #75989] Wed, 09 October 2002 02:59 Go to previous message
Michael Gallo
Messages: 1
Registered: October 2002
Junior Member
Hello Ilona,
thank you very very much for this hint, it worked perfect for me, as well.

Best regards,
Michael
Previous Topic: What am I doing wrong? My currency converter is not working(Using visual c++)
Next Topic: Re: sqlcxt error
Goto Forum:
  


Current Time: Thu Mar 28 12:35:04 CDT 2024