Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> InterMedia Indexing Problem

InterMedia Indexing Problem

From: Roman Schneider <schneider_at_ids-mannheim.de>
Date: Wed, 05 Jan 2000 14:36:56 +0100
Message-ID: <387348F8.C2015413@ids-mannheim.de>


Hi,

we are building web applications using Oracle 8i with interMedia and OAS 4.0.7 as application server under Windows NT 4 SP3. All went well until we tried to index text columns for full text retrieval. The following illustrates the problem:

create table tb_testtab (
  co_id number(5) not null primary key,   co_content varchar2(100));
insert into tb_testtab values ('1', 'hello world'); insert into tb_testtab values ('2', 'hello oracle');

So far, so good. But the command

create index testindex on tb_testtab(co_content) indextype is ctxsys.context;

produces the following error:

ERROR at line 1:

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-06512: at "CTXSYS.DRUE", line 122
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 34
ORA-06512: at line 1

Does anybody have an idea what is going wrong here? The Oracle instance is interMedia-enabled and the listener is running, but how can I check the ODCIIndexCreate routine?

Thanks for any suggestion
Roman

--

Roman Schneider            		Tel. +49-621-1581-203
Institut für deutsche Sprache		Fax. +49-621-1581-200 
R 5, 6-13    D-68161 Mannheim		E-mail: schneider_at_ids-mannheim.de
Received on Wed Jan 05 2000 - 07:36:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US