911: help with InterMedia Text indexing

From: pc <goldenwater8_at_hotmail.com>
Date: 2000/07/14
Message-ID: <udCeV$T7$GA.281_at_cpmsnbbsa07>#1/1


got this error when creating intermedia text index, any idea?

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: ConText error:
DRG-50704: Net8 listener is not running or cannot start external procedures
ORA-28575: unable to open RPC connection to external procedure agent
ORA-12154: TNS:could not resolve service name
ORA-06512: at "CTXSYS.DRUE", line 122
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 34
ORA-06512: at line 1

here is what i did:

  • fresh install windows 2000
  • installed oracle 8.1.5 for windows nt
  • created database with limitless auto-extent. created table:

create table user_info (userid varchar2(10) primary key, info_about varchar2(470));

  • imported 1M records using sqlldr

create index using:
create index myindex on user_info(info_about) indextype is ctxsys.context;

then got the above error.

tks!
peter Received on Fri Jul 14 2000 - 00:00:00 CEST

Original text of this message