How to Move Wallet_Root into ASM
WALLET_ROOT In How to enable Oracle TDE 19c in RAC DB, we put the wallet in every server of a RAC database. Since the wallet… Read More »How to Move Wallet_Root into ASM
Password-Protected Keystore
How to Resolve ORA-28365: wallet is not open
ORA-28365 There're several possibilities about Transparent Data Encryption (TDE) that throw ORA-28365. Wallet is not configured. You should configure a wallet for your database. Wallet… Read More »How to Resolve ORA-28365: wallet is not open
How to Resolve ORA-46627: keystore password mismatch
ORA-46627 Tried to clone a pluggable database (PDB) with TDE from another PDB, but it failed with ORA-46627. SQL> create pluggable database ORCLPDB2 from ORCLPDB… Read More »How to Resolve ORA-46627: keystore password mismatch
How to Resolve ORA-46697: Keystore password required
ORA-46697 Create Pluggable Database Cloning Local PDB Tried to clone a Pluggable Database (PDB) in the same Container Database (CDB), but it failed with ORA-46697.… Read More »How to Resolve ORA-46697: Keystore password required
How to Resolve ORA-28354: Encryption wallet, auto login wallet, or HSM is already open
ORA-28354 Tried to open the password-protected wallet, but it failed with ORA-28354. SQL> administer key management set keystore open identified by welcome1 container=all; administer key… Read More »How to Resolve ORA-28354: Encryption wallet, auto login wallet, or HSM is already open
How to Resolve ORA-28417: password-based keystore is not open
ORA-28417 Tried to close wallet that we created for transparent data encryption (TDE), but we got ORA-28417 like this: SQL> administer key management set keystore… Read More »How to Resolve ORA-28417: password-based keystore is not open
How to Disable Auto-Login Keystore
Disable Auto-Login Sometimes, you may want to perform some operations directly using an open password-protected keystore without auto-login keystore. To close AUTOLOGIN temporarily, we can… Read More »How to Disable Auto-Login Keystore
How to Enable Oracle TDE 19c Step by Step
Oracle TDE 19c I have talked about how to extract plain text from a normal, non-encrypted data file before. If you're considering a more secure… Read More »How to Enable Oracle TDE 19c Step by Step