My Oracle Support Banner

Query Fails With ORA-600 [ztsmdwl failed] When Accessing Encrypted Column (Doc ID 550229.1)

Last updated on FEBRUARY 04, 2020

Applies to:

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

Symptoms

1. ORA-600 [ztsmdwl failed] error occurs on SQL that accesses tables with encrypted columns.

2. The trace file shows a large failing select statement with many subselects. This error has also been seen when attempting to load data into a table with encrypted columns which also has complex columns (e.g. varrays) via SQL*Loader direct path mode.

Known Error stacks:

kzekmetc kzecctex evaopn2 evaopn2 qerhjSplitProbe qerhjInnerProbeHashTable kdstf1101101kmP  kdsttgr qertbFetch rwsfcd qerhjFetch qerflFetchOutside qeruaFetch qerghFetch opifch2 opifch . . .

 

or

ksedst ksedmp ksfdmp kgerinv kgeasnmierr BEEF260 kzekmetc BEEF260 FFFFFFFF kzecsqen kzecctex evaopn2
evaopn2 insLoadRow

or 

kzekmetc kzecsqen kzecctex evaopn2 evaopn2 insLoadRow ...



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.