Ora-28374: Typed Master Key Not Found In Wallet (Doc ID 757936.1)

Last updated on FEBRUARY 06, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 to 11.1.0.7 [Release 11.1]
Information in this document applies to any platform.
Checked for relevance on 14-Feb-2014


Symptoms

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

CREATE TABLESPACE Tablespace_Name DATAFILE
*
ERROR at line 1:
ORA-28374: typed master key not found in wallet

 

Changes

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

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