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

Last updated on APRIL 17, 2023

Applies to:

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

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.

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

	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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.