ORA-07445 [drplct()+1785] from CATSEARCH query (Doc ID 1671379.1)

Last updated on MAY 12, 2014

Applies to:

Oracle Text - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Error found in the alert.log:

Tue May 06 14:53:32 2014
Exception [type: SIGSEGV, Invalid permissions for mapped object] [ADDR:0x2AF90CB4D000] [PC:0x3FAAA23, drplct()+1785] [flags: 0x0, count: 1]
Errors in file /u01/app/11.2.0/diag/rdbms/prod_canejan/PROD/trace/PROD_ora_32563.trc (incident=1538809):
ORA-07445: exception encountered: core dump [drplct()+1785] [SIGSEGV] [ADDR:0x2AF90CB4D000] [PC:0x3FAAA23] [Invalid permissions for mapped object] []
Incident details in: /u01/app/11.2.0/diag/rdbms/prod_canejan/PROD/incident/incdir_1538809/PROD_ora_32563_i1538809.trc

The incident trace file shows the current sql is calling CATSEARCH:

SELECT * FROM
(
SELECT
(SELECT sig FROM
...
...
FROM Mev MevPro, Pro JPro, pro_rec, PRO_CMP
WHERE MevPro.Codsoc = '5164'
  AND MevPro.Codent = 'PRO'
  ...
  AND JPro.Codpro = PRO_REC.Codpro
  AND catsearch (PRO_REC.texte, 'le"livre de la jungle 2', ' ') > 0
  AND ROWNUM <= 200) QRSLT  
ORDER BY Datmar DESC


Stack trace is:

ssexhd <- sighandler <- drplct <- drplc <- pz5strt7
<- drpgcpparse <- drpmprs <- drpzparse <- drexqcprs <- drexrcstart

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