Ora-07445 [Msqopnws()+6501] (Doc ID 1362643.1)

Last updated on MARCH 25, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.

Symptoms

ORA-07445: exception encountered: core dump [msqopnws()+6501]  is reported when running a complex query with binds:

E.g.:
SELECT
   m.id,
   m.NAME,
   m.funk_kennung,
   m.e3_bers_orgeinheit_id,
   s.e3_sta_status_id,
   s.zeitpunkt,
   x.distance_in_meter,
  (
    SELECT
      fms_status
    FROM
      e3_sta_status
    WHERE
      id = s.e3_sta_status_id
   ) fms_status
FROM
   e3_em_einsatzmittel m,
   e3_sta_globalstatus s,
   (
    SELECT /*+ordered*/
      g.id2,
      sdo_geom.Sdo_distance(g.geoloc, e.geoloc, .005, 'unit=METER')
      distance_in_meter
    FROM
      e3_gis_eort e,
      e3_gis_status g
   WHERE
      e.id2 = :B2
      AND Sdo_within_distance(g.geoloc, e.geoloc, :B1) = 'TRUE'
   ) x
WHERE
   m.id = s.e3_em_einsatzmittel_id
   AND s.id = x.id2
   AND EXISTS (
      SELECT
         e3_em_einsatzmittel_id
      FROM
         e3_em_typ_einsatzmittel
      WHERE
         e3_em_einsatzmittel_id = m.id
         AND e3_em_typ_id IN ( :B8, :B7, :B6, :B5,:B4, :B3 )
   )
ORDER BY
   x.distance_in_meter


The call stack is

msqopnws qximirew qxopqrp qxopqrl qxopqrl qxopqrl qxopqrl qxopqrl qxopqtqb xtyqbcb qctcpqb qctcpqbl xtydrv kkqcttcalo kkqctdrvIT apadrv opitca kksFullT ypeCheck rpiswu2 kksSetBindType kksfbc opiexe opipls opiodr rpidrus skgmstack rpiswu2 rpidrv psddr0 psdnal pevm_EXECC pfrinstr_EXECC pfrrun_no_tool pfrrun plsql_run peicnt kkxuexe kkxmpsexe kgmexwi kgmexec evapls evaopn2 qerocnFetch qerocFetch opifch2 kpoal8 opiodr ttcpip opitsk opiino opiodr opidrv sou2o opimai_real ssthrdmain main start

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