Re: interMedia Text setup problems

Tim - comments inline. I've trimmed the follow ups.

Tim Frith wrote:
>
> I'm using Oracle 8i on Windows NT. I want to be able to do full-text
> searches on the contents of documents whose URL is saved in one of my
> tables. I can't seem to get any results after setting up interMedia Text and
> creating my index.
>
> Here's the SQL I used to create the index:
>
> CREATE INDEX documentIndex ON FormattedDocument(location)
> INDEXTYPE IS ctxsys.context
> PARAMETERS('
> datastore ctxsys.URL_DATASTORE
> filter ctxsys.INSO_FILTER');

Tim - you need to check that the CREATE INDEX correctly indexed you documents.

Use a query on ctx_user_index_errors to see if there are any errors

I'm guessing that you are getting errors of the form

cannot find file \drgit3

To fix this, you will need to set a SYSTEM environment variable on NT as follows

ORACLE_HOME = x:\ORACLE\ORA81

and restart the database. The problem is that the database cannot find the INSO filters. Make sure you are setting as a SYSTEm variable, and not a USER variable.

Also - I'm assuming that you are using URL's to identify the documents that you want indexed ? Do the URL's work on your NT box from a browser, etc ?

>
> Here's a sample query that should return a few records:
> SQL> SELECT documentId, SCORE(1) score from formatteddocument
> 2 WHERE CONTAINS(location, 'bylaw', 1) > 0;
>
> no rows selected
>
> Execution Plan
> ----------------------------------------------------------
> 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=1.1 Card=1 Bytes=100
> )
>
> 1 0 TABLE ACCESS (BY INDEX ROWID) OF 'FORMATTEDDOCUMENT' (Cost
> =1.1 Card=1 Bytes=100)
>
> 2 1 DOMAIN INDEX OF 'DOCUMENTINDEX' (Cost=1)
>
> Statistics
> ----------------------------------------------------------
> 299 recursive calls
> 15 db block gets
> 99 consistent gets
> 0 physical reads
> 0 redo size
> 2434 bytes sent via SQL*Net to client
> 2364 bytes received via SQL*Net from client
> 13 SQL*Net roundtrips to/from client
> 5 sorts (memory)
> 0 sorts (disk)
> 0 rows processed

It's using the index correctly - it's just that there is nothing in the index.  

> Here are portions of my sqlnet.ora, tnsnames.ora, listener.ora:
>
> sqlnet.ora:
> ----------------------------------------------------------
> SQLNET.EXPIRE_TIME = 0
>
> AUTOMATIC_IPC = ON
>
> tnsnames.ora:
> ----------------------------------------------------------
> EXTPROC_CONNECTION_DATA =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (CONNECT_DATA =
> (SID = PLSExtProc)
> (PRESENTATION = RO)
> )
> )
>
> listener.ora:
> ----------------------------------------------------------
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> )
> (DESCRIPTION =
> (PROTOCOL_STACK =
> (PRESENTATION = GIOP)
> (SESSION = RAW)
> )
> (ADDRESS = (PROTOCOL = TCP)(HOST = myhost)(PORT = 2481))
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = D:\Oracle\OraHome)
> (PROGRAM = extproc)
> )
> )

Looks fine  

> ----------------------------------------------------------
> Here is my test of External Procedure support:
> D:\Oracle\OraHome\BIN>tnsping EXTPROC_CONNECTION_DATA
>
> TNS Ping Utility for 32-bit Windows: Version 8.1.5.0.0 -
> Production on 13-JAN-00 14:41:14
>
> (c) Copyright 1997 Oracle Corporation. All rights reserved.
>
> Attempting to contact (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))
> OK (40 msec)

Good - it's the index problem I mentioned at the beginning  

> Any help would be appreciated.
>
> Tim

--
Regards,

Mark Townsend                         

Senior Product Manager				Ph: 	(650) 633 5764
Server Division					Fx: 	(650) 506 7222
Oracle Corporation				Email:	mtownsen_at_us.oracle.com