Ora-28374: Typed Master Key Not Found In Wallet

(Doc ID 757936.1)

Last updated on NOVEMBER 01, 2017

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.1]
Information in this document applies to any platform.


You are trying to create an encrypted tablespace and you get the following error:

ERROR at line 1:
ORA-28374: typed master key not found in wallet



- A previously encrypted tablespace was dropped.
- A previously existing encryption wallet was also removed.
- A new encryption wallet was created.

To verify this situation use the following query:

select ts#, name, decode(online$,1,'online',2,'offline',3,'dropped') status,
decode(bitand(flags,16384),16384,'YES') encrypted from ts$;

Check if you have dropped tablespaces that were also encrypted.


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