Checking Whether a Wallet Is Open or Closed

You can find out if a wallet is open or closed by running the V$ENCRYPTION_WALLET view.

To check whether a wallet is open or closed: 

• In SQL*Plus, query the V$ENCRYPTION_VIEW view as follows:

  SELECT * FROM V$ENCRYPTION_WALLET;
  

  The wallet status appears, similar to the following:

  WRL_TYPE  WRL_PARAMETER                             STATUS
  --------  ----------------------------------------  -------
  file      C:\oracle\product\11.2.0\db_1\wallets     OPEN