Oracle Database - Enterprise Edition - Version 11.2.0.4 to 12.1.0.2 [Release 11.2 to 12.1]
The following errors might be seen in the alert.log files of the databases that were patched with the April PSU/SPU/DBBP:
1) ORA-07445: exception encountered: core dump [audplsfailure()+54]
Error: ORA-07445 [audplsfailure()+54] [SIGSEGV] [ADDR:0x428] [PC:0x1ED6598] [Address not mapped to object]
Error Stack: ORA-7445[audplsfailure]/ORA-911
Main Stack:
audplsfailure <- audfro <- audcvw <- auddft_internal <- auddft <- kksQuickParse
<- kksLoadParentOnLock <- kkslod <- kglLoadOnLock <- kgllkac <- kglLock <- kglget <- kkspsc0
<- kksParseCursor <- opiosq0 <- kpooprx <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino
<- opiodr <- opidrv <- sou2o <- opimai_real <- ssthrdmain <- main
Error Stack: ORA-7445[audplsfailure]/ORA-911
Main Stack:
audplsfailure <- audfro <- audcvw <- auddft_internal <- auddft <- kksQuickParse
<- kksLoadParentOnLock <- kkslod <- kglLoadOnLock <- kgllkac <- kglLock <- kglget <- kkspsc0
<- kksParseCursor <- opiosq0 <- kpooprx <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino
<- opiodr <- opidrv <- sou2o <- opimai_real <- ssthrdmain <- main
2) ORA-07445: exception encountered: core dump [audfro()+1051]
ORA-07445: exception encountered: core dump [audfro()+1051]
Main Stack:
audfro <- audcvw <- auddft_internal <- kksQuickParse <- kksLoadParentOnLock
<- kglLoadOnLock <- kgllkac <- kglLock <- kglget <- kkspsc0 <- kksParseCursor <- opiosq0
<- kpooprx <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o
<- opimai_real <- ssthrdmain <- main
Main Stack:
audfro <- audcvw <- auddft_internal <- kksQuickParse <- kksLoadParentOnLock
<- kglLoadOnLock <- kgllkac <- kglLock <- kglget <- kkspsc0 <- kksParseCursor <- opiosq0
<- kpooprx <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o
<- opimai_real <- ssthrdmain <- main
3) ORA-00600 [kzaSqlTxtLob:sqlt]
ORA-00600: internal error code, arguments: [kzaSqlTxtLob:sqlt]
Main Stack:
kzaSqlTxtLob <- audins <- audexc <- auddft_internal <- auditKglInvalidPls <- audikg
<- kglAuditInvalidPls <- qcsRslvName <- qcsridn <- qcsraic <- qcspqbDescendents <- qcspqb
<- qcsdrv <- qcitrans <- qcisem <- ph2csql_analyze <- ph2stm <- ph2sms <- ph2blo <- ph2obl
<- ph2sbo <- ph2qcb <- ph2dcl <- ph2itm <- ph2its <- ph2blo <- ph2obl <- ph2sbo <- ph2itm <- ph2its
<- ph2blo <- ph2stm <- ph2uni <- ph2dr2 <- ph2drv <- phpsem <- phpcmp <- pcisem2 <- kkxsem <- opitca
<- kksFullTypeCheck
Main Stack:
kzaSqlTxtLob <- audins <- audexc <- auddft_internal <- auditKglInvalidPls <- audikg
<- kglAuditInvalidPls <- qcsRslvName <- qcsridn <- qcsraic <- qcspqbDescendents <- qcspqb
<- qcsdrv <- qcitrans <- qcisem <- ph2csql_analyze <- ph2stm <- ph2sms <- ph2blo <- ph2obl
<- ph2sbo <- ph2qcb <- ph2dcl <- ph2itm <- ph2its <- ph2blo <- ph2obl <- ph2sbo <- ph2itm <- ph2its
<- ph2blo <- ph2stm <- ph2uni <- ph2dr2 <- ph2drv <- phpsem <- phpcmp <- pcisem2 <- kkxsem <- opitca
<- kksFullTypeCheck
cause :
The errors can be seen on any of the database versions for which we have released a bundle patch ( PSU / SPU / DBDP) in April: Oracle RDBMS 11.2.0.4, Oracle RDBMS 12.1.0.1, Oracle RDBMS 12.1.0.2.
ug 24316947 - ORA 7445 AND ORA 600 AFTER APPLYING 11204/12101/12102 APR DBPSU/DBBP
The following bugs have been closed as duplicates of Bug 24316947:
workaround :
A workaround is to disable NOT EXISTS auditing - run "NOAUDIT NOT EXISTS". AUDIT NOT EXISTS audits all SQL statements that fail because an object doesn’t exist.
This bug 24316947 fix is included in Database Patch Set Update 2016 patch.
For a permanent solution, apply Patch 24316947 or Database Patch Set Update 2016 patch.
No comments:
Post a Comment