Database encryption is an important concept these days because of security breaches. It is common practice to have database encryption enabled in the Oracle database. In this post, we will learn how to check if Oracle database is encrypted i,e how to check tde enabled in Oracle
Encryption can be present at two Level
TDE ( Transparent Data encryption): This is set up for Table level or tablespace level
TSE (Tablespace encryption): This is subset of TDE and it is set up for the Tablespace level
So our checking should be done at both levels
How to check if the Oracle database is encrypted/how to check tde enabled in oracle
To check the wallet or Keystore in the Oracle database
select WRL_PARAMETER, status, WALLET_TYPE from v$encryption_wallet;
To check the Master key in the Wallet
SELECT * FROM V$ENCRYPTION_KEYS;
To check for the encrypted columns in the tables
SET LINESIZE 100 COLUMN owner FORMAT A10 COLUMN table_name FORMAT A20 COLUMN column_name FORMAT A20 SELECT * FROM dba_encrypted_columns;
To check the tablespace level encryption in the Oracle database
SELECT NAME, ENCRYPTIONALG, ENCRYPTEDTS FROM V$ENCRYPTED_TABLESPACES, V$TABLESPACE WHERE V$ENCRYPTED_TABLESPACES.TS# = V$TABLESPACE.TS#;
To check if a particular Tablespace is encrypted
SELECT tablespace_name, encrypted, status FROM dba_tablespaces where tablespace_name = "&tablespace_name"
Following are Encrypted Algorithm existing with Oracle Database
AES192: Sets the key length to 192 bits. AES is the abbreviation for Advanced Encryption Standard.
3DES168: Sets the key length to 168 bits. 3DES is the abbreviation for Triple Data Encryption Standard.
AES128: Sets the key length to 128 bits. This option is the default.
AES256: Sets the key length to 256 bits.
I hope you like this content on how to check if the Oracle database is encrypted
Related Articles
TDE encryption in oracle 11g step by step: Check out this article for TDE encryption in oracle 11g step by step for both table encryption and tablespace encryption
TDE encryption in Oracle 12c step by step
How to open a wallet in Oracle 12c: Check out How to open a wallet in Oracle 12c, How To Import TDE Master Encryption Key, How To Export TDE Master Encryption Key
How to change TDE Keystore Password: check out How to change TDE Keystore Password, How to validate the TDE wallet password with detailed steps
How To Restore TDE Wallet Files From Backup in Oracle Database