I am fairly new to Oracle. I need to install the text part of Oracle Intermedia on a SUN Orcale 8.1.6 server, so that I can create indexes of type ctxsys.context.
Intermedia is not installed at all at this time.
I found loads of docs on Intermedia audio, movies, etc, just not on Intermedia text.
Can someone help me??
run the following files:
Read both the files before running them for instructions on how to run them.
Thank you! I will try this and let you know how it went.
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"
Thanks in advance ...
You need to specify the location of the library when you run the dr0inst script (and specify the full path name) e.g.
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.
Ok, now it is getting twilight-zony.
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?
Thanks ... !
As to your question, no Intermedia does not have to be fully installed for Intermedia Text to work.
As for your problem, take a look at metalink - you should be able to find a solution there.
Just an afterthought, did you run dr0drop before you re-ran your scripts ?
Sorry! I just got back from vacation. The whole thing was delayed by our customer until further notice. I am going to try this again. Thanks for the tip on meta link.
Click Here to Expand Forum to Full Width