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

This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply