Why and How to check TDE details in Oracle

 Why ?

TDE is encryption in tablespace level , this will protect the tablespace from works unless the wallet used while created this tablespace is exist and open in the database, you will need to check the status details in DB specially if you are new to manage this DB system or you may need to show auditor / security team the configured things in your DB.

How ?

 

To check TDE in DB use the below :

1- Is tablespace encrypted ?:

SELECT tablespace_name, encrypted, status FROM dba_tablespaces ;

2- Information about the keystore is displayed using the V$ENCRYPTION_WALLET view:

SET LINESIZE 200

COLUMN wrl_parameter FORMAT A50

SELECT * FROM v$encryption_wallet;

3- Details of TDE:

SELECT * FROM V$ENCRYPTION_WALLET;

SELECT * FROM V$ENCRYPTION_KEYS;

SELECT TABLESPACE_NAME, ENCRYPTED FROM DBA_TABLESPACES;

SELECT * FROM V$ENCRYPTED_TABLESPACES;

4- sqlnet.ora will contain the path of created file , you will do this while creating TDE .

 ENCRYPTION_WALLET_LOCATION=

  (SOURCE=(METHOD=FILE)(METHOD_DATA=

    (DIRECTORY=/u01/app/oracle/product/19.0.0/dbhome_1/admin/ORCL/encryption_keystore/)))