My Oracle Support Banner

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

Last updated on MARCH 03, 2019

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 <table_name>, Pro <table_name>, <table_name>, <table_name>
WHERE <table_name>.<column_name> = '5164'
  AND <table_name>.<column_name>= 'PRO'
  ...
  AND <table_name>.<column_name>= <table_name>.<column_name>
  AND catsearch (<table_name>.<column_name>, '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

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.