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;

-------------------- ----------- --------------------------
FILE                 OPEN        /etc/oracle/wallets/PRODSHX/

DBA Tips Data Pump Reference


Post a Comment


dba topics. Copyright 2011-17 All Rights Reserved | Site Map | Contact | Disclaimer | Google