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...
>>> [EMAIL PROTECTED] 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.
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
