When i was trying to add datafile facing below issue on 12c multitenant pluggable-database.
SQL> create tablespace odsprod datafile size 5G;
create tablespace odsprod datafile size 5G
*
ERROR at line 1:
ORA-28374: typed master key not found in wallet
SQL> create tablespace odsprod datafile size 5G;
create tablespace odsprod datafile size 5G
*
ERROR at line 1:
ORA-28374: typed master key not found in wallet
SQL> SELECT wrl_parameter, status, wallet_type FROM v$encryption_wallet;
WRL_PARAMETER
--------------------------------------------------------------------------------
STATUS WALLET_TYPE
------------------------------ --------------------
OPEN_NO_MASTER_KEY AUTOLOGIN
SQL> ALTER SESSION SET CONTAINER = CDB$ROOT;
Session altered.
SQL> SELECT wrl_parameter, status, wallet_type FROM v$encryption_wallet;
WRL_PARAMETER STATUS WALLET_TYPE
------------------------------ --------------------
/u01/oracle/dcs/commonstore/wallets/tde/pdb01_iad1m2/ OPEN AUTOLOGIN
SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE close;
keystore altered.
SQL> ADMINISTER KEY MANAGEMENT SET KEYSTORE open IDENTIFIED BY <admin-password> CONTAINER=all;
keystore altered.
SQL> ALTER SESSION SET CONTAINER =pdb01;
Session altered.
SQL> ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY <admin-password> with backup;
keystore altered.
SQL> SELECT wrl_parameter, status, wallet_type FROM v$encryption_wallet;
WRL_PARAMETER
--------------------------------------------------------------------------------
STATUS WALLET_TYPE
------------------------------ --------------------
OPEN PASSWORD
SQL> create tablespace pdb01 datafile size 5G;
Tablespace created.
No comments:
Post a Comment