Query on TDE Encrypted Tables Fails with Ora-00600 [Ztsmdwl Failed] (Doc ID 1118558.1)

Last updated on FEBRUARY 07, 2014

Applies to:

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

Symptoms

Querying tables with TDE enabled fails with errors like:

ORA-00600: internal error code, arguments: [ztsmdwl failed], [18446744073709551603], [], [], [], [], [], []

This happens consistently at every table access using the same statement.
The errorstack looks close to:

kzekmetc <- kzecsqen <- kzecctex <- evaopn2 <- evaopn2
<- qersoSORowP <- qerhjWalkHashBucket <- qerhjGenProbeHashTa <- ble <- kdstf0000101km
<- kdsttgr <- qertbFetch <- rwsfcd <- qerhjFetch <- qersoFetch
<- opifch2 <- kpoal8 <- opiodr <- ttcpip <- opitsk
<- opiino <- opiodr <- opidrv <- sou2o <- opimai_real
<- main <- libc_start_main <- start

Changes

The problem appears only for tables for which TDE is used.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms