how to check if oracle database is encrypted

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.

Encryption can be present at two Level

TDE ( Transparent Data encryption): This is set up for Table level
TSE (Tablespace encryption): This 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

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