OracleSearchParallelIndexOptimizer Fails With ORA-01692 Error (Doc ID 2040743.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Secure Enterprise Search - Version 11.2.2.2.0 and later
Information in this document applies to any platform.

Symptoms

On SES 11.2.2.2 SES in HA setup following the note.1611280.1, intermittently the below error occurs when the the index optimization runs to optimize the search index.

When the issue occurs, index optimization is run manually through the search admin GUI and it completes without any issue.


SESParallelIndexOptimizer Running, Request ID: 703 isResumed=false pausedState=null
tenantId: 1
SESParallelIndexOptimizer got unexpected exception ORA-20000: EQG-10000:en-US:
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drvddl.IndexOptimizeRebuild
ORA-01692: unable to extend lob segment SEARCHSYS.SYS_LOB0000096636C00006$$ partition SYS_LOB_P481 by 128 in tablespace SEARCH_INDEX
ORA-06512: at "SEARCHSYS.EQ_ERR", line 260
ORA-06512: at line

  at SESParallelIndexOptimizer.execute(SESParallelIndexOptimizer.java:190)
  at oracle.as.scheduler.rp.JavaSysExecWrapper$1.run(JavaSysExecWrapper.java:353)
  at java.security.AccessController.doPrivileged(Native Method)
  at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
  at oracle.security.jps.internal.jaas.AccActionExecutor.execute(AccActionExecutor.java:74)
  at oracle.security.jps.internal.jaas.CascadeActionExecutor$SubjectPrivilegedExceptionAction.run(CascadeActionExecutor.java:83)
  at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
  at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)
  at weblogic.security.Security.runAs(Security.java:61)


 

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