Home » Server Options » Text & interMedia » Context Error Message
Context Error Message [message #366422] Fri, 11 February 2000 21:24 Go to next message
fzhang
Messages: 1
Registered: February 2000
Junior Member
I was trying to build a context index on a column, but it gave some error messages:
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

What does this mean?
Re: Context Error Message [message #366441 is a reply to message #366422] Mon, 07 August 2000 07:49 Go to previous message
sharan alva
Messages: 57
Registered: November 1999
Member
Problem Description:
====================

After installing interMedia text and try to create a simple context index you
receive the following errors:

CREATE INDEX srch_idx ON property(search) INDEXTYPE IS CTXSYS.CONTEXT
*
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

You may also receive the following:

ORA-06522: ld.so.1: extprocPLSExtProc: fatal: libctxx8.so: open failed:
No such File or directory

On Windows NT you may also receive:

ORA-06522: ld.so.1: extprocPLSExtProc: fatal: oractxx8.dll: open failed:
No such File or directory

or

ORA-06522: Unable to load DLL


Problem Explanation:
====================

The Oracle interMedia text option depends on the listener external procedure
call feature. If you specify the incorrect path for library libctxx8.so during
install the external procedure call will be unable to locate the library and
display the above error message.

Solution Description:
=====================

You need to correct the path location of library "libctxx8.so" in dr$libx.

1. login to SQL*Plus as ctxsys:

sqlplus ctxsys/<password>

2. select * from user_libraries; (or svrmgrl> desc dr$libx)

Verify the path location for "libctxx8.so". If the location is correct and
the file has read permissions by all, then review Note 1017313.102 and
Note 73166.1 to see if this is your problem.

3. If path location for library libctxx8.so is incorrect:

create or replace library dr$libx as '<ORACLE_HOME>/ctx/lib/libctxx8.so'

Note: Make sure to enter complete path for <ORACLE_HOME>, do not use
environment variable $ORACLE_HOME

For NT:

create or replace library dr$libx as
'<drive letter:><ORACLE_HOME>\Bin\oractxx8.dll'

4. Recompile any invalid objects.

To determine if you have any invalid objects in the CTXSYS schema, use
the following select:

select object_name,object_type from dba_objects where
owner = 'CTXSYS' and status = 'INVALID';

You can recompile any invalid objects returned by this select by
doing the following while connected as SYS or SYSTEM:

exec dbms_utility.compile_schema('CTXSYS')


Solution Explanation:
=====================

During the original install the incorrect path for libctxx8.so was entered.
This usually occurs during manual interMedia text installation at step:
@dr0inst <ORACLE_HOME>/ctx/lib/libctxx8.so
Previous Topic: Problem in Context option
Next Topic: Oracle-Recovery
Goto Forum:
  


Current Time: Thu Mar 28 09:38:39 CDT 2024