ORA-04021: timeout occurred while waiting to lock object导致数据库宕机
数据库错误日志
Mon Dec 22 13:18:44 2025 Media Recovery Waiting for thread 1 sequence 49295 (in transit) Recovery of Online Redo Log: Thread 1 Group 4 Seq 49295 Reading mem 0 Mem# 0: /u01/app/oracle/oradata/testdb/SBREDO04.LOG Archived Log entry 49298 added for thread 1 sequence 49294 ID 0x860b01b0 dest 1: Mon Dec 22 13:18:55 2025 Errors in file /u01/app/oracle/diag/rdbms/testdb/testdb/trace/testdb_lgwr_29579.trc: ORA-04021: timeout occurred while waiting to lock object LGWR (ospid: 29579): terminating the instance due to error 4021 Mon Dec 22 13:18:55 2025 MRP0: Background Media Recovery terminated with error 449 Errors in file /u01/app/oracle/diag/rdbms/testdb/testdb/trace/testdb_pr00_18376.trc: ORA-00449: background process 'LGWR' unexpectedly terminated with error 4021 Managed Standby Recovery not using Real Time Apply Mon Dec 22 13:18:56 2025 System state dump requested by (instance=1, osid=29579 (LGWR)), summary=[abnormal instance termination]. System State dumped to trace file /u01/app/oracle/diag/rdbms/testdb/testdb/trace/testdb_diag_29569_20251222131856.trc Dumping diagnostic data in directory=[cdmp_20251222131856], requested by (instance=1, osid=29579 (LGWR)), summary=[abnormal instance termination]. Instance terminated by LGWR, pid = 29579 >>>>>>>>>>>>>> cat /u01/app/oracle/diag/rdbms/testdb/testdb/trace/testdb_lgwr_29579.trc error 4021 detected in background process ORA-04021: timeout occurred while waiting to lock object kjzduptcctx: Notifying DIAG for crash event ----- Abridged Call Stack Trace ----- ksedsts()+465<-kjzdssdmp()+267<-kjzduptcctx()+232<-kjzdicrshnfy()+63<-ksuitm()+5570<-ksbrdp()+3507<-opirip()+623<-opidrv()+603<-sou2o()+103<-opimai_real()+250<-ssthrdmain()+265<-main()+2 01<-__libc_start_main()+245 ----- End of Abridged Call Stack Trace ----- *** 2025-12-22 13:18:55.458 LGWR (ospid: 29579): terminating the instance due to error 4021 ksuitm: waiting up to [5] seconds before killing DIAG(29569) >>>>>>>>>>>>>> vi /u01/app/oracle/diag/rdbms/testdb/testdb/trace/testdb_pr00_18376.trc *** 2025-12-22 13:18:55.465 *** 2025-12-22 13:18:55.465 4329 krsh.c MRP0: Background Media Recovery terminated with error 449 ORA-00449: background process 'LGWR' unexpectedly terminated with error 4021 *** 2025-12-22 13:18:55.467 4329 krsh.c Managed Standby Recovery not using Real Time Apply
