How to Check Oracle 11g 12c Database Wallet is Open or Not? v$encryption_wallet

If Oracle wallet is enabled in your oracle database and if you forget to enable the wallet after opening the database you will get following error.

ORA-28365: wallet is not open

In case if you try to access RMAN backup you will get following error message

ORA-19913: unable to decrypt backup

ORA-28365: wallet is not open

There is one data dictionary view v$encryption_wallet for the same to check. 

You can use following query to determine your database wallet is open or not.

select wrl_type wallet,status,wrl_parameter wallet_location from v$encryption_wallet;

WALLET               STATUS      WALLET_LOCATION

-------------------- ----------- --------------------------

FILE                 OPEN        /etc/oracle/wallets/PRODSHX/

See Also: Configure TDE/Wallet