Database Administration (MOSC)

MOSC Banner

"ORA-28374: typed master key not found in wallet" During Wallet creation on 12.2.0.1.0

edited May 27, 2020 5:01AM in Database Administration (MOSC) 2 commentsAnswered

Hi,
we had old wallet with lost password.

Encrypted tablespaces were dropped as it was described here https://support.oracle.com/knowledge/Oracle%20Database%20Products/757936_1.html (Creating Encrypted Tablespace in 11.1 DB Fails Ora-28374: Typed Master Key Not Found In Wallet (Doc ID 757936.1) Last updated on FEBRUARY 04, 2020):

SQL> SELECT tablespace_name, encrypted FROM dba_tablespaces;

TABLESPACE_NAME                ENC

------------------------------ ---

SYSTEM                         NO

SYSAUX                         NO

UNDOTBS1                       NO

TEMP                           NO

USERS                          NO

and when I try to:

SQL> ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY "password";

*

ERROR at line 1:

ORA-28374: typed master key not found in wallet

x$kcbtek shows as we have some encrypted tablespaces:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center