My Oracle Support Banner

SDO_NN generates ORA-7445: [kghufree] (Doc ID 1362406.1)

Last updated on DECEMBER 22, 2018

Applies to:

Oracle Spatial and Graph - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

Use of SDO_NN generates internal error

SELECT *
FROM
(
SELECT ID, SDO_NN_DISTANCE(1) distance
FROM LOCATION loc
WHERE SDO_NN(loc.LOCATION,
MDSYS.SDO_GEOMETRY(2001,8307,MDSYS.SDO_POINT_TYPE(-110,32,null),null,null), 'SDO_NUM_RES=30 unit=M distance=1.5239999976835199E7 SDO_MAX_MEMORY=50000000',1) = 'TRUE'
ORDER BY 2
)
WHERE ROWNUM < 30;


====== Error Message ======
ORA-07445: exception encountered: core dump [kghufree()+1076] [SIGSEGV] [ADDR:0xBFEC0FBA8826AA96] [PC:0x1010E9054] [Address not mapped to object] []
ORA-29400: data cartridge error
ORA-21779: duration not active
ORA-29902: error in executing ODCIIndexStart

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


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