Encryption

How to Resolve ORA-28365: wallet is not open

by Ed Chen
January 3, 2022January 21, 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-46697: Keystore password required

by Ed Chen
December 20, 2021November 5, 2021

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

by Ed Chen
October 25, 2021January 21, 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, 2021January 21, 2022

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, 2021January 21, 2022

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 use OPEN… Read More »

How to Enable Oracle TDE 19c RAC DB

by Ed Chen
August 9, 2021January 21, 2022

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 Resolve ORA-28232: invalid input length for obfuscation toolkit

by Ed Chen
July 17, 2021October 23, 2021

ORA-28232 Developers tried to obfuscate data by DBMS_OBFUSCATION_TOOLKIT in a database with multi-byte character set and got this error. ORA-28232: invalid input length for obfuscation… Read More »

What Can We See in a Normal Data File

by Ed Chen
October 30, 2019August 5, 2021

You might think that the content of a normal data file should be unrecognized binary text and we cannot really see it except using special… Read More »