What Table Columns are Encrypted?
Column Level Encryption In this use case, we have built encryption infrastructure on the database and developers have encrypted some columns. Now we would like… Read More »What Table Columns are Encrypted?
Transparent Data Encryption (TDE)
What Tablespaces are Encrypted?
Tablespace Level Encryption In this use case, DBA has done encryption infrastructure and create some encrypted tablespaces in the database. Now we would like to… Read More »What Tablespaces are Encrypted?
How to Resolve ORA-46669: the target keystore does not exist
ORA-46669 Tried to merge the target keystore with the source one, but it failed with ORA-46669. SQL> administer key management merge keystore '/u01/app/oracle/product/19.0.0/db_1/admin/ORCLCDB/wallet/tde' identified by… Read More »How to Resolve ORA-46669: the target keystore does not exist
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
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 ORA-46638: merging of the two keystores failed
ORA-46638 There're two error patterns of ORA-46638 in this post. 1. Incorrect Source Location Let's see the source of wallet location. SQL> show parameter wallet_root… Read More »How to Resolve ORA-46638: merging of the two keystores failed
How to Clone PDB with TDE
Before entering our topic, I assumed that you have already know how to clone a PDB to another CDB. In this post, I will show… Read More »How to Clone PDB with TDE
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