Encryption

How to Resolve ORA-28348: index defined on the specified column cannot be encrypted

by Ed Chen
September 16, 2022September 2, 2022

ORA-28348 Tried to encrypt a column, but it failed with ORA-28348: SQL> alter table oe.customers modify (cust_first_name encrypt no salt); alter table oe.customers modify (cust_first_name… Read More »

How to Check Encrypted Table in Oracle

by Ed Chen
May 7, 2022August 22, 2022

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 Check Encrypted Tablespace in Oracle

by Ed Chen
May 6, 2022August 22, 2022

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 Resolve ORA-46669: the target keystore does not exist

by Ed Chen
March 25, 2022March 25, 2022

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 Move Wallet_Root out of ASM

by Ed Chen
March 24, 2022August 21, 2022

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 into ASM

by Ed Chen
March 23, 2022August 21, 2022
2 Comments

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 Resolve ORA-46638: merging of the two keystores failed

by Ed Chen
March 22, 2022March 25, 2022

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-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-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-46627: keystore password mismatch

by Ed Chen
December 21, 2021May 18, 2022

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 »