ADMINISTER KEY MANAGEMENT SET KEYSTORE

How to Resolve ORA-28365: wallet is not open

by Ed Chen
January 3, 2022March 28, 2022

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-28354: Encryption wallet, auto login wallet, or HSM is already open

by Ed Chen
October 25, 2021May 5, 2022

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-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.