How to check the TDE wallet status in Oracle

Check the TDE keystore (wallet): whether it is open and where it lives. On 12c and later this view also exposes wallet_type and con_id.

SELECT wrl_type, status, wrl_parameter
FROM   v$encryption_wallet;

-- 12c+ also exposes: wallet_type, con_id