My Oracle Support Banner

FAQ for OracleTextSearch (OTS), Troubleshooting and Information (Doc ID 781895.1)

Last updated on MARCH 05, 2024

Applies to:

Oracle WebCenter Content - Version 10.0 to 11.1.1.8.0 [Release 10gR3 to 11g]
Information in this document applies to any platform.
 
This document applies to any 10gR3 Content Server.




Purpose

This document will cover most aspects of using the OracleTextSearch Component

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Questions and Answers
 FAQ:
 Can Oracle Text Search be used on 10g and 11g Content Servers?
 
 Where is the OracleTextSearch component located?
 Is an 11g Database Required?
 If the OracleTextSearch component is enabled is the Content Server using OTS?
 If the OracleTextSearch component is enabled, but not being used, does it cause any issues?
 Will the OracleTextSearch work in the database’s System Tablespace?
 Why do some text files index correctly and others don’t?
 What do the Config entries do:
 Why Optimize Fields?
 What is the Fast Rebuild Option?
 Troubleshooting
 To find out exactly what is being indexed from a document, turn on logging inside of the Repository Manager:
 To find out the query that is being sent to the Database:
 To see the query that is being sent to the database for a search when using one database is used for the Content Server and a different database is used for the search collection:
 Common Errors and Solutions:
 Indexing aborted error
 Content Server Request Failed error
 Error Rebuilding the index:
 Error when switching to the OracleText search component, then adding new content
 Cannot extend DrillDownFields
 Using Collaboration Manager Security without Collab being installed.
 ACL Security issue
 Using "NOT CONTAINS" search option produces error
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.