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

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World
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/


_____________________________________________________________________________________________________________________

0 comments:

Post a comment

 

acehints.com Copyright 2011-20 All Rights Reserved | Site Map | Contact | Disclaimer