Sunday, January 9, 2011

SHUTDOWN IMMEDIATE HANGS AND GIVES ORA-600 [3708] ...

Database shutdown fails with the following:

Symptoms : ===>>>>

Errors in file /logisys/oracle/admin/xbt/bdump/xbt_lgwr_1560598.trc:
Thu Jun 19 20:16:25 2008
Errors in file /logisys/oracle/admin/xbt/udump/xbt_ora_1544374.trc:
ORA-00600: internal error code, arguments: [3708], [910], [], [], [], [], [], []
Thu Jun 19 20:16:26 2008
CLOSE: Error 600 during database close
Thu Jun 19 20:16:26 2008
SMON: enabling cache recovery
SMON: enabling tx recovery
Thu Jun 19 20:16:26 2008
ORA-600 signalled during: ALTER DATABASE CLOSE NORMAL...

Call stack from ORA-600 trace file:
kcttsc<- kcfcld <- dbsclose <- adbdrv <- opiexe
<- opiosq0 <- kpooprx <- kpoal8 <- opiodr <- ttcpip
<- opitsk <- opiino <- opiodr <- opidrv <- sou2o
<- opimai_real <- main

Call stack from LGWR file:
ksdxfdmp <- ksdxcb <- sspuser <- 000044BC <- skgpwwait
<- ksliwat <- kslwaitns <- kskthbwt <- kslwait <- kcrrwstp
<- kcrrsas <- kcrrxmp <- kcrrstpaa <- kctcls <- kcttha
<- ksbabs <- ksbrdp <- opirip <- opidrv <- sou2o
<- opimai_real <- main


***************************************************


Cause : ===>>>>>>>>>>>>>

This problem is due to

Bug 6512622 SHUTDOWN IMMEDIATE HANGS AND GIVES ORA-600 [3708]
Details:
SHUTDOWN IMMEDIATE may hang or signal ORA-600 [3708]



*****************

Solution : ===>>>


Please check the LGWR stack in the trace file to confirm the bug.

There is no workaround for this bug. To solve this problem:

1. Apply the 10.2.0.5 patchset where the bug is fixed.

OR

2. Apply one off Patch 6512622 if available on My Oracle Support for your platform and Oracle Version.
OR

3. Upgrade to 11.1.0.6 where the bug is fixed.

No comments:

Post a Comment