Check wallet is the open status in Oracle

Check the status of wallet in Oracle

Check the status of the wallet in open or closed.

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

WALLET            STATUS         WALLET_LOCATION
----------------- -------------- ------------------------------
FILE              OPEN           C:\ORACLE\ADMIN\XE\WALLET

Status: NOT_AVAILABLE means no wallet present & CLOSED means it’s closed