This discussion is archived
1 Reply Latest reply: Mar 19, 2013 11:39 PM by moreajays RSS

Wallet is still open after closing--Why?

user2017273 Newbie
Currently Being Moderated
Hi,

I have created wallet on my database.I closed wallet. But it is opening while accessing encrypted columns...

Wallet auto login enabled.

DB Version : 10.2.0.5 & 11.2.0.2

1* select * from v$encryption_wallet
SQL> /

WRL_TYPE WRL_PARAMETER STATUS
-------------------- ---------------------------------------- ---------
file /u01/app/oracle/admin/hat/wallet OPEN

SQL> ALTER SYSTEM SET WALLET CLOSE;

System altered.

SQL> select * from v$encryption_wallet;

WRL_TYPE WRL_PARAMETER STATUS
-------------------- ---------------------------------------- ---------
file /u01/app/oracle/admin/hat/wallet CLOSED

SQL> select * from test.tde_test;

ID DATA
---------- --------------------------------------------------
1 This is a secret!

SQL> select * from v$encryption_wallet;

WRL_TYPE WRL_PARAMETER STATUS
-------------------- ---------------------------------------- ---------
file /u01/app/oracle/admin/hat/wallet OPEN

SQL>

Thanks,

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points