DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: How do I install the text part of intermedia?

  1. #1
    Join Date
    Aug 2001
    Posts
    15

    Angry

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




  2. #2
    Join Date
    Mar 2001
    Posts
    314
    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

  3. #3
    Join Date
    Aug 2001
    Posts
    15

    Smile

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

  4. #4
    Join Date
    Aug 2001
    Posts
    15
    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 ...

  5. #5
    Join Date
    Mar 2001
    Posts
    314
    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


  6. #6
    Join Date
    Aug 2001
    Posts
    15
    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 ... !

  7. #7
    Join Date
    Mar 2001
    Posts
    314
    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

  8. #8
    Join Date
    Aug 2001
    Posts
    15

    Talking

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width