My Oracle Support Banner

Queries Using Temporary Data Fail With "ORA-28374: typed master key not found in wallet" (Doc ID 2522407.1)

Last updated on SEPTEMBER 14, 2021

Applies to:

Advanced Networking Option - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Queries that involve sorting, or otherwise using temporary data, fail with:

ORA-28374: typed master key not found in wallet

In contrast, other queries on the same objects do not encounter this error.

Changes

TDE has been implemented, and encrypted tablespaces have been created.  

The database may have been created via cloning using RMAN DUPLICATE (or restored/copied from another clone database).

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
Changes
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.