In 12.2.0.1, ORA-600 [kpdbSwitchPreRestore: Txn] Crash RAC Instances (Doc ID 2583951.1)

To BottomTo Bottom

In this Document

  Symptoms
  Cause
  Solution
  References

 

APPLIES TO: 

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

SYMPTOMS

Five of Six instances crashed due to error ORA-00600 [kpdbSwitchPreRestore:txn] on gen0 process at the same time.

ORA-00600: internal error code, arguments: [kpdbSwitchPreRestore: txn],[0xA9BFD3EA8], [0], [2687565824], [], [], [], [], [], [], [], []

 No Failing SQL Captured in the Incident Trace file.

Include the following call stacks:

ksedsts()+346<-kjzduptcctx()+868<-kjzdpcrshnfy()+380<-dbkedKstDump()+27<-dbgdaExecuteAction()+354<-dbgerRunAction()+108<-dbgerRunActions()+3719
<-dbgexPhaseII()+1688<-dbgexProcessError()+2531<-dbgePostErrorKGE()+1767<-dbkePostKGE_kgsf()+90<-kgeadse()+477<-kgerinv_internal()+49<-kgerinv()+40
<-kgeasnmierr()+150<-kpdbSwitchPreRestore()+424<-ksplfp()+6395<-ksbcti()+247<-ksbabs()+551<-ksbrdp()+1079

 

CAUSE

The issue was investigated in Bug 30186706 - IN 12.2.0.1, RAC INSTANCES CRASH AFTER ORA-600 [KPDBSWITCHPRERESTORE: TXN] ERROR.
 

SOLUTION

1.This issue will be fixed in DB Version 20.1.

2.Please apply patch 30186706, if It is available for your platform and DB version

3.As a Workaround, You can set "_drop_stat_segment" = 1 at SYSTEM Level on each Instance.

SQL> alter system set "_drop_stat_segment"=1 sid='instance sid'; ---->> [ avoid using sid='*' ]

 

 

REFERENCES