RE: problems creating a context index

From: DiFelice, Sebastian <sebastian.difelice_at_tfn.com>
Date: Fri, 13 Sep 2002 09:08:30 -0800
Message-ID: <F001.004CF9C8.20020913090830@fatcity.com>

thanks for the info. PLSExtProc is up and I can tnsping it with no problem. I found out that somehow the UNIX oracle user profile had been altered and all the oracle LD_LIBRARIES where deleted. Go figure! I need to have a talk to my UNIX Admin!!!!!

Thanks again,

Sebastian

-----Original Message-----
Sent: Thursday, September 12, 2002 3:44 PM To: Multiple recipients of list ORACLE-L

Make sure you're LISTENER and tnsnames.ora have "PLSExtProc" set-up.

I have a separate listener for PLSExtProc:

listener.ora ****

LISTENER_PLS =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )

)
)

SID_LIST_LISTENER_PLS =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /DEV_ORACLE/bin/app/oracle817/product/8.1.7)
(PROGRAM = extproc)

    )
  )

tnsnames.ora ****

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)

    )
  )

...JIM... >>> sebastian.difelice_at_tfn.com 9/12/02 9:33:23 AM >>> Hello All;

I am being plagued with an error I can't get my hands around when I try to
recreate a context index. The index existed previously, but when I tried to
sync new data I got an error, then I attempted rebuilding the index from
scratch and got the same error (see below). I checked the $ORACLE_HOME/lib
directory and found the library that the error indicates as missing.

Any help would be greatly appreciated!

sql statements executed:

call Ctx_Ddl.Drop_stoplist ('my_stoplist') /
call Ctx_Ddl.create_stoplist('my_stoplist') /
drop index TFNR_DISPLAY_NAME_IDX_C
/
create index TFNR_DISPLAY_NAME_IDX_C on TFNR (Display_Name)

indextype is ctxsys.context
parameters ('stoplist my_stoplist')
/

error returned:

Call completed.

drop index TFNR_DISPLAY_NAME_IDX_C

*
ERROR at line 1:
ORA-01418: specified index does not exist

create index TFNR_DISPLAY_NAME_IDX_C on TFNR (Display_Name) *
ERROR at line 1:

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: ConText error:
ORA-06520: PL/SQL: Error loading external library
ORA-06522: ld.so.1: extprocPLSExtProc: fatal: libskgxp8.so: open

failed: No
such file or directory

ORA-06512: at "CTXSYS.DRUE", line 122
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 34
ORA-06512: at line 1

Sebastian DiFelice
DBA/Database Analyst
Thomson
Intelligence Data
(617)856-1587
www.intelligencedata.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: DiFelice, Sebastian
  INET: sebastian.difelice_at_tfn.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
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: James Howerton
  INET: jhowerton_at_uabmc.edu

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
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DiFelice, Sebastian
  INET: sebastian.difelice_at_tfn.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
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Sep 13 2002 - 12:08:30 CDT