Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle TDE using wallet

928970Feb 19 2013 — edited Feb 20 2013
Hello 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!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 20 2013
Added on Feb 19 2013
3 comments
559 views