Scheduled Crawler Fails with EQG-30100 and ORA-4030 Errors (Doc ID 471753.1)

Last updated on FEBRUARY 27, 2017

Applies to:

Oracle Secure Enterprise Search - Version 10.1.8.0 to 10.1.8.4
Microsoft Windows (32-bit)
***Checked for relevance on 08-Jun-2013***

Symptoms

-- Problem Statement:
Customer has 7 crawlers running every hour, intermittently they get following errors:

EQG-30100: Internal error: java.sql.SQLException:
ORA-04030: out of process memory when trying to allocate 680032 bytes (joxp heap,u:CTX_SEG)
ORA-06512: at "EQSYS.EQ_ERR", line 10
ORA-06512: at "EQSYS.EQ_ERR", line 60
ORA-06512: at "EQSYS.EQ_ERR", line 171
ORA-06512: at line 1
ORA-04030: out of process memory when trying to allocate 93060 bytes (koh-kghu sessi,static frame of inst)
ORA-04030: out of process memory when trying to allocate 680032 bytes (joxp heap,u:CTX_SEG)
ORA-04030: out of process memory when trying to allocate 27984 bytes (pga heap, DR primary context)
ORA-06512: at "CTXSYS.DRUE", line 191
ORA-06512: at "CTXSYS.DRUE", line 49
ORA-06512: at "CTXSYS.DRUE", line 147
ORA-06512: at "CTXSYS.CTX_DDL", line 539
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "CTXSYS.DRVDDL", line 2608
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "CTXSYS.DRVDML", line 244
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "CTXSYS.DRVDISP", line 261
ORA-04030: out of process memory when trying to allocate 18016 bytes (drecinit,drecgchk:newpg)(joxp heap,u:CTX_SEG)
ORA-06512: at "EQSYS.EQ_ERR", line 10
ORA-06512: at "EQSYS.EQ_ERR", line 60
ORA-06512: at "EQSYS.EQ_ERR", line 171


and

EQG-30050: Could not connect to database: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTO =TCP)(HOST=swsesex5666)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ses.swsesex5666)))
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12500, TNS:listener failed to start a dedicated server process
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=swsesex5666)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=ses.swsesex5666)))


Problem does not occur when all 7 crawler scheduler did not start at the same time.

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