My Oracle Support Banner

After Enabling DATABASE FULLTEXT and Rebuilding the Collection, an Error is Received (Doc ID 888617.1)

Last updated on AUGUST 07, 2024

Applies to:

Oracle WebCenter Content - Version 10.0 and later
Information in this document applies to any platform.

Symptoms

-- Problem Statement:
On a new installation of Content Server 10.1.3.3.3, after enabling DATABASE.FULLTEXT search and
rebuilding the index, the rebuild fails with the following error:

ERROR:
Indexing aborted at 9/8/09 11:46 am. Unable to delete collection directories. Indexer could not
create table or index: IdcColl2. Unable to execute callable query 'CaddTextPreference'.
ORA-06550: line 1, column 7:
PLS-00201: indexer 'CTX_DLL' must be delcared
ORA_06550: line 1, column 7:
PL/SQL: statement ignored

-- Steps To Reproduce:
1. Set SearchIndexerEngineName=DATABASE.FULLTEXT
2. ran batchsnippet.sql script as JDBC user
3. Rebuilt Search index


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References

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