Failed to open database after Maintenance Reboot (ORA-28374: typed master key not found in wallet)
SQL*Plus: Release 11.2.0.4.0 Production on Fri Sep 29 10:46:06 2023
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
With the Automatic Storage Management option
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
MOUNTED
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-28374: typed master key not found in wallet
ORA-28374: typed master key not found in wallet
SQL> select * from V$ENCRYPTION_WALLET;
WRL_TYPE WRL_PARAMETER STATUS
-------- ------------- ------
file /opt/oracle/dcs/commonstore/wallets/$ORACLE_UNQNAME/tde OPEN
sqlnet.ora
-----------
ENCRYPTION_WALLET_LOCATION=(SOURCE=(METHOD=FILE)(METHOD_DATA=(DIRECTORY=/opt/oracle/dcs/commonstore/wallets/$ORACLE_UNQNAME/tde)))