How to Move Wallet_Root out of ASM
Move Wallet out of ASM In case that you found it's difficult to manage the wallet in ASM, I provide a way to move it… Read More »How to Move Wallet_Root out of ASM
Auto-Login Keystore
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
How to Resolve OPEN_NO_MASTER_KEY after Cloning PDB
OPEN_NO_MASTER_KEY of AUTOLOGIN After cloning a PDB with TDE into a RAC database, we saw OPEN_NO_MASTER_KEY in the second instance of the new PDB. In… Read More »How to Resolve OPEN_NO_MASTER_KEY after Cloning PDB
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-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