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