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
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
(
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
<- 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 |