My Oracle Support Banner

ORA-02056: 2PC: K2gCheckGlobalCommit: Bad Two-phase Command Number 1 From Coord (Doc ID 2498134.1)

Last updated on JANUARY 03, 2020

Applies to:

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

Symptoms

1)  Alert.log reports ORA-2056.


Error 2056 trapped in 2PC on transaction 94.10.25405700. Cleaning up.
Error stack returned to user:
ORA-02056: 2PC: k2gCheckGlobalCommit: bad two-phase command number 1 from coord

2)  Trace files has the following information.

PARSING IN CURSOR #140544860450776 len=6 dep=1 uid=61 oct=44 lid=61 tim=600182663999 hv=255718823 ad='0' sqlid='<SQL_ID>'
COMMIT

ORA-02056: 2PC: k2gCheckGlobalCommit: bad two-phase command number 1 from coord
----- Current SQL Statement for this session (sql_id=<SQL_ID>) -----
COMMIT
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0xec73edb78 84 package body <SCHEMA>.<PACKAGE>
0xec73edb78 444 package body <SCHEMA>.<PACKAGE>
0xec73edb78 406 package body <SCHEMA>.<PACKAGE>

skdstdst <- ksedst <- dbkedDefDump <- ksedmp <- dbkdaKsdActDriver
<- dbgdaExecuteAction <- dbgdaRunAction <- dbgdRunActions <- dbgdProcessEventAct <- ions
<- dbgdChkEventKgErr <- dbkdChkEventRdbmsEr <- ksfpec <- dbgePostErrorKGE <- 1143
<- dbkePostKGE_kgsf <- kgesev <- ksesec3 <- k2gCheckGlobalCommi <- ktdCommitMultinodeT
<- ransaction <- ktdcmt <- ransaction <- k2lcom <- k2send
<- xctCommitTxn <- kksExecuteCommand <- opiexe <- opipls <- opiodr
<- rpidrus <- skgmstack <- rpiswu2 <- rpidrv <- psddr0
<- psdnal <- pevm_EXECC <- pfrinstr_EXECC <- pfrrun_no_tool <- pfrrun
<- plsql_run <- peicnt <- kkxexe <- opiexe <- kpoal8
<- opiodr <- ttcpip <- opitsk <- opiino <- opiodr
<- opidrv <- sou2o <- opimai_real <- ssthrdmain <- main
<- libc_start_main <- start

 

 

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
Cause
Solution
References


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