encryption wallet key was automatically closed after ORA-28353
--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');