Re: Using the Oracle Intermedia feature ( Problem while creating an

From: Swajit Satam <swajit_at_mahindrabt.com>
Date: Tue, 06 Jun 2000 16:33:53 +0530
Message-Id: <10520.107828@fatcity.com>

hi ,

The Output of Lsnrctl start is

Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ursa_major)(PORT=1521)

STATUS of the LISTENER

---

Alias                     LISTENER
Version                 TNSLSNR for 32-bit Windows: Version 8.1.5.0.0 -
Production
Start Date              06-JUN-00 15:29:40
Uptime                  0 days 0 hr. 0 min. 2 sec
Trace Level           off
Security                OFF
SNMP                  OFF
Listener Parameter File   d:\orant\ora8i\network\admin\listener.ora
Listener Log File         d:\orant\ora8i\network\log\listener.log
Services Summary...
  PLSExtProc            has 1 service handler(s)

The command completed successfully

Thanks

Swajit

Andreas Jung wrote:

> On Mon, Jun 05, 2000 at 10:53:53PM -0800, Swajit Satam wrote:
> > Hi All,
> >
> > 1. ) I am having the following Table and I want to do a Intermedia
> > search on it
> >
> > SQL> desc multi_tab
> >
> > Name Null? Type
> > ------------------------------- -------- ----
> > IMG BINARY
> > FILE LOB
> > A NOT NULL NUMBER
> >
> > 2. ) the data present in the table
> >
> > SQL> select DBMS_LOB.GETLENGTH(IMG),a from multi_tab ;
> >
> > DBMS_LOB.GETLENGTH(IMG) A
> > ----------------------- ---------
> > 10 2
> > 18 3
> > 14 1
> >
> > 3. ) For Search I executed the following Query
> >
> > SELECT SCORE(1) title from multi_tab
> > WHERE CONTAINS(IMG, 'oracle', 1) > 0;
> >
> > 4. ) I get the following Error
> >
> > ERROR at line 1:
> > ORA-20000: ConText error:
> > DRG-10599: column is not indexed
> >
> > So I gave a Create Index Syntax
> > It gives a following error
> >
> > create index testindex on multi_tab(IMG) indextype is ctxsys.context
> > *
> > 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
> >
> > I have Also Configuring Net8 for External Procedures
> > by editing the LISTENER.ORA and TNSNAMES.ORA accordingly
> > but still it gives the same error

>

> What is the "lnsrctl start" output ? Is the extproc service
> running ?

>

> Andreas

>

> --
> Author: Andreas Jung
> INET: ajung_at_sz-sb.de

>


> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing Lists

> --------------------------------------------------------------------

> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Tue Jun 06 2000 - 06:03:53 CDT