ORA-07445 [mdorelNewBOp()+10218] When SVA=TRUE (Doc ID 2735107.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

On 19.8 when SVA=TRUE the ORA-07445: exception encountered: core dump [mdorelNewBOp()+10218] [SIGSEGV] [ADDR:0x1611315] [PC:0x63C116A] [Invalid permissions for mapped object] is reported bu this query:

DECLARE job BINARY_INTEGER := :job;  next_date TIMESTAMP WITH TIME ZONE := :mydate;  broken BOOLEAN := FALSE;  job_name VARCHAR2(128) := :job_name;  job_subname VARCHAR2(128) := :job_subname;  job_owner VARCHAR2(128) := :job_owner;  job_start TIMESTAMP WITH TIME ZONE := :job_start;  job_scheduled_start TIMESTAMP WITH TIME ZONE := :job_scheduled_start;  window_start TIMESTAMP WITH TIME ZONE := :window_start;  window_end TIMESTAMP WITH TIME ZONE := :window_end;  chain_id VARCHAR2(14) :=  :chainid;  credential_owner VARCHAR2(128) := :credown;  credential_name  VARCHAR2(128) := :crednam;  destination_owner VARCHAR2(128) := :destown;  destination_name VARCHAR2(128) := :destnam;  job_dest_id varchar2(14) := :jdestid;  log_id number := :log_id;  BEGIN  BEGIN
                                                   gis_objct_correct_pck.insert_small_conflicts_pr;
                                                   gis_objct_correct_pck.correct_job_pr(pix_script_seq => 0);
                                                END;  :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;

----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
0x17fa10f30      1894  package body MDSYS.SDO_3GL.GEOM_OPERATION_INT
0x17fa10f30      1978  package body MDSYS.SDO_3GL.GEOM_OPERATION1
0x17fa10f30      2152  package body MDSYS.SDO_3GL.GEOM_OPERATION
0x2beca2110      1816  package body MDSYS.SDO_GEOM.SDO_UNION
0x2beca2110      2055  package body MDSYS.SDO_GEOM.SDO_UNION
0x25deac8b0      2237  package body GIS.GIS_SPATIAL_OPER_PCK.CORRECT_SLIVER_PR
0x29e71a6f0       522  package body GIS.GIS_CORRECT_PARCELS_PCK.CORRECT_SLIVER_PR
0x29e71a6f0      2486  package body GIS.GIS_CORRECT_PARCELS_PCK.CORRECT_PARCEL_PR
0x259a099c0       499  package body GIS.GIS_OBJCT_CORRECT_PCK.CORRECT_JOB_PR
0x2dc844320         3  anonymous block

Changes

Cause

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