Index Rebuild Failure due to errors ORA-29855, ORA-20000, DRG-10700 and ORA-06512 (Doc ID 2184887.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

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

Symptoms

ISSUE
-----------------------
When trying to run the Collection Rebuild cycle from the Repository Manager applet, following error is displayed:

Indexing aborted. Unable to create Oracle text collection 'IdcText2'. Encountered an exception while executing a query. [ Details ]

An error has occurred. The stack trace below shows more information.


ERROR
-----------------------
!csIndexerAbortedMsg!csIndexerOracleTextCanNotCreateTableOrIndex,IdcText2!csJdbcGenericError
intradoc.common.ServiceException: !csIndexerOracleTextCanNotCreateTableOrIndex,IdcText2!csJdbcGenericError
  at intradoc.indexer.OracleTextCollectionHandler.createCollection(OracleTextCollectionHandler.java:1263)
  at intradoc.indexer.OracleTextCollectionHandler.manageCollection(OracleTextCollectionHandler.java:275)
  at intradoc.indexer.IndexerCollectionManager.doWork(IndexerCollectionManager.java:102)
and more ...

STEPS TO REPLICATE
-----------------------
1. Go to Administration / Admin Applets / Repository Manager
2. Try to run collection Rebuild cycle
3. Above error is noted.

BUSINESS IMPACT
-----------------------
Unable to run the collection Rebuild cycle

Changes

Last known change was database upgrade to 12c from 11g.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms