V$ENCRYPTION_WALLET

How to Resolve ORA-46659: master keys for the given PDB not found

by Ed Chen
March 7, 2022March 7, 2022

ORA-46659 Saw ORA-46659 when I tried to clone a PDB with TDE remotely through a database link. SQL> create pluggable database ERPAPP_CLONE from ERPAPP@erpapp_link storage… Read More »

How to Resolve ORA-28417: password-based keystore is not open

by Ed Chen
August 30, 2021February 27, 2023
2 Comments

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 Disable Auto-Login Keystore

by Ed Chen
August 29, 2021June 8, 2022

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 Enable Oracle TDE 19c Step by Step

by Ed Chen
August 9, 2021February 12, 2023
8 Comments

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 »

JavaScript is not enabled. Please enable it and reload the page.