Post commit callback locks on scheduler job causing ORA-00603 and ORA-2063 source database end and ORA-00600 [KSS_TO_PRIVATE_SO], [SOC STATE] at target database end after upgrade to 19c (Doc ID 2795965.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

Source end  :

-----------------

ORA-00603: ORACLE server session terminated by fatal error
ORA-02063: preceding line from dblink.domain_name 
<PDB NAME>(3):opidrv aborting process J000 ospid (XXXXX) as a result of ORA-603

----- Current SQL Statement for this session (sql_id=8ggw94h7mvxd7) -----
COMMIT

Error: ORA-603 [ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [kss_to_private_so], [soc state], [0x1DEBEA830], [0x1EDDEF620], [0x1DEBEA830], [], [], [], [], [], [], []
] [] [] [] [] [] [] []
[00]: dbgexProcessError [diag_dde]
[01]: dbgePostErrorKGE [diag_dde]
[02]: dbkePostKGE_kgsf [rdbms_dde]
[03]: kgeade []
[04]: kgeselv []
[05]: ksesec1 [KSE]
[06]: npierr [NPI]<-- Signaling
[07]: npixfc [NPI]
[08]: k2rend [Two_Phase]
[09]: k2relf [Two_Phase]
[10]: k2send [Two_Phase]
[11]: xctctl []
[12]: xctCommitTxn []
[13]: kksExecuteCommand [cursor]
[14]: opiexe [Time_Limit]
[15]: opipls [OPI]
[16]: opiodr [OPI]
[17]: rpidrus [RPI]
[18]: skgmstack []
[19]: rpidru [RPI]
[20]: rpiswu2 [RPI]
[21]: rpidrv [RPI]
[22]: psddr0 [PROGINT_PLSQL]
[23]: psdnal [PROGINT_PLSQL]
[24]: pevm_EXECC [PLSQL_Code_Execution]
[25]: pfrinstr_EXECC [PLSQL_Code_Execution]
[26]: pfrrun_no_tool [PLSQL_Code_Execution]
[27]: pfrrun [PLSQL_Code_Execution]
[28]: plsql_run [PLSQL_PSD_Standalones]
[29]: peicnt [PLSQL_Code_Execution]
[30]: kkxexe [PROGINT_PLSQL]
[31]: opiexe [Time_Limit]
[32]: kpoal8 [PROGINT_MISC]
[33]: opiodr [OPI]
[34]: kpoodr [PROGINT_MISC]
[35]: upirtrc []
[36]: kpurcsc [PROGINT]
[37]: kpuexec [PROGINT]
[38]: OCIStmtExecute []
[39]: jslvec_execcb []
[40]: jslvswu []
[41]: jslvCDBSwitchUsr []
[42]: kpdbSwitch [PROGINT]
[43]: jslve_execute0 []
[44]: jslve_execute []
[45]: kpdbSwitch [PROGINT]
[46]: jslve_cdb_execute []
[47]: rpiswu2 [RPI]
[48]: kkjex1e_cdb []
[49]: kkjsexe []

Target end:

--------------

ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [kss_to_private_so], [soc state], [0x1DEBEA830], [0x1EDDEF620], [0x1DEBEA830], [], [], [], [], [], [], []

ksedst1 <- ksedst <- dbkedDefDump <- ksedmp <- dbgexPhaseII
       <- dbgexProcessError <- dbgePostErrorKGE <- 1853 <- dbkePostKGE_kgsf <- kgeade
        <- kgefecl <- k2send <- k2serv <- opiodr <- ttcpip
         <- opitsk <- opiino <- opiodr <- opidrv <- sou2o
          <- opimai_real <- ssthrdmain <- main <- libc_start_main <- start
           <- [TOC00004-END] <- [TOC00005]

Changes

Upgraded Database to 19c 

Cause

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