Re: create index error

From: Ton Raaijmakers <torgan_at_worldonline.nl>
Date: Tue, 25 Jan 2000 09:26:31 +0100
Message-ID: <388D5E37.DD9F4759@worldonline.nl>

Erik,

I had this problem just last week when installing intermedia/context 815. The problem is the listener.ora and the tnsnames.ora file. Oracle install does not
put all the right lines in those files. These lines were missing in tnsnames:
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) ( KEY = EXTPROC0 )) (CONNECT_DATA = (SID = PLSExtProc)) )

Ánd the protocols where in my case set to TCP, but external procedures can only work with IPC.

After these changes it worked.

Ton Raaijmakers

"Éric Dantie" wrote:

> When I'm trying to create an index, here is what I get:
>
> create index testindex on test(text)
> *
> 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
>
> Any idea ?
>
> Eric
Received on Tue Jan 25 2000 - 02:26:31 CST