How do I install the text part of intermedia?

[sstock]

Hi everyone.

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??
PLEASE!!!

[amar]

run the following files:

$OH/ctx/admin/dr0csys.sql, and
$OH/ctx/admin/dr0inst.sql


Read both the files before running them for instructions on how to run them.

Good Luck!

-amar

[sstock]

Thank you! I will try this and let you know how it went.

[sstock]

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 ...

[amar]

You need to specify the location of the library when you run the dr0inst script (and specify the full path name) e.g.

SQL>@dr0inst /u00/app/oracle/product/8.1.7/ctx/lib/libctxx8.so

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.

-amar

[sstock]

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 ... !

[amar]

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 ?

-amar

[sstock]

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.