Recover missing Masterkey – the famous ORA-28374
The client plugged a non-encrypted PDB into a CDB with TDE Encryption Wallet enabled. All works fine, we can read the data. However when trying to create a tablespace we get:
CDB1 SQL> create tablespace TBS_NEW;
Error starting at line : 1 in command -
create tablespace t1
Error report -
ORA-28374: typed master key not found in wallet
28374. 0000 - "typed master key not found in wallet"
*Cause: You attempted to access encrypted tablespace or redo logs with a typed master key not existing in the wallet.
*Action: Copy the correct Oracle Wallet from the instance where the tablespace was created.
What is wrong?
(more…)