ORA-07445 kkogbro Exception Encountered From Complex Text Query

(Doc ID 740752.1)

Last updated on SEPTEMBER 18, 2012

Applies to:

Oracle Text - Version to [Release 11.1]
Information in this document applies to any platform.
Checked for Relevance on 19-Sep-2012


When running complex Text query on Standard Edition (SE), for example:

select distinct t.ojNumber, t.country, t.regioncode from td30.ted_hold t
where t.doctype not in ('7', '2', '1', 'R') AND (t.country='UK' or t.country='IE')
contains(searchtext, '(benefit% |revenue% | council tax | housing allowance) & (comput% | software | system%)') > 0;

user gets disconnected with ORA-03113: end-of-file on communication channel and

ORA-03114: Not connected to Oracle

The alert log shows the following error:

Mon Feb 18 10:13:31 2008
Exception [type: ACCESS_VIOLATION, UNABLE_TO_READ] [ADDR:0x196] [PC:0x496427A,
Errors in file d:\oracle\diag\rdbms\millprod\millprod2\trace\millprod2_ora_4616.trc
ORA-07445: exception encountered: core dump [_VInfreq__kkogbro()+794] [ACCESS_VIOLATION]
[ADDR:0x196] [PC:0x496427A] [UNABLE_TO_READ] []
Incident details in:
Mon Feb 18 10:13:32 2008
Trace dumping is performing id=[cdmp_20080218101332]
Mon Feb 18 10:13:34 2008
Sweep Incident[11426]: completed


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