How to List Encrypted Columns
Column Level Encryption In this use case, we have built encryption infrastructure on the database and developers encrypted some columns. Now we would like know… Read More »How to List Encrypted Columns
Encryption
How to List Encrypted Tablespaces
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 »How to List Encrypted Tablespaces
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 TDE Wallet 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 TDE Wallet out of ASM
How to Move TDE Wallet into ASM
Move Wallet into ASM In How to enable Oracle TDE 19c in RAC DB, we put the wallet in every server of a RAC database.… Read More »How to Move TDE Wallet 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 Resolve ORA-46659: master keys for the given PDB not found
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-46659: master keys for the given PDB not found
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