Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Using the Oracle Intermedia feature ( Problem while creating an
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) )
LOG_DIRECTORY_EXTPROC_LISTENER = $ORACLE_HOME/network/log LOG_FILE_EXTPROC_LISTENER = extproc_listener.log SID_LIST_EXTPROC_LISTENER =
(SID_NAME = extproc_agent) (ORACLE_HOME=$ORACLE_HOME) (PROGRAM = extproc)
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
(c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.
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]
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,
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 externalprocedures
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-LReceived on Tue Jun 06 2000 - 14:11:47 CDT
![]() |
![]() |