OracleTextSearch – fix limit of 2048 results

I’ve seen the following error pop up a lot while searching within WebCenter Content.

This is a very generic error. To better troubleshoot, we can turn on search* and systemdatabase tracing which reveals the following:

OracleTextSearch previously had a limit of 2048 results. This is a database issue and thus requires a database patch. To fix this issue, download and apply patch 12582138. Note that Oracle Database 11.2.0.4 or higher has the patch included.

See these Oracle Support notes for more information:

Leave a Reply

Be the First to Comment!

Notify of
avatar
wpDiscuz