Database Security Products (MOSC)

MOSC Banner

encryption wallet key was automatically closed after ORA-28353

edited Oct 1, 2014 5:04AM in Database Security Products (MOSC) 2 commentsAnswered

--Initially create the encryption wallet

alter system set encryption key identified by "sdfg_1234";

SQL>select * from V$ENCRYPTION_WALLET;

WRL_TYPE WRL_PARAMETER STATUS

file /oradata06/wallet OPEN

--reset the master encryption key ,but with the wrong password

alter system set encryption key identified by "abcd_1234";

ORA-28353: failed to open wallet

--query the v$encryption_wallet again and found that the status changes to close status;

SQL>select * from V$ENCRYPTION_WALLET;

WRL_TYPE WRL_PARAMETER STATUS

file /oradata06/wallet CLOSE

--subsequently the closed wallet caused the following errors

**** can not encrypt columns in newly created table

SQL>  create table tt1 (id number encrypt using 'AES192');

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