OK, the scripts ran fine. However, it asked me for a ctxx_location when running dr0lib.sql. Is it asking me for a library? Does Intermedia have to be completely installed for me to be able to install the text part?
Here is an error message I got when I tried to create an index of indextype ctxsys.context on a CLOB column
"ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: interMedia Text error:
DRG-10700: preference does not exist: CTXSYS.DEFAULT_LEXER
ORA-06512: at "CTXSYS.DRUE", line 126
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 54
ORA-06512: at line 1"
If you did not, then you will need to re-create the library -
use the CREATE LIBRARY command
Also make sure that the path to the ctx library is included both in the PATH AND LD_LIBRARY_PATH variable. And if you are on HP change then extension from ".so" to ".sl" and add SHLIB_PATH to the list of env variables to be defined.
I did what you said. I checked if the libraries where there and that the path to the library was included in PATH and LD_LIBRARY_PATH.
I rerean the scripts.
Then I tried to create the ctxsys.context index on a CLOB and got this error message:
ERROR at line 1:
ORA-03113: end-of-file on communication channel
I am connected to sqlplus just fine. What's going on?
Again: does Intermedia have to be fully installed for text to work or is it sufficient to solely install text?