Errors in Oracle 9i (9.0.2)

Oracle 9i (9.0.2) on RHE, getting an error when using the inso_filter and Oracle Text.
The error is "undefined symbol: stat"

Anybody know how to troubleshoot this ?
kIdBiLLiEAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
baonguyen1Connect With a Mentor Commented:
Look like you hit a bug and that will be fixed by applying Patch:2037255

WHEN USING INSO FILTER , UNDEFINED SYMBOL "STAT" IN LIBC_UT.SO

*** 10/07/01 11:02 pm ***
 1. Clear description of the problem encountered:
.
   Port: RedHat Linux 7.1  
   Product : Oracle rdbms 9.0.1
.
   When running inso filter indexing, or ctxhx directly from the command line  
we get:
.
    $ORACLE_HOME/ctx/bin/ctxhx: error while loading shared libraries:
    $ORACLE_HOME/ctx/lib/libsc_ut.so: undefined symbol: stat
.
 2. Pertinent configuration information (MTS/OPS/distributed/etc)
.
   NO MTS/OPS/dsitrbuted
.
 3. Indication of the frequency and predictability of the problem  
.
   This is reproducable everytime, as customer states.
.
   I could not reproduce the same problem using 8.1.7.2.0 on Redhat 6.2,
and using 9.0.1 on Sun Sparc Solaris, thus this problem looks port-specific.
.
 4. Sequence of events leading to the problem  
.
   create a table and index using inso filter:
    create table documents(id number(4) primary key,doc blob);
    create index doc_index on DOCUMENTS(DOC)
    indextype is ctxsys.context
    parameters ('datastore ctxsys.default_datastore filter  
ctxsys.inso_filter')
.
   or directly from the shell with :
.
    $ORACLE_HOME/ctx/bin/ctxhx test.rtf test.txt  
.
   Customer gets this error :.
.
    $ORACLE_HOME/ctx/bin/ctxhx: error while loading shared libraries:
    $ORACLE_HOME/ctx/lib/libsc_ut.so: undefined symbol: stat
.
  Relink of the product does not give any errors.
  Listener and rdbms is working fine; non-inso index can be built without a  
problem.
.
.
 5. Technical impact on the customer. Include persistent after effects.
   
   Customer is in the evaluation process of this product, and plan to develop  
a project if
   this product is tested successfully.
.
.
=========================    
DIAGNOSTIC ANALYSIS:
.  
.
=========================    
WORKAROUND:
No workarounds have been observed.
.
=========================    
RELATED BUGS:
None.
.
=========================    
REPRODUCIBILITY:
.
All the time  
.
=========================    
 
0
 
kIdBiLLiEAuthor Commented:
Can you provide me with where you found this resource?
0
 
kIdBiLLiEAuthor Commented:
And where can I find the patch?  I don't see it.
0
 
baonguyen1Commented:
You can find it from Metalink.  You need an account to access that Oracle web site
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.