ORA-07445 [ctcdhp_drop_hidden_partition()+3725] From SYS.CLEANUP_ONLINE_PMO
(Doc ID 3072987.1)
Last updated on FEBRUARY 25, 2025
Applies to:
Oracle Database - Enterprise Edition - Version 19.25.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
Getting frequent error "ORA-07445 [ctcdhp_drop_hidden_partition()] [Address not mapped to object]" in the alert log.
----- Current SQL Statement for this session (sql_id=39quyum9057mk) -----
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 declare
myinterval number;
begin
myinterval := dbms_pdb.cleanup_task(6);
if myinterval <> 0 then
next_date := systimestamp +
numtodsinterval(myinterval, 'second');
end if;
end; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
[TOC00005]
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x39f9b51778 85 package body SYS.DBMS_PDB.CLEANUP_TASK
0x4526961a08 4 anonymous block
Trying to run the procedure on the table mentioned in the trace file:
Fails with:
ORA-07445 [ctcdhp_drop_hidden_partition()+3725] [SIGSEGV] [ADDR:0x148] [PC:0x27A77ED] [Address not mapped to object]
Main Stack:
ctcdhp_drop_hidden_partition <- ctccfo_clean_failed_op
<- ctccop_cleanup_online_op <- ctccom_cleanup_online_move <- spefcmpa
<- spefmccallstd <- peftrusted <- psdexsp <- kxe_push_env_internal_pp_
<- kkx_push_env_for_ICD_for_new_session <- psdextp <- pefccal <- pefcal <- pevm_FCAL
<- pfrinstr_FCAL <- pfrrun_no_tool <- pfrrun <- plsql_run <- peicnt <- kkxexe <- opiexe
<- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o <- opimai_real
<- ssthrdmain <- main
Changes
N/A
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 |