Oracle TDE using wallet
928970Feb 19 2013 — edited Feb 20 2013Hello I created a wallet on a 11.2.0.3 RAC database and it is stored on a ACFS filesystem. I am having issues as eventhough i close my wallet, when i query gv$encryption_wallet it still shows wallet as open. Below are the settings on my machine
[oracle@vddb0440a admin]$ cat sqlnet.ora
ENCRYPTION_WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY = /dcldwallet/wallets/$ORACLE_UNQNAME)
)
)
[oracle@vddb0440a admin]$ srvctl getenv database -d dpvl
dpvl:
ORACLE_UNQNAME=dpvl
[oracle@vddb0440a dpvl]$ pwd
/dcldwallet/wallets/dpvl
*[oracle@vddb0440a dpvl]$ ls -ltr*total 8
-rw------- 1 oracle oinstall 1573 Feb 12 20:44 ewallet.p12
-rw------- 1 oracle oinstall 1651 Feb 19 17:28 cwallet.sso
SQL> select * from gv$encryption_wallet;
INST_ID WRL_TYPE
---------- --------------------
WRL_PARAMETER
--------------------------------------------------------------------------------
STATUS
------------------
1 file
/dcldwallet/wallets/$ORACLE_UNQNAME
OPEN
2 file
/dcldwallet/wallets/$ORACLE_UNQNAME
OPEN
SQL> alter system set encryption wallet close ;
System altered.
SQL> select * from gv$encryption_wallet;
INST_ID WRL_TYPE
---------- --------------------
WRL_PARAMETER
--------------------------------------------------------------------------------
STATUS
------------------
1 file
/dcldwallet/wallets/$ORACLE_UNQNAME
OPEN
2 file
/dcldwallet/wallets/$ORACLE_UNQNAME
OPEN
Any idea what am i missing here. Any help would be appreciated. Thanks!