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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.