Afair, user filter error 137 suggests that system environment is
not set up properly and extproc can't launch the ctxhx to do the
filtering or ctxhx is unable to load shared library it needs. You
should ensure that $ORACLE_HOME/ctx/lib is in the oracle's
LD_LIBRARY_PATH and that $ORACLE_HOME/ctx/bin is in the
oracle's PATH (you can also set these in the listener.ora file for
extproc connection using ENVS parameter.)
For second issue - this may indeed be the case that the index was
not created. This may also be the issue of inappropriate error message
and index exists but is marked INVALID/LOADING. In this case, you
can try to drop it with FORCE option (DROP INDEX my_index FORCE).
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Stefan Lipp" <snlipp_at_hotmail.com> wrote in message
news:a8e740ef.0301230329.7d66bbee_at_posting.google.com...
> Hi!
> I have ome strange occurences on Intermedia (8.1.6) on Solaris 7! I
> had no problems on my testing environment 8.1.6 & win2k!
>
> Table t_search with column body as a BLOB (can be Word, PDF, *.txt)
>
> <sqlplus>
> create index T_SEARCH_IDX on t_search ( body ) indextype is
> ctxsys.context
> parameters ('FILTER ctxsys.inso_filter LEXER german_lexer MEMORY
> 262144');
> COMMIT;
>
> Index created.
> </sqlplus>
>
> seemed ok!
>
> But any query-string returns nothing
>
> > SELECT SCORE(1) brabbit from t_search WHERE CONTAINS(body, 'der', 1) > 0;
>
> ->no rows returned!!!
>
> Occurence 1:
> ############
>
> >select * from ctx_user_index_errors;
>
> -> many entries in column ERR_TXT: "DRG-11207: user filter command
> exited with status 137"
>
> Occurence 2:
> ############
>
> -> I drop the index each time i run my pl/sql-script by putting this
> in front of all actions:
>
> <sqlplus>
> DROP INDEX T_SEARCH_IDX;
> </sqlplus>
>
> but DBMS_OUTPUT always complains:
>
> * ERROR at line 1: ORA-01418: specified index does not exist
>
> Curious, isn't it?
>
> Can somebody explain or help me out of this trouble?
>
> thx Stefan
Received on Thu Jan 23 2003 - 06:48:02 CST
