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

From: MacGregor, Ian A. <ian_at_SLAC.Stanford.EDU>
Date: Tue, 06 Jun 2000 12:11:47 -0700
Message-Id: <10520.107947@fatcity.com>

We run a seaprate listener for external procedures. Here is the stanza from the
listener.ora file. In the file the value for $ORACLE_HOME is hard coded in the file instead of the variable $ORACLE_HOME being used.

EXTPROC_LISTENER =
(ADDRESS_LIST =

        (ADDRESS=
          (PROTOCOL=IPC)
          (KEY= extproc_key)
        )

)
STARTUP_WAIT_TIME_EXTPROC_LISTENER = 0
CONNECT_TIMEOUT_EXTPROC_LISTENER = 30

LOG_DIRECTORY_EXTPROC_LISTENER = $ORACLE_HOME/network/log
LOG_FILE_EXTPROC_LISTENER = extproc_listener.log
SID_LIST_EXTPROC_LISTENER =

(SID_LIST =

(SID_DESC =

      (SID_NAME = extproc_agent)
      (ORACLE_HOME=$ORACLE_HOME)
      (PROGRAM = extproc)

)
)
TRACE_LEVEL_EXTPROC_LISTENER = OFF Here is the stanza from the tnsnames.ora file.

extproc_connection_data =
(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = extproc_key)) (CONNECT_DATA = (SID = extproc_agent)) )

oracle_at_bbr-oracle $ lsnrctl stat extproc_listener

LSNRCTL for Solaris: Version 8.1.6.0.0 - Production on 06-JUN-2000 12:05:09

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=extproc_key)) STATUS of the LISTENER

Alias                     extproc_listener
Version                   TNSLSNR for Solaris: Version 8.1.6.0.0 -
Production
Start Date                28-FEB-2000 16:44:31
Uptime                    98 days 18 hr. 20 min. 38 sec

[some stuff deleted]
Services Summary...
extproc_agent has 1 service handler(s) The command completed successfully

I highly recommend building the example external procedure in the $ORACLE_HOME/plsql/demo
directory. The directions for doing so can be found in the extproc.sql file.

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac.stanford.edu

-----Original Message-----
From: Swajit Satam [mailto:swajit_at_MAHINDRABT.COM] Sent: Monday, June 05, 2000 11:54 PM
To: Multiple recipients of list ORACLE-L Subject: Using the Oracle Intermedia feature ( Problem while creating an Index )

Hi All,

) 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

So Gurus what can be the possible Cause

TIA
Reg
Swajit

-- 
Author: Swajit Satam
  INET: swajit_at_mahindrabt.com

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

Received on Tue Jun 06 2000 - 14:11:47 CDT