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/


DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

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